How to delete mysql records in php

In PHP, you can use the "DELETE FROM" statement to delete records in the data table. The syntax is "DELETE FROM table name WHERE field name = 'field'"; the WHERE clause specifies which records need to be deleted. If If the WHERE clause is omitted, all records will be deleted.

The operating environment of this tutorial: windows7 system, PHP7.1 version, DELL G3 computer

Delete data in the database

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

Syntax

DELETE FROM table_name
WHERE some_column = some_value

Notes: Please note the WHERE clause in DELETE syntax. The WHERE clause specifies which records need 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

Please look at the "Persons" table below:

High Commission Alliance www.cgewang.com

FirstNameLastNameAgePeterGriffin35GlennQuagmire33The following example deletes the "Persons" table All records with LastName='Griffin':

<?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 this deletion, the "Persons" table looks like this:

##FirstNameGlenn Recommended: "

LastName	Age
Quagmire	33

2021 PHP interview questions summary (collection)" "php video tutorial 》

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