Home/ Manual/ reference / sqlite3/ The SQLite3Stmt class

The SQLite3Stmt class

Guide Edit on GitHub ✎

A class that handles prepared statements for the SQLite 3 extension. Instances are obtained from SQLite3::prepare. Calling SQLite3Stmt::execute runs the query and returns a SQLite3Result for result sets.

Intro

A class that handles prepared statements for the SQLite 3 extension. Instances are obtained from SQLite3::prepare. Calling SQLite3Stmt::execute runs the query and returns a SQLite3Result for result sets.

Class synopsis

class SQLite3Stmt { }

Predefined Constants

SQLite3Stmt::EXPLAIN_MODE_PREPARED: The statement operates in normal prepared statement mode (no EXPLAIN). Available as of PHP 8.5.0, when compiled against libsqlite >= 3.43.0.
SQLite3Stmt::EXPLAIN_MODE_EXPLAIN: The statement operates as if prefixed with EXPLAIN, returning opcode information from the virtual machine. Available as of PHP 8.5.0, when compiled against libsqlite >= 3.43.0.
SQLite3Stmt::EXPLAIN_MODE_EXPLAIN_QUERY_PLAN: The statement operates as if prefixed with EXPLAIN QUERY PLAN, returning high-level query plan information. Available as of PHP 8.5.0, when compiled against libsqlite >= 3.43.0.

Sqlite3stmt