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:
