php按钮数据库,php – 使用提交按钮更新数据库数据

像这样：

function updater($value,$id){

// Create connection

$conn = new mysqli( 'localhost' , 'user_name' , 'pass' ,'data_base_name' );

$value =mysqli_real_escape_string($conn,$value);

$id =mysqli_real_escape_string($conn,$id);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "UPDATE table_name SET name='{$value}' WHERE id='{$id}'";

if ($conn->query($sql) === TRUE) {

echo "Record updated successfully";

} else {

echo "Error updating record: " . $conn->error;

}

$conn->close();

}

if(isset($_POST['name'])){

updater($_POST['name'],$_POST['id'])

}

?>