上海城投水务(集团)有限公司 (上海城投水务水费账单查询)

connect_error) {die("连接失败: " . $conn->connect_error);}// 接收搜索词$searchTerm = $_POST['search-term'];// 构建查询$sql = "SELECT FROM water_bills WHERE account_number LIKE '%$searchTerm%' OR name LIKE '%$searchTerm%'";// 执行查询$result = $conn->query($sql);// 检查结果if ($result->num_rows > 0) {echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";// 输出结果while($row = $result->fetch_assoc()) { echo "";echo "";echo "";echo "";echo "";echo "";echo "";}echo "";echo "

户号	姓名	地址	水费金额	状态
" . $row['account_number'] . "	" . $row['name'] . "	" . $row['address'] . "	" . $row['amount'] . "	" . $row['status'] . "

";// 分页$page = $_GET['page'];if (!isset($page)) {$page = 1;}$resultsPerPage = 10;$totalPages = ceil($result->num_rows / $resultsPerPage);if ($page > 1) {echo " 上一页 ";}for ($i = 1; $i <= $totalPages; $i++) {echo " " . $i . " ";}if ($page < $totalPages) {echo " 下一页 ";}} else {echo "没有找到匹配的结果";}// 关闭连接$conn->close();?>