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. -
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=roopens the database read-only, and unknown parameters are ignored. URI filenames are not available if open_basedir is set.CautionA URI filename can name any file regardless of the end of the DSN, e.g.
sqlite:file:/var/www/data.php?x=.dbopens /var/www/data.php. A DSN built from user input should therefore not be allowed to start withfile:. -
If the DSN consists of the DSN prefix only, a temporary database is used, which is deleted when the connection is closed.
Changelog
| Version | Description |
|---|---|
| 8.1.0 |
Added support for file: URI filenames.
|
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:file:/opt/databases/mydb.sq3?mode=ro sqlite::memory: sqlite:
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
