我希望每次在数据库表中设置新值或相同值时都覆盖数据。我读了很多文章,但是我还是不懂UPDATE命令。
这只是我项目中一个示例测试的基础测试文件。
php
<?php
$servername = "localhost";
$username = "root";
$password = "00000000";
$dbname = "test";
//create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$name = $_POST["name"];
$lastname = $_POST["lastname"];
//echo $name," ",$lastname;
$insertsql = "UPDATE user SET name ='$name' lastname='$lastname' ";
if($conn->query($insertsql) === TRUE){
echo "update ok";
}
else{
echo "Error :" . $insertsql . "<br>" . $conn->error;
}
$conn->close();
?>