The SQLite3Stmt class

Introduction

(PHP 5 >= 5.3.0, PHP 7)

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

Class synopsis

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

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

public clear ( ) : bool

public close ( ) : bool

public execute ( ) : SQLite3Result

public getSQL ([ bool $expanded = false ] ) : string|false

public paramCount ( ) : int

public readOnly ( ) : bool

public reset ( ) : bool

Table of Contents

• 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::getSQL — Get the SQL of the statement
• SQLite3Stmt::paramCount — Returns the number of parameters within the prepared statement
• SQLite3Stmt::readOnly — Returns whether a statement is definitely read only
• SQLite3Stmt::reset — Resets the prepared statement