/** * Special handling for PDO query(). * All bind parameter names must begin with ':' * * @param string|\Zend\DB\Select\Select $sql The SQL statement with placeholders. * @param array $bind An array of data to bind to the placeholders. * @return \Zend\DB\Statement\PDO\PDO * @throws \Zend\DB\Adapter\Exception To re-throw PDOException. */ public function query($sql, $bind = array()) { if (empty($bind) && $sql instanceof Select\Select) { $bind = $sql->getBind(); } if (is_array($bind)) { foreach ($bind as $name => $value) { if (!is_int($name) && !preg_match('/^:/', $name)) { $newName = ":{$name}"; unset($bind[$name]); $bind[$newName] = $value; } } } try { return parent::query($sql, $bind); } catch (\PDOException $e) { throw new \Zend\DB\Statement\Exception($e->getMessage(), $e->getCode(), $e); } }