SQLite Tutorial in PHP

SQLite is an SQL database manager used locally or on a website, and compatible in particularly with PHP.

Summary

1. Installing SQLite and creating a database.
   Installing SQLite. Verifying the installation by creating a base.
2. Creating and using a SQLite table.
   Creating a table. Deleting a table. Adding a record. Reading a record.
3. How to find and update a post.
   Filling a database. Dump of the whole base. Finding a record by ID. Searching a post. Updating a post.

Download

The complete source code of the scripts in a ZIP archive.

More

SQLite and multi-users. How to treat concurrency issue with SQLite.