Home >Backend Development >PHP Problem >How to delete a piece of information from the database in php
#How to delete a piece of information from the database in php?
Please look at the "Persons" table below:
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='Griffin'");
mysqli_close($con);
?>After this deletion, the "Persons" table looks like this:
For more PHP related knowledge, please visit PHP Chinese net!
The above is the detailed content of How to delete a piece of information from the database in php. For more information, please follow other related articles on the PHP Chinese website!