PHP Braghim Database::query Examples

Example #1

File: AbstractGateway.php Project: marcobraghim/sni

 /**
  * Remove um registro do banco de dados.
  * 
  * @return type
  */
 public function delete(array $where)
 {
     $this->checkGateway();
     // Monta query
     $sql = "DELETE FROM " . $this->name . " WHERE ";
     foreach ($where as $column => $value) {
         // Parametro na query
         $sql .= $column . " = :" . $column . " AND ";
         // Parametro, query segura
         $this->db->bind($column, $value);
     }
     $sql = preg_replace("/\\sAND\\s\$/", '', $sql);
     // Resultado
     return (bool) $this->db->query($sql);
 }