PHP specifies deleting a row of the table

In PHP, if you want to delete a row of a specified table in the MySQL database, you can use the following steps:

Step 1: Connect to the MySQL database

First, delete the table line before you need to establish a connection using PHP and the MySQL database. Before connecting, you need to know the database hostname, database username, database password, and database name. Use the following code to connect to the MySQL database:

$conn = mysqli_connect("localhost", "username", "password", "database_name");

Step 2: Write a SQL statement

After the connection is successful, you need to use a SQL statement to delete a row of the table. The following is an example of using the DELETE statement to delete records:

$sql = "DELETE FROM table_name WHERE condition";

In the DELETE statement, table_name refers to the name of the table you want to delete , condition is a conditional statement that specifies which records to delete. For example, if you want to delete the record with id as 1, you can use the following statement:

$sql = "DELETE FROM table_name WHERE id=1";

Step 3: Execute the SQL statement

Once you write the SQL statement, you You need to use the mysqli_query() function to execute it in the database. The following is a complete sample code:

//连接MySQL数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");

//编写SQL语句
$sql = "DELETE FROM table_name WHERE id=1";

//执行SQL语句
if(mysqli_query($conn, $sql)){
    echo "Record deleted successfully.";
} else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($conn);
}

//关闭连接
mysqli_close($conn);

In the above code, if the SQL statement is executed successfully, you will see a message "Record deleted successfully.", if the execution fails, an error message will be displayed.

Summary

Through the above steps, you can use PHP to delete a row of the specified table in the MySQL database. What you need to remember is that you must connect to the database before deleting and use the correct SQL statement to delete records.

The above is the detailed content of PHP specifies deleting a row of the table. For more information, please follow other related articles on the PHP Chinese website!