正在尝试更新记录,无法从database.Getting获取数据,空白页无法从数据库获取任何数据。
<?php
include 'includes/db.php';
$id = (int)$_GET['appoint_id'];
$sql = "SELECT * FROM appointment WHERE appoint_id = '$id'";
$run = mysqli_query($conn,$sql);
while ($row = mysqli_fetch_assoc($run)){
$firstname = $row['first_name'];
$lastname = $row['last_name'];
}
?>
<form class="form-horizontal" action="update.php" method="post" role="form">
<input type='hidden' value='<?=$id;?>' name='appoint_id'>
<div class="body">
<div class="row clearfix">
<div class="col-sm-6 col-xs-12">
<div class="form-group">
<div class="form-line">
<input type="text" class="form-control" value="<?php echo $row['first_name'];?>" name="first_name" id="first_name" required>
</div>
</div>
</div>
<div class="col-sm-6 col-xs-12">
<div class="form-group">
<div class="form-line">
<input type="text" class="form-control" value="<?php echo $row['last_name'];?>" name="last_name" id="last_name" required>
</div>
</div>
</div>
</div>
</div>
</form>
update.php
<?php include 'includes/db.php';
if(isset($_POST['submit_user'])){
$ins_sql = "UPDATE first_name,last_name appointment WHERE appoint_id = '$id' ";
$run_sql = mysqli_query($conn,$ins_sql);
}else {
echo "not updated";
}
?>
也不在错误日志中显示任何错误。
发布于 2018-06-09 18:54:52
?php session_start();
include 'includes/db.php';
$id = (int)$_GET['id'];
$sql = "SELECT * FROM appointment WHERE appoint_id = $id";
$oppointArr =array();
$result = mysqli_query($conn,$sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_array($result)) {
$oppointArr = $row;
echo "Name: " . $row["first_name"]. "<br>";
}
} else {
echo "0 results";
}
//mysqli_close($conn);
?>
用于获取特定记录的数据的查询
发布于 2018-06-09 04:28:32
update.php
的UPDATE
查询语法不正确,并且它没有使用任何表单参数(除了表单中不存在的参数$_POST['submit_user']
)。
您应该使用预准备语句来防止SQL注入。
<?php
include 'includes/db.php';
$ins_sql = "UPDATE appointment
SET first_name = ?, last_name = ?
WHERE appoint_id = ?";
$stmt = $conn->prepare($ins_sql);
$stmt->bind_param("ssi", $_POST['first_name'], $_POST['last_name'], $_POST['appoint_id']);
if ($stmt->execute()) {
echo "updated";
} else {
echo "not updated";
}
https://stackoverflow.com/questions/50767634
复制相似问题