YouTipPdo Query
# 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 be executed.
* * *
## Return Value
If successful, PDO::query() returns a PDOStatement object. If it fails, it returns FALSE.
* * *
## Example
### PDO::query Example
Iterating through and outputting the result set:
query($sql) as $row) { print $row['name'] . "t"; print $row['color'] . "t"; print $row['calories'] . "n"; }}?>
The above output results in:
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](#)