How to delete data from database using PHP function?

PHP provides a variety of functions for deleting data from the database, including mysqli_query() and mysqli_affected_rows(). These functions can be used according to the following steps: 1. Establish a database connection; 2. Prepare an SQL query; 3. Execute the query; 4 . Check the number of affected rows.

How to use PHP functions to delete data from the database

PHP provides a variety of functions for deleting data from the database. This tutorial will introduce the use of these functions and provide practical examples.

Function

The following are commonly used functions in PHP for deleting database data:

• mysqli_query(): Directly execute SQLDELETEQuery.
• mysqli_affected_rows(): Returns the number of deleted rows.

Usage

To use these functions to delete database data, follow these steps:

1. Establish a database connection:Usemysqli_connect()Function establishes a connection to the database.
2. Prepare SQL query:Write aDELETEquery, specifying the table and conditions to delete data.
3. Execute query:Use themysqli_query()function to execute the query.
4. Check the number of affected rows:Use themysqli_affected_rows()function to check how many rows were deleted.

Practical case

The following is an actual case of deleting all records in the table namedusers:

Executing this code will Delete all records from theuserstable.

The above is the detailed content of How to delete data from database using PHP function?. For more information, please follow other related articles on the PHP Chinese website!