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:
SQLite PDO Driver
SQLite PDO Driver