insert ข้อมูลไม่ได้ ไม่รู้ว่าเป็นที่อะไรคะ หาไม่เจอช่วยดูหน่อย
string(136) "INSERT INTO employee(emp_name,emp_surname,emp_email,status,rule_id) VALUES('a1','a2','it@gmail.com','1234','1','2')"
<?php
session_start();
include_once '../inc/dbconnect.php';
if(!isset($_SESSION['empSession']))
{
header("Location: index.php");
}
//echo "<pre>";
//print_r($_POST);
//echo "</pre>";
$query = $MySQLi_CON->query("SELECT * FROM employee WHERE emp_id=".$_SESSION['empSession']);
$userinfo=$query->fetch_array();
if(isset($_POST['btn-save']))
{
// variables for input data
$emp_name = $MySQLi_CON->real_escape_string(trim($_POST['emp_name']));
$esurname = $MySQLi_CON->real_escape_string(trim($_POST['emp_surname']));
$email = $MySQLi_CON->real_escape_string(trim($_POST['emp_email']));
$epassword = $MySQLi_CON->real_escape_string(trim($_POST['password']));
$status = $MySQLi_CON->real_escape_string(trim($_POST['status']));
$rule_id = $MySQLi_CON->real_escape_string(trim($_POST['rule_id']));
// sql query for inserting data into database
$query = "INSERT INTO employee(emp_name,emp_surname,emp_email,status,rule_id)
VALUES('$emp_name','$esurname','$email','$epassword','$status','$rule_id')";
mysql_query($query);
mysql_close();
var_dump($query);
/*echo "<pre>";
print_r($_POST);
echo "</pre>";*/
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome - <?php echo $userinfo['emp_email']; ?></title>
<!-- Bootstrap -->
<link href="asset/css/bootstrap.min.css" rel="stylesheet">
<style>
.content {
margin-top: 80px;
}
</style>
</head>
<body>
<!-- .nav menu start -->
<!-- .nav menu end -->
<tr>
<td colspan="2" class="green"><? include ('menu_backend.php');?></td>
</tr>
<div class="container">
<div class="content">
<h2>Add Employee</h2>
<hr />
</div>
<br>
</form>
<br />
<div class="container">
<form method='post'>
<!-- <form action="employee_add2.php" method="post"> -->
<table class='table table-bordered'>
<tr>
<td>First Name</td>
<td><input type='text' name='emp_name' class='form-control' required></td>
</tr>
<tr>
<td>Last Name</td>
<td><input type='text' name='emp_surname' class='form-control' ></td>
</tr>
<tr>
<td>Email</td>
<td><input type='text' name='emp_email' class='form-control' ></td>
</tr>
<tr>
<td>Password</td>
<td><input type='password' name='password' class='form-control' ></td>
</tr>
<tr>
<td>Status</td>
<td><input type='text' name='status' class='form-control' ></td>
</tr>
<tr>
<td>Rule</td>
<td><input type='text' name='rule_id' class='form-control' ></td>
</tr>
<tr>
<td colspan="2">
<button type="submit" class="btn btn-primary" name="btn-save">
<span class="glyphicon glyphicon-plus"></span> Add New </button>
<a href="index.php" class="btn btn-large btn-success"><i class="glyphicon glyphicon-backward"></i> Back </a>
</td>
</tr>
</table>
</form>
</div>
</div><center>
</center>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>