PDO::query

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.2.0)

PDO::query — 执锟斤拷 SQL 锟斤拷洌拷锟� PDOStatement 锟斤拷锟斤拷锟斤拷式锟斤拷锟截斤拷锟斤拷锟�

说锟斤拷

public PDO::query ( string $statement ) : PDOStatement

public PDO::query ( string $statement , int $PDO::FETCH_COLUMN , int $colno ) : PDOStatement

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

public PDO::query ( string $statement , int $PDO::FETCH_INTO , object $object ) : PDOStatement

PDO::query() 锟节碉拷锟轿猴拷锟斤拷锟斤拷锟斤拷锟斤拷执锟斤拷 SQL 锟斤拷洌拷锟� PDOStatement 锟斤拷锟斤拷锟斤拷式锟斤拷锟截斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷的伙拷锟斤拷锟斤拷

锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵伙拷锟斤拷锟窖拷锟斤拷锟� PDO::prepare() 准锟斤拷 PDOStatement 锟斤拷锟襟，诧拷锟斤拷 PDOStatement::execute() 执锟斤拷锟斤拷洌拷锟斤拷锟斤拷懈锟斤拷玫锟斤拷锟斤拷堋锟�

锟斤拷锟矫伙拷锟斤拷锟斤拷锟斤拷锟饺★拷锟斤拷锟斤拷锟节碉拷锟斤拷锟捷ｏ拷锟酵碉拷锟斤拷锟斤拷一锟斤拷 PDO::query()锟斤拷锟斤拷锟斤拷锟杰碉拷锟斤拷失锟杰★拷应锟斤拷锟斤拷执锟斤拷锟斤拷一锟斤拷 PDO::query() 前锟斤拷锟斤拷锟斤拷 PDOStatement::closeCursor() 锟酵凤拷锟斤拷锟捷匡拷PDOStatement 锟斤拷锟斤拷锟斤拷锟斤拷源锟斤拷

Note:
锟斤拷锟斤拷锟斤拷牒拷锟斤拷牟锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟侥诧拷锟斤拷锟斤拷锟洁当锟节碉拷锟矫斤拷锟斤拷锟斤拷锟� PDOStatement::setFetchMode() 锟斤拷锟斤拷锟斤拷

锟斤拷锟斤拷

statement

锟斤拷要准锟斤拷锟斤拷执锟叫碉拷 SQL 锟斤拷洹�

锟斤拷询锟斤拷锟斤拷锟斤拷锟接︼拷锟斤拷锟�恰锟斤拷锟斤拷锟斤拷式转锟斤拷锟斤拷

锟斤拷锟斤拷值

PDO::query() 锟斤拷锟斤拷 PDOStatement 锟斤拷锟襟，伙拷锟斤拷失锟斤拷时锟斤拷锟斤拷 FALSE锟斤拷

锟斤拷锟斤拷

Example #1 展示 PDO::query 锟斤拷使锟斤拷

PDO::query() 一锟斤拷锟斤拷锟斤拷墓锟斤拷锟斤拷牵锟街达拷锟� SELECT 锟斤拷洌拷锟斤拷芄锟窖拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷


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

锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�

apple   red     150
banana  yellow  250
kiwi    brown   75
lemon   yellow  25
orange  orange  300
pear    green   150
watermelon      pink    90

锟轿硷拷

PDO::exec() - 执锟斤拷一锟斤拷 SQL 锟斤拷洌拷锟斤拷锟斤拷锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷
PDO::prepare() - 准锟斤拷要执锟叫碉拷锟斤拷洌拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
PDOStatement::execute() - 执锟斤拷一锟斤拷预锟斤拷锟斤拷锟斤拷锟�