大网数据广告活动
PHP 语言与运行手册

PDO_SQLITE DSN · Connecting to SQLite databases

· 52CE 我爱测

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

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=ro opens the database read-only, and unknown parameters are ignored. URI filenames are not available if open_basedir is set.

    Caution

    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.

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。离线整理了版式、链接和媒体显示。

资料来源与适用范围

资料来源
PHP Documentation Group
适用范围
请按文中版本与环境说明核对
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。