Delete statement is used to delete a record from PHP MySQL database, the syntax used to delete the record from table is:-
delete from table name
where some_column=some_value
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();

mysqli_query($con,"DELETE FROM Persons WHERE LastName="'lname'");


Th above code is used to execute the delete statement by using the mysqli_query function. These is used to sen a command to MySQL connection.