array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'zh', ), 'this' => array ( 0 => 'ref.pdo-sqlite.connection.php', 1 => 'PDO_SQLITE DSN', 2 => 'Connecting to SQLite databases', ), 'up' => array ( 0 => 'ref.pdo-sqlite.php', 1 => 'SQLite PDO Driver', ), 'prev' => array ( 0 => 'ref.pdo-sqlite.php', 1 => 'SQLite PDO Driver', ), 'next' => array ( 0 => 'pdo.sqlitecreateaggregate.php', 1 => 'PDO::sqliteCreateAggregate', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/pdo_sqlite/reference.xml', ), 'history' => array ( ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); contributors($setup); ?>

PDO_SQLITE DSN

(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:

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.

示例

示例 #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: