How to delete data from database in php

php method to delete data from the database: use the delete from statement combined with the mysqli_query function to delete, such as [mysqli_query($con,"DELETE FROM Persons WHERE LastName='A'")].

Delete statement:

DELETE FROM statement is used to delete records from a database table.

(Recommended learning tutorial: mysql tutorial)

Grammar:

DELETE FROM table_name
WHERE some_column = some_value

Note:

WHERE clause specifies which records Needs to be deleted. If you want to omit the WHERE clause, all records will be deleted!

In order for PHP to execute the above statement, we must use the mysqli_query() function. This function is used to send a query or command to the MySQL connection.

Example:

"Persons" table

The following example deletes all records with LastName='Griffin' in the "Persons" table :

<?php
$con=mysqli_connect("localhost","username","password","database");
// 检测连接
if (mysqli_connect_errno()){    
    echo "连接失败: " . mysqli_connect_error();
}
mysqli_query($con,"DELETE FROM Persons WHERE LastName=&#39;Griffin&#39;");
mysqli_close($con);
?>

After deletion, the Persons table looks as follows:

Related recommendations: php training

The above is the detailed content of How to delete data from database in php. For more information, please follow other related articles on the PHP Chinese website!