|
|
Querying a database using open source voice control software
|
|
SQLITE3.OPEN(3) SQLITE3.OPEN(3) SQLite3::open - Opens an SQLite database SYNOPSIS
public void SQLite3::open (string $filename, [int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE], [string $encryption_key]) DESCRIPTION
Opens an SQLite 3 Database. If the build includes encryption, then it will attempt to use the key. PARAMETERS
o $filename - Path to the SQLite database, or :memory: to use in-memory database. o $flags - Optional flags used to determine how to open the SQLite database. By default, open uses SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE. o SQLITE3_OPEN_READONLY: Open the database for reading only. o SQLITE3_OPEN_READWRITE: Open the database for reading and writing. o SQLITE3_OPEN_CREATE: Create the database if it does not exist. o $encryption_key - An optional encryption key used when encrypting and decrypting an SQLite database. RETURN VALUES
No value is returned. EXAMPLES
Example #1 SQLite3.open(3) example <?php /** * Simple example of extending the SQLite3 class and changing the __construct * parameters, then using the open method to initialize the DB. */ class MyDB extends SQLite3 { function __construct() { $this->open('mysqlitedb.db'); } } $db = new MyDB(); $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()); ?> PHP Documentation Group SQLITE3.OPEN(3)
