Php/docs/ref.pdo-sqlite.connection

• PHP Manual
• SQLite (PDO)
• Connecting to SQLite databases

PDO_SQLITE DSN

(PHP 5 >= 5.1.0, PHP 7, PECL PDO_SQLITE >= 0.2.0)

PDO_SQLITE DSN — Connecting to SQLite databases

Description

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

Example #1 PDO_SQLITE DSN examples

The following examples show PDO_SQLITE DSN for connecting to SQLite databases:

sqlite:/opt/databases/mydb.sq3
sqlite::memory:
sqlite: