PHP offers two extensions that allow you to work with SQLite effectively:
PDO_SQLITE– is a driver that allows you to access multiple databases including SQLite, via a uniform interface (PDO).sqlite3– is a driver that offers a more direct interface to SQLite, allowing you to access SQLite databases using its specific methods.
In this tutorial series, we’ll show you how to interact with SQLite using the PDO_SQLITE driver.
Section 1. Getting Started #
In this section, you’ll learn how to create a new SQLite database from PHP, connect to an existing SQLite database file, and create new tables in SQLite.
- Connecting to SQLite database – Show you how to create a new SQLite database and connect to an existing SQLite database in PHP using PDO.
- Creating SQLite tables using PDO – Guide you on creating new tables in the SQLite database by executing CREATE TABLE statements from PHP.
Section 2. Performing CRUD operations #
CRUD stands for create, read, update, and delete. This section shows you how to insert, update, query, and delete data from a table in PHP.
- Inserting data into a table – Show how to insert data into a table in PHP.
- Updating data – Walk you through the steps of updating data in a table in PHP.
- Querying data – Show you various ways to query data from tables in PHP.
- Deleting data – Provides steps for deleting data from a table in PHP.
Section 3. Handling BLOB data #
This section shows you how to store documents in SQLite databases as BLOB and how to retrieve them for display on web browsers.
- Working with SQLite3 BLOB data – Show you how to store documents (PDF files, Images…) directly in the SQLite database.
Section 4. Managing Transactions #
This section lets you manage multiple database operations as a transaction to ensure data integrity.
- Managing Transactions – Learn how to manage multiple database operations as a transaction in PHP.
Was this tutorial helpful?
Thank you for your feedback!
