Home >Backend Development >PHP Problem >How to use PHP to realize the click-to-delete operation of a tag

How to use PHP to realize the click-to-delete operation of a tag

PHPzOriginal: 2023-03-23 11:12:001270browse

PHP is a powerful programming language that is widely used in web development. For web developers, the a tag is one of the commonly used HTML elements and is often used to create hyperlinks. However, in actual development, you may encounter situations where you need to delete the corresponding data or entries when clicking the a tag. So, this article will introduce how to use PHP to realize the click-to-delete operation of a tag.

First, we need to understand how to use the MySQL database to store data through PHP. We can use SQL statements to create databases and tables, as well as insert, query, update and delete data. The following is a sample SQL statement:

CREATE DATABASE dbname;
USE dbname;
CREATE TABLE tablename (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
email VARCHAR(50) NOT NULL,
reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
INSERT INTO tablename (name, email)
VALUES ('John Doe', 'john@example.com');
SELECT * FROM tablename;
UPDATE tablename SET email='newemail@example.com' WHERE name='John Doe';
DELETE FROM tablename WHERE name='John Doe';

In the above SQL statement, we created a database named "dbname" and created a table named "tablename". The table contains fields such as id, name, email and reg_date. We inserted a record (John Doe) and performed query, update and delete operations.

Next, we can use PHP code to connect to the MySQL database and execute the above SQL statement. The following is a sample PHP code:

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

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Execute SQL queries
$sql = "INSERT INTO tablename (name, email) VALUES (&#39;John Doe&#39;, &#39;john@example.com&#39;)";
if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>

In practical applications, we may need to use a tag to display data or entries that have been stored in the database and provide delete functionality for them. Below is a sample HTML code to display data from database and delete functionality:

<!DOCTYPE html>
<html>
<head>
    <title>PHP A标签点击删除</title>
</head>
<body>
    <h1>数据库中的数据</h1>
    <?php
    // Connect to database
    $servername = "localhost";
    $username = "username";
    $password = "password";
    $dbname = "dbname";
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }

    // Query database and display results
    $sql = "SELECT * FROM tablename";
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        echo "<table><tr><th>ID</th><th>Name</th><th>Email</th><th>Action</th></tr>";
        while($row = mysqli_fetch_assoc($result)) {
            echo "<tr><td>".$row["id"]."</td><td>".$row["name"]."</td><td>".$row["email"]."</td><td><a href=&#39;delete.php?id=".$row["id"]."&#39;>Delete</a></td></tr>";
        }
        echo "</table>";
    } else {
        echo "0 results";
    }

    mysqli_close($conn);
    ?>
</body>
</html>

In the above example, we are using PHP code to get data from database and using

element in HTML Display it on the page. The delete function is implemented by adding a tag and including the URL of the "delete.php" file and the corresponding record ID. The parameter "id" is used to specify the record to be deleted.

Next, we need to create a PHP file named "delete.php" to receive the delete request from the a tag and perform the delete operation. The following is a sample PHP code:

<?php
// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "dbname";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Delete record
$id = $_GET["id"];
$sql = "DELETE FROM tablename WHERE id=".$id;
if (mysqli_query($conn, $sql)) {
    header("Location: index.php"); // Redirect back to index.php
} else {
    echo "Error deleting record: " . mysqli_error($conn);
}

mysqli_close($conn);
?>

In the above example, we use the $_GET variable to get the parameter "id" from the a tag and use the SQL statement to delete the corresponding record. If the deletion is successful, we will use the header() function to redirect the user back to the main page (index.php) where the data is displayed.

In summary, we have learned how to use PHP and MySQL to implement the click-to-delete function of a tag. During the actual development process, we can modify and expand it according to our own needs to achieve more functions and effects.

The above is the detailed content of How to use PHP to realize the click-to-delete operation of a tag. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：What is the reason why the php website domain name suddenly expires? How to deal with it?Next article：What is the reason why the php website domain name suddenly expires? How to deal with it?

See more

How to use PHP to realize the click-to-delete operation of a tag

Related articles