Php/docs/sqlite3.prepare

From Get docs

SQLite3::prepare

(PHP 5 >= 5.3.0, PHP 7)

SQLite3::preparePrepares an SQL statement for execution


Description

public SQLite3::prepare ( string $query ) : SQLite3Stmt|false

Prepares an SQL statement for execution and returns an SQLite3Stmt object.


Parameters

query
The SQL query to prepare.


Return Values

Returns an SQLite3Stmt object on success or FALSE on failure.


Examples

Example #1 SQLite3::prepare() example

<?phpunlink('mysqlitedb.db');$db = new SQLite3('mysqlitedb.db');$db->exec('CREATE TABLE foo (id INTEGER, bar STRING)');$db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')");$stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id');$stmt->bindValue(':id', 1, SQLITE3_INTEGER);$result = $stmt->execute();var_dump($result->fetchArray());?>

See Also