/** * 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; }
/** * Prepares an SQL statement. * * @param string $statement * @return Statement */ public function prepare($statement) { $this->connect(); return $this->_conn->prepare($statement); }