The SQLite3Stmt class

Introduction

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

SQLite3Stmt

/* Methods */

private __construct(SQLite3 $sqlite3, string $query)

public bool bindParam(stringint $param, mixed &$var, int $type = SQLITE3_TEXT)

public bool bindValue(stringint $param, mixed $value, int $type = SQLITE3_TEXT)

public bool clear()

public true close()

public SQLite3Resultfalse execute()

public stringfalse getSQL(bool $expand = false)

public int paramCount()

public bool readOnly()

public bool reset()

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::__construct — Constructs an SQLite3Stmt object
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