How to perform data deletion using PHP and SQLite

How to use PHP and SQLite for data deletion operations

Overview:
Using a database in PHP development is one of the very common requirements, and SQLite is a lightweight database due to its Ease of use and fast performance make it the first choice for PHP developers. This article will introduce how to use SQLite database for data deletion operations in PHP applications and provide corresponding code examples.

Step 1: Create SQLite database and table
Before we begin, we need to create a SQLite database and create a table in it to store the data to be deleted. First, create a database file named "test.db" through the following code, and create a table named "users".

<?php
try {
    $db = new PDO("sqlite:test.db");
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $db->exec("CREATE TABLE IF NOT EXISTS users (
                id INTEGER PRIMARY KEY,
                name TEXT,
                email TEXT
            )");
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>

Step 2: Connect to the SQLite database
Next, we need to connect to the SQLite database. Use the code below to connect to the "test.db" database created earlier.

<?php
try {
    $db = new PDO("sqlite:test.db");
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>

Step 3: Perform the delete operation
Once the connection is successful, we can perform the delete operation. Below is an example of deleting a user record named "John".

<?php
try {
    $db = new PDO("sqlite:test.db");
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $name = "John";
    
    $stmt = $db->prepare("DELETE FROM users WHERE name = :name");
    $stmt->bindParam(':name', $name);
    $stmt->execute();
    
    echo "Record deleted successfully";
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>

Step 4: Close the database connection
After completing all operations, we should close the database connection to release resources. Use the code below to close the SQLite database connection.

<?php
$db = null;
?>

Conclusion:
This article introduces how to use PHP and SQLite to perform data deletion operations. We can easily delete data from SQLite database in PHP application by creating database and table, connecting to database, performing delete operation and closing database connection. Hope this article is helpful to you!

The above is the detailed content of How to perform data deletion using PHP and SQLite. For more information, please follow other related articles on the PHP Chinese website!