Home > Article > Backend Development > 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 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. ExamplePlease look at the "Persons" table below:High Commission Alliance www.cgewang.com
LastName | Age | |
---|---|---|
Griffin | 35 | |
Quagmire | 33 |
<?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:
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!