Longhorn PHP 2025 - Call For Papers

SQLite3Stmt::bindParam »

« SQLite3Exception

The SQLite3Stmt class

(PHP 5 >= 5.3.0, PHP 7, PHP 8)

Introduction

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

Class synopsis

class SQLite3Stmt {

/* Methods */

private __construct(SQLite3 $sqlite3, string $query)

public bindParam(string|int $param, mixed &$var, int $type = SQLITE3_TEXT): bool

public bindValue(string|int $param, mixed $value, int $type = SQLITE3_TEXT): bool

public clear(): bool

public close(): true

public execute(): SQLite3Result|false

public getSQL(bool $expand = 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::__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

Found A Problem?

Learn How To Improve This Page • Submit a Pull Request • Report a Bug

User Contributed Notes

There are no user contributed notes for this page.

Follow Lee on X/Twitter - Father, Husband, Serial builder creating AI, crypto, games & web tools. We are friends :) AI Will Come To Life!

Check out: eBank.nz (Art Generator) | Netwrck.com (AI Tools) | Text-Generator.io (AI API) | BitBank.nz (Crypto AI) | ReadingTime (Kids Reading) | RewordGame | BigMultiplayerChess | WebFiddle | How.nz | Helix AI Assistant