/** * Executes an SQL INSERT/UPDATE/DELETE query with the given parameters. * * @param string $query sql query * @param array $params query parameters * @return integer */ public function executeUpdate($query, array $params = array()) { $this->connect(); if ($this->_config->getSqlLogger()) { $this->_config->getSqlLogger()->logSql($query, $params); } if (!empty($params)) { $stmt = $this->_conn->prepare($query); $stmt->execute($params); $result = $stmt->rowCount(); } else { $result = $this->_conn->exec($query); } return $result; }
/** * Executes an SQL INSERT/UPDATE/DELETE query with the given parameters. * * @param string $query sql query * @param array $params query parameters * * @return PDOStatement * @todo Rename to executeUpdate(). */ public function exec($query, array $params = array()) { $this->connect(); try { echo "DBAL:" . $query . PHP_EOL; if (!empty($params)) { var_dump($params); $stmt = $this->prepare($query); $stmt->execute($params); return $stmt->rowCount(); } else { $count = $this->_conn->exec($query); $this->_queryCount++; return $count; } } catch (PDOException $e) { //TODO: Wrap throw $e; } }