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