(PHP 5 >= 5.3.0, PHP 7, PHP 8)
SQLite3::prepare โ Prepares an SQL statement for execution
Prepares an SQL statement for execution and returns an SQLite3Stmt object.
queryThe SQL query to prepare.
Returns an SQLite3Stmt object on success ๆ่
ๅจๅคฑ่ดฅๆถ่ฟๅ false.
็คบไพ #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());
?>