Home >Backend Development >PHP Problem >How to implement the delete function in php

How to implement the delete function in php

藏色散人
藏色散人Original
2020-07-31 10:42:103973browse

php delete function can be achieved through the "PHP MySQL Delete" statement, the syntax is "DELETE FROM table_name WHERE some_column = some_value".

How to implement the delete function in php

Recommended: "PHP Video Tutorial"

php delete function:

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:

How to implement the delete function in php

##The following example deletes all LastName=' in the "Persons" table After 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);
?>
在这次删除

, the "Persons" table looks like this:


How to implement the delete function in php

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn