Manuel PHP
SQLite3::prepare
(No version information available, might be only in CVS)
SQLite3::prepare — Prepares an SQL statement for execution
Description
public SQLite3_stmt SQLite3::prepare
( string $query
)
Prepares an SQL statement for execution and returns an SQLite3_stmt object.
Liste de paramètres
- query
-
The SQL query to prepare.
Valeurs de retour
Returns an SQLite3_stmt object on success or FALSE on failure.
Exemples
Exemple #1 SQLite3::prepare() example
- <?php
- unlink('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());
- ?>
Remonter 
