How to Perform Data Deletion Operations Using SQLite in PHP

gitbox 2025-06-30

Introduction

In web development, performing data deletion operations using PHP and SQLite is a common requirement. SQLite is a lightweight database system that operates locally without the need for a server, while PHP is a programming language that depends on a web server. Together, they provide efficient data management. In this article, we will explain in detail how to use SQLite in PHP for data deletion operations, helping you easily delete one or more records.

Connecting to the Database

Before performing SQLite database operations, ensure that SQLite support is enabled in your PHP environment. You can check this by using the phpinfo() function to view the current configuration. Next, you need to set the connection parameters for SQLite, typically including the database name and path. Here is the basic code to set up the SQLite connection:


$dbname = "test.db"; // Database name
$dbpath = __DIR__ . "/"; // Data file directory
$dsn = "sqlite:" . $dbpath . $dbname; // Data Source Name (DSN)

After configuring, we can use PHP's PDO class to connect to the SQLite database:


try {
    $pdo = new PDO($dsn);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

Note that when connecting to the SQLite database, the Data Source Name (DSN) must begin with sqlite:.

Performing the Deletion Operation

To perform the deletion operation, we need to construct an SQL query and use the prepare() function to parameterize the query, preventing SQL injection attacks. In the following example, we will delete records that meet the specified condition:


$id = "1"; // Deletion condition
$sql = "DELETE FROM users WHERE id = :id";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
if ($stmt->execute()) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record";
}

In this example, we use the bindParam() method to bind the parameter to the placeholder in the SQL query, ensuring the security of the deletion operation.

Conclusion

This article explains how to perform data deletion operations using PHP and SQLite. After connecting to the database via PDO, you can construct and execute SQL queries with placeholders to securely delete records. In practical applications, it is recommended to thoroughly test the operation to ensure the security and stability of the system.

phpinfo