SQLite3::prepare

(PHP 5 >= 5.3.0)

SQLite3::preparePrepares an SQL statement for execution

Descrição

public SQLite3Stmt SQLite3::prepare ( string $query )

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

Parâmetros

query

The SQL query to prepare.

Valor Retornado

Returns an SQLite3Stmt object on success ou FALSE em caso de falha.

Exemplos

Exemplo #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'1SQLITE3_INTEGER);

$result $stmt->execute();
var_dump($result->fetchArray());
?>

add a note add a note

User Contributed Notes 1 note

up
1
pavel dot lisa at centrum dot cz
3 years ago
SQLite3::prepare() will fail, if you pass in a WHERE clause (in the $query) referring to a non-existent column.
To Top