PHP MySQL Delete
PHP MySQL Delete
The 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 the 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!
To learn more about SQL, visit our SQL tutorial.
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:
Below Example of deleting all records with LastName='Griffin' in the "Persons" table:
<?php
$con=mysqli_connect("localhost","username","password","database");
// 檢測(cè)連接
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 as follows:
