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:

query($sql) as $row) {
        print $row['name'] . "\t";
        print $row['color'] . "\t";
        print $row['calories'] . "\n";
    }
}
?>