PDO::query

PHP PDO Reference Manual

PDO::query — Executes an SQL statement, returns a PDOStatement object, which can be understood as a result set (PHP 5 >= 5.1.0, PECL pdo >= 0.2.0)

Description

Syntax

public PDOStatement PDO::query ( string $statement )

public PDOStatement PDO::query ( string $statement , int $PDO::FETCH_COLUMN , int $colno )

public PDOStatement PDO::query ( string $statement , int $PDO::FETCH_CLASS , string $classname , array $ctorargs )

public PDOStatement PDO::query ( string $statement , int $PDO::FETCH_INTO , object $object )

PDO::query() calls and executes an SQL statement in a single function, returning the result set (if any); the statement is returned as a PDOStatement object.

Parameters

statement
The SQL statement to execute.

Return Values

If successful, PDO::query() returns a PDOStatement object; if it fails, it returns FALSE.

Examples

PDO::query Example

Iterate and output the result set:

<?php
function getFruit($conn) {
    $sql = 'SELECT name, color, calories FROM fruit ORDER BY name';
    foreach ($conn->query($sql) as $row) {
        print $row['name'] . "\t";
        print $row['color'] . "\t";
        print $row['calories'] . "\n";
    }
}
?>

The above output is:

apple   red     150
banana  yellow  250
kiwi    brown   75
lemon   yellow  25
orange  orange  300
pear    green   150
watermelon      pink    90

PHP PDO Reference Manual