php man page for pdo_sqlite-dsn

Query: pdo_sqlite-dsn

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

PDO_SQLITE-DSN(3)							 1							 PDO_SQLITE-DSN(3)

PDO_SQLITE DSN - Connecting to SQLite databases

	The PDO_SQLITE Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix (SQLite 3)
		- The DSN prefix is sqlite:.

		     o To access a database on disk, append the absolute path to the DSN prefix.

		     o To create a database in memory, append
		       :memory: to the DSN prefix.

	      o 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:.

		     o To access a database on disk, append the absolute path to the DSN prefix.

		     o To create a database in memory, append
		       :memory: to the DSN prefix.

       Example #1

	      PDO_SQLITE DSN examples

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

	      sqlite:/opt/databases/mydb.sq3
	      sqlite::memory:
	      sqlite2:/opt/databases/mydb.sq2
	      sqlite2::memory:

PHP Documentation Group 													 PDO_SQLITE-DSN(3)
Related Man Pages
pdo_sqlsrv-dsn(3) - php
pdo_ibm-dsn(3) - php
pdo_mysql-dsn(3) - php
qpsmtpd::dsn(3pm) - debian
test::database::tutorial(3pm) - debian
Similar Topics in the Unix Linux Community
Simple rules of the UNIX.COM forums:
UNIX.COM 2017 Year End Summary
Please Welcome Ravinder Singh to the Moderation Team
The Order of the Wizard's Hat - Lifetime Achievement Award 2019 - Congrats to Don Cragun