about where in about php-pdo-mysql-class HOT 3 CLOSED

看来我设计时还是考虑不周。

from php-pdo-mysql-class.

@chainjoy, your query should be:

$DB->query("SELECT * FROM fruit WHERE name IN (?,?) AND color = ? ",array('apple','banana','red'));

from php-pdo-mysql-class.

In the latest version:

$DB->query("SELECT * FROM fruit WHERE name IN (:fruit) AND color = :color ",array(
    'fruit' => array('apple','banana'),
    'color' =>'red')
);

from php-pdo-mysql-class.