Home  >  Article  >  Backend Development  >  How to delete mysql records in php

How to delete mysql records in php

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-04-19 16:56:012195browse

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.

How to delete mysql records in php

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

FirstNameLastNameAgePeterGriffin35GlennQuagmire33
The 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!

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