PHPMySQLDelete

DELETE statement is used to delete rows from a database table.

Delete data in database

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

grammar

 DELETE FROM table_nameWHERE 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 tutorials.

In order for PHP to execute the above statement, we must use the mysqli_query() function. This function is used to send queries or commands to the MySQL connection.

Example

Please look at the "Persons" table below:

The following example deletes all records with LastName='Griffin' in the "Persons" table:

 <?php$con=mysqli_connect("localhost","username","password","database");//Detect connection if (mysqli_connect_errno()){ echo "Connection failed: " . mysqli_connect_error();}mysqli_query( $con,"DELETE FROM Persons WHERE LastName='Griffin'");mysqli_close($con);?>

After this deletion, the "Persons" table looks like this: