WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

PHP Delete Data From MySQL

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


Delete data from the database

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

Syntax

DELETE FROM table_name
WHERE some_column = some_value

Note: 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, please 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 a MySQL connection.

Example

Look at the "Persons" table below:

FirstName LastName Age
Peter Griffin 35
Glenn Quagmire 33

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:

FirstName LastName Age
Glenn Quagmire 33


Welookups is optimized for learning.Copy right 2018 - 2019 kumar aditya singh .
All Right Reserved and you agree to have read and accepted our term and condition.
All Rights Reserved.

welookups.com