PDO::query --
Executes an SQL statement, returning a result set as a PDOStatement object
Syntax
object PDO::query ( string statement )
Warning
This function is
EXPERIMENTAL. The behaviour of this function, the
name of this function, and anything else documented about this
function may change without notice in a future release of PHP.
Use this function at your own risk.
PDO::query() prepares and executes an SQL statement in
a single function call, returning the result set (if any) returned by the
statement as a PDOStatement object.
For a SELECT statement that you need to issue multiple times, prepare
a PDOStatement object with PDO::prepare() and issue
the statement with PDOStatement::execute().
Parameters
statement
The SQL statement to prepare and execute.
Return Values
PDO::query() returns a PDOStatement object.
Examples
Example 1. Demonstrate PDO::query
A nice feature of PDO::query() is that it
enables you to iterate over the rowset returned by a
successfully executed SELECT statement.
<?php function getFruit($conn) { $sql = 'SELECT name, colour, calories FROM fruit ORDER BY name'; foreach ($conn->query($sql) as $row) { print $row['NAME'] . "\t"; print $row['COLOUR'] . "\t"; print $row['CALORIES'] . "\n"; } } ?>
The above example will output:
apple red 150
banana yellow 250
kiwi brown 75
lemon yellow 25
orange orange 300
pear green 150
watermelon pink 90
See Also
PDO::exec()
PDO::prepare()
PDOStatement::execute()
Php pdo query Function syntax tag
pdo query php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online
Php pdo query syntax tutorial
php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.