The SQLite3Stmt class

(PHP 5 >= 5.3.0)

Introduction

A class that handles prepared statements for the SQLite 3 extension.

Class synopsis

SQLite3Stmt {

/* Methods */

public bool bindParam ( string $sql_param , mixed &$param [, int $type ] )

public bool bindValue ( string $sql_param , mixed $value [, int $type ] )

public bool clear ( void )

public bool close ( void )

public SQLite3Result execute ( void )

public int paramCount ( void )

public bool reset ( void )

}

SQLite3Stmt::bindParam — Binds a parameter to a statement variable
SQLite3Stmt::bindValue — Binds the value of a parameter to a statement variable
SQLite3Stmt::clear — Clears all current bound parameters
SQLite3Stmt::close — Closes the prepared statement
SQLite3Stmt::execute — Executes a prepared statement and returns a result set object
SQLite3Stmt::paramCount — Returns the number of parameters within the prepared statement
SQLite3Stmt::reset — Resets the prepared statement

Коментарии

Sep 05

Автор: bohwaz


There is an undocumented method "readOnly" in this class, as reported on https://bugs.php.net/bug.php?id=65216



This method can be used like this :



<?php



$db = new SQLite3(':memory:');

$db->exec('CREATE TABLE test (column);');



$stmt  = $db->prepare('SELECT column FROM test;');

var_dump($stmt->readOnly()); // -> true



$stmt  = $db->prepare('INSERT INTO test (42);');

var_dump($stmt->readOnly()); // -> false



?>