Home/ Manual/ reference / pdo_sqlite/ SQLite PDO Driver (PDO_SQLITE)

SQLite PDO Driver (PDO_SQLITE)

Guide Edit on GitHub ✎

PDO_SQLITE is a driver that implements the PHP Data Objects (PDO) interface to enable access to SQLite 3 databases.

Intro

PDO_SQLITE is a driver that implements the PHP Data Objects (PDO) interface to enable access to SQLite 3 databases.

Note

PDO_SQLITE allows using strings apart from streams together with PDO::PARAM_LOB.

Configure

PDO_SQLITE DSNConnecting to SQLite databasesDescription The PDO_SQLITE Data Source Name (DSN) is composed of the following elements: DSN prefix (SQLite 3)The DSN prefix is sqlite:. To access a database on disk, the absolute path has to be appended to the DSN prefix.To create a database in memory, :memory: has to be appended to the DSN prefix.If the DSN consists of the DSN prefix only, a temporary database is used, which is deleted when the connection is closed.Examples PDO_SQLITE DSN examplesThe following examples show PDO_SQLITE DSN for connecting to SQLite databases: sqlite:/opt/databases/mydb.sq3 sqlite::memory: sqlite: Pdo-overloaded

Source: reference/pdo_sqlite/reference.xml · from the official PHP manual (php/doc-en)