you can update data from database
syntax
<?php
$sql =
"UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value"
? >
<!DOCTYPE html>
<html>
<body>
<?php
# if statement in php
$conn
= mysqli_connect("localhost","root","","firstTable");
$sql
= "UPDATE MyGuests SET lastname='Doe' WHERE id=2
if
($conn->query($sql) === TRUE) {
echo
"Data updated successfully";
}else {
echo
"Error updating into table: " . $conn->error;
$conn->close();
}
?>
</body>
</html>