Latest web development tutorials

PDO :: query

PHP PDO Reference Manual PHP PDO Reference Manual

PDO :: query - execute SQL statements, returns PDOStatement object that can be understood as the result set (PHP 5> = 5.1.0, PECL pdo> = 0.2.0)


Explanation

grammar

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 () call in a separate function and execute the SQL statement that returns a result set (if any), the statement is returned as a PDOStatement object.


parameter

statement
SQL statement for execution.


return value

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


Examples

PDO :: query examples

Traversal output 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";
    }
}
?>

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 PHP PDO Reference Manual