$conn = $this->get("doctrine.dbal.default_connection");
$list = $conn->fetchAll(
"SELECT * FROM herbal WHERE id IN (?) AND name like ? AND flag = ?",
array(array(1,2,3), "%艾%", 1),
array(Connection::PARAM_INT_ARRAY, \PDO::PARAM_STR, \PDO::PARAM_INT)
);
VarDumper::dump($list);
转载于:https://my.oschina.net/u/729139/blog/474698