php
  1. php-delete
PreviousNext

PHP DELETE

The PHP DELETE statement is used to delete records from a table in the database. It is one of the four basic operations (CRUD) that can be performed on a database.

Syntax

The syntax for the PHP DELETE statement is:

$connection = mysqli_connect('localhost', 'username', 'password', 'database_name');
$query = "DELETE FROM table_name WHERE condition";
mysqli_query($connection, $query);
  • mysqli_connect: creates a new connection to the MySQL server.
  • DELETE FROM table_name: specifies the name of the table to delete records from.
  • WHERE condition: specifies the condition that must be met for a record to be deleted.

Example

Let's say we have a table named users with the following data:

id name email
1 John john@example.com
2 Sarah sarah@example.com
3 Michael michael@example.com

To delete the user with id equal to 2, we can use the following PHP code:

$connection = mysqli_connect('localhost', 'username', 'password', 'database_name');
$query = "DELETE FROM users WHERE id=2";
mysqli_query($connection, $query);

Output

The PHP DELETE statement does not have a specific output. If the statement is successful, the record will be deleted from the table. If the statement is not successful, an error message will be displayed.

Explanation

The PHP DELETE statement removes one or more rows from a table. The WHERE clause is used to select the rows to be deleted. If the WHERE clause is omitted, all rows in the table will be deleted.

It is important to note that the DELETE statement is a permanent action and cannot be undone. Be careful when using this statement.

Use

The PHP DELETE statement is used to delete data from a table in a database. This can be useful when removing old or unwanted data, updating records, or cleaning up a database.

Important Points

  • The PHP DELETE statement is used to delete records from a table in a database.
  • The WHERE clause is used to select the rows to be deleted. If the WHERE clause is omitted, all rows in the table will be deleted.
  • The DELETE statement is a permanent action and cannot be undone. Be careful when using this statement.

Summary

The PHP DELETE statement is an important tool for deleting records from a table in a database. It is a permanent action, so be careful when using it. Use the WHERE clause to select the rows to be deleted.

UPDATESELECT
Published on: