SQLite3::prepare
(PHP 5 >= 5.3.0, PHP 7, PHP 8)
SQLite3::prepare — Prepares an SQL statement for execution
Description
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
<?php
$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
- SQLite3Stmt::paramCount() - Returns the number of parameters within the prepared statement
- SQLite3Stmt::bindValue() - Binds the value of a parameter to a statement variable
- SQLite3Stmt::bindParam() - Binds a parameter to a statement variable
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
