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.