文字

SQLite3::prepare

(PHP 5 >= 5.3.0)

SQLite3::preparePrepares an SQL statement for execution

说明

public SQLite3Stmt SQLite3::prepare ( string $query )

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

参数

query

The SQL query to prepare.

返回值

Returns an SQLite3Stmt object on success 或者在失败时返回 FALSE .

范例

Example #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 ());
?>

用户评论:

[#1] pavel dot lisa at centrum dot cz [2010-10-12 02:20:12]

SQLite3::prepare() will fail, if you pass in a WHERE clause (in the $query) referring to a non-existent column.

上一篇: 下一篇: