(PHP 5 >= 5.1.0, PHP 7, PECL PDO_SQLITE >= 0.2.0)
PDO_SQLITE DSN — Connecting to SQLite databases
The PDO_SQLITE Data Source Name (DSN) is composed of the following elements:
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.
A DSN starting with file: after the DSN prefix
is passed to SQLite unchanged as a
» URI filename.
Its query parameters set options, e.g. mode=ro
opens the database read-only, and unknown parameters are ignored.
URI filenames are not available if
open_basedir is set.
A URI filename can name any file regardless of the end of the DSN,
e.g. sqlite:file:/var/www/data.php?x=.db opens
/var/www/data.php.
A DSN built from user input should therefore not be allowed to
start with file:.
If the DSN consists of the DSN prefix only, a temporary database is used, which is deleted when the connection is closed.
| Version | Description |
|---|---|
| 8.1.0 |
Added support for file: URI filenames.
|
Example #1 PDO_SQLITE DSN examples
The following examples show PDO_SQLITE DSN for connecting to SQLite databases:
sqlite:/opt/databases/mydb.sq3 sqlite:file:/opt/databases/mydb.sq3?mode=ro sqlite::memory: sqlite: