SQLite3::__construct

(PHP 5 >= 5.3.0)

SQLite3::__construct — Instantiates an SQLite3 object and opens an SQLite 3 database

Описание

SQLite3::__construct ( string $filename [, int $flags [, string $encryption_key ]] )

Instantiates an SQLite3 object and opens a connection to an SQLite 3 database. If the build includes encryption, then it will attempt to use the key.

Параметри

filename

Path to the SQLite database.

flags

Optional flags used to determine how to open the SQLite database. By default, open uses SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE.

SQLITE3_OPEN_READONLY: Open the database for reading only.
SQLITE3_OPEN_READWRITE: Open the database for reading and writing.
SQLITE3_OPEN_CREATE: Create the database if it does not exist.

encryption_key

An optional encryption key used when encrypting and decrypting an SQLite database.

Връщани стойности

Returns an SQLite3 object on success.

Примери

Example #1 SQLite3::__construct() example


<?php
$db = new SQLite3('mysqlitedb.db');

$db->exec('CREATE TABLE foo (bar STRING)');
$db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");

$result = $db->query('SELECT bar FROM foo');
var_dump($result->fetchArray());
?>

SQLite3::createAggregate

SQLite3::close

[edit] Last updated: Fri, 18 Sep 2009

add a note User Contributed Notes SQLite3::__construct

Anonymous 28-Apr-2012 11:32


Construct will fail if \ backslash is used in the database path,

use / forward slash instead for directory separators.

anton dot grbin at carnet dot hr 17-Apr-2012 08:27


An exception will be thrown if __construct fails.



PHP Fatal error:  Uncaught exception 'Exception' with message 'Unable to open database: unable to open database file' in ...

bohwaz 16-May-2011 10:59


$encryption_key and all encryption features will be enabled only if the SQLite encryption module is installed. It's a proprietary, costly module. So if it's not present, supplying an encryption key will have absolutely no effect.

add a note