Home/ Manual/ reference / pdo/ The PDOStatement class

The PDOStatement class

Guide Edit on GitHub ✎

Represents a prepared statement and, after the statement is executed, an associated result set.

Intro

Represents a prepared statement and, after the statement is executed, an associated result set.

Class synopsis

class PDOStatement implements IteratorAggregate { }

Properties

queryString: Used query string.

Changelog

Version	Description
8.0.0	`PDOStatement` implements `IteratorAggregate` now instead of `Traversable`.

Pdostatement

In this section

PDOStatement::bindColumn

Bind a column to a PHP variable

PDOStatement::bindParam

Binds a parameter to the specified variable name

PDOStatement::bindValue

Binds a value to a parameter

PDOStatement::closeCursor

Closes the cursor, enabling the statement to be executed again

PDOStatement::columnCount

Returns the number of columns in the result set

PDOStatement::debugDumpParams

Dump an SQL prepared command

PDOStatement::errorCode

Fetch the SQLSTATE associated with the last operation on the statement handle

PDOStatement::errorInfo

Fetch extended error information associated with the last operation on the statement handl...

PDOStatement::execute

Executes a prepared statement

PDOStatement::fetch

Fetches the next row from a result set

PDOStatement::fetchAll

Fetches the remaining rows from a result set

PDOStatement::fetchColumn

Returns a single column from the next row of a result set

PDOStatement::fetchObject

Fetches the next row and returns it as an object

PDOStatement::getAttribute

Retrieve a statement attribute

PDOStatement::getColumnMeta

Returns metadata for a column in a result set

PDOStatement::getIterator

Gets result set iterator

PDOStatement::nextRowset

Advances to the next rowset in a multi-rowset statement handle

PDOStatement::rowCount

Returns the number of rows affected by the last SQL statement

PDOStatement::setAttribute

Set a statement attribute

PDOStatement::setFetchMode

Set the default fetch mode for this statement

Source: reference/pdo/pdostatement.xml · from the official PHP manual (php/doc-en)