Using PDO::query to Execute SQL and Return a PDOStatement in PHP

PDO::query is a method in PHP's PDO class that executes an SQL statement and returns the result set as a PDOStatement object.

Signature:

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

Parameters:

$statement – The SQL query to prepare and execute.

Return value: Returns a PDOStatement object on success or FALSE on failure.

Example:

<?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'] . "
";
    }
}
?>