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, append the absolute path to the DSN prefix.
To create a database in memory, append memory: to the DSN prefix.

DSN prefix (SQLite 2)

The SQLite extension in PHP 5.1 provides a PDO driver that supports accessing and creating SQLite 2 databases. This enables you to access databases you may have created with the SQLite extension in previous versions of PHP.

Note:

The sqlite2 driver is only available in PHP 5.1.x if you have enabled both PDO and ext/sqlite. It is not currently available via PECL.

The DSN prefix for connecting to SQLite 2 databases is sqlite2:.

To access a database on disk, append the absolute path to the DSN prefix.
To create a database in memory, append :memory: to the DSN prefix.

Examples

Example 2340. PDO_SQLITE DSN examples

The following examples show PDO_SQLITE DSN for connecting to SQLite databases:

copy to clipboard

sqlite:/opt/databases/mydb.sq3

sqlite::memory:

sqlite2:/opt/databases/mydb.sq2

sqlite2::memory:

PDO_SQLITE DSN

Connecting to SQLite databases ()

Examples

Example 2340. PDO_SQLITE DSN examples

Code Examples / Notes » ref.pdo_sqlite.connection

Change Language