How to delete mysql row in php

In PHP, rows can be deleted from the mysql database table through the DELETE statement. The deletion syntax is "DELETE FROM table_name WHERE some_column = some_value".

The operating environment of this article: Windows7 system, PHP7.1 version, Dell G3 computer

How to delete the mysql line in php?

PHP MySQL Delete: DELETE statement is used to delete rows from a database table.

Delete data in the database

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

Syntax

DELETE FROM table_name
WHERE some_column = some_value

Note: 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:

##The following example deletes all LastName=' in the "Persons" table Griffin's record:

<?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 as follows:

Recommended learning: "

PHP Video Tutorial》

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