HTML表单:
submit.php文件:
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 检查连接 if (!$conn) { die("Connection failed: " . mysqli_connect_error()); }
//获取提交的数据 $name = $_POST['name'];
//查询数据库 $sql = "SELECT * FROM myTable WHERE name='$name'"; $result = mysqli_query($conn, $sql);
//更新数据库 $sql = "UPDATE myTable SET value='New Value' WHERE name='$name'"; if (mysqli_query($conn, $sql)) { echo "Record updated successfully"; } else { echo "Error updating record: " . mysqli_error($conn); }
//关闭连接 mysqli_close($conn); ?> 在执行上述操作之前,请确保已阅读有关SQL注入的安全提示。
上一篇:按钮添加行内样式后无法点击