<?php
$server = '127.0.0.1';
$user = 'root';
$password = '';
$database = 'yiibaidb';
$officecode = $_POST['officecode'];
$conn = new mysqli($server, $user, $password, $database);
if ($conn->errno) {
die("数据库连接失败！" . $conn->error);
}
$sql = 'SELECT * FROM employees where officeCode=' . "'$officecode'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$arr = array();
while ($row = $result->fetch_assoc()) {
$arr[] = $row;
}
echo json_encode($arr);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<link rel="stylesheet" href="css/bootstrap4.css">
<script src="js/jquery-3.3.1"></script>
<title>Document</title>
</head>
<body style="padding-top:30px">
<div class="container">
<input type="text" name="Offcode" id="Offcode">
<button id="btnQuery">查询</button>
<div id="table"></div>
</div>
<script>
$(function () {
$("#btnQuery").click(function () {
$.ajax({
type: "post",
url: "json.php",
data: { 'officecode': $("#Offcode").val() },
dataType: "json",
success: function (response) {
$("#tab").remove();
var item;
item = "<table id=\"tab\" class=\"table table-bordered table-sm\"> <tr> <th>firstName</th> <th>lastName</th> <th>email</th> </tr>"
$.each(response, function (index, value) {
item += '<tr><td>' + value.firstName + '</td><td>' + value.lastName + '</td><td>' + value.email + '</td></tr>';
});
item += "</table>";
$("#table").append(item);
}
});
});
});
</script>
</body>
</html>
