提问人:oooo 提问时间:11/2/2023 最后编辑:ADysonoooo 更新时间:11/2/2023 访问量:46
更新数据库后,如何检索该记录?[关闭]
After updating the database how do I retrieve that record? [closed]
问:
我有一个更新记录的 php 文件,但我如何检索该记录。
<?php
include("config.php");
ini_set('display_errors', 'On');
error_reporting(E_ALL);
$executionStartTime = microtime(true);
header('Content-Type: application/json; charset=UTF-8');
$conn = new mysqli($cd_host, $cd_user, $cd_password, $cd_dbname, $cd_port, $cd_socket);
if (mysqli_connect_errno()) {
$output['status']['code'] = "300";
$output['status']['name'] = "failure";
$output['status']['description'] = "database unavailable";
$output['status']['returnedIn'] = (microtime(true) - $executionStartTime) / 1000 . " ms";
$output['data'] = [];
mysqli_close($conn);
echo json_encode($output);
exit;
}
$stmt = $conn->prepare("UPDATE personnel SET firstName = ?, lastName = ?, email = ?, jobTitle = ?, departmentID = ? WHERE id=?");
$stmt->bind_param("ssssii", $_REQUEST['firstName'],$_REQUEST['lastName'],$_REQUEST['emailAddress'],$_REQUEST['jobTitle'],$_REQUEST['departmentID'],$_REQUEST['id']);
$stmt->execute();
$stmt = $conn->prepare("SELECT * FROM `personnel` WHERE `id` = ?");
$stmt->bind_param("i",$_REQUEST['id']);
$stmt->execute();
$result = $stmt->get_result();
echo json_encode($result);
?>
显示记录后,我得到{},为什么会这样,任何帮助将不胜感激。
答: 暂无答案
评论
$row = $result->fetch_array(MYSQLI_NUM);