How to delete a piece of information from a table in php (sample code)

PHP is a server-side scripting language widely used in Web development. It is also very simple to implement the code to delete a table information.

1. First, we need to connect to the database and select the database to use. Assume that our table is named mytable and the connection is named $conn. You can use The following code:

$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

2. Next, we need to get the primary key value of the row we want to delete, assuming our primary key is id, and store it in a In the variable $id, you can use the following code:

$id = $_GET['id'];

Here we use $_GET to get the passed from the client to the background. id value.

3. Then, we need to write a SQL statement to perform the delete operation. You can use the following code:

$sql = "DELETE FROM mytable WHERE id=$id";

The DELETE statement is used here to delete mytableThe row with id=$id in the table.

4. Finally, we need to execute the SQL statement and output the results. You can use the following code:

if (mysqli_query($conn, $sql)) {
    echo "删除成功";
} else {
    echo "删除失败: " . mysqli_error($conn);
}

The mysqli_query function is used here to execute the SQL statement , and use the mysqli_error function to output error information when an error occurs, and if the deletion is successful, "deletion successful" is output.

The complete code is as follows:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 检测连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 获取要删除的行的主键值
$id = $_GET[&#39;id&#39;];

// 执行 SQL 删除语句
$sql = "DELETE FROM mytable WHERE id=$id";

if (mysqli_query($conn, $sql)) {
    echo "删除成功";
} else {
    echo "删除失败: " . mysqli_error($conn);
}

mysqli_close($conn);
?>

The above is the PHP code implementation for deleting a table information.

The above is the detailed content of How to delete a piece of information from a table in php (sample code). For more information, please follow other related articles on the PHP Chinese website!