8-6.txt

(0 KB) Pobierz
function delete($table, $arConditions) {

   // tworzy tablicê dla klauzuli WHERE
   $arWhere = array();
   foreach($arConditions as $field => $val) {
      if(! is_numeric($val)) {
         // cytuje dane
         $val = "'" . pg_escape_string($val) . "'";
      }
      $arWhere[] = "$field = $val";
   }

   $sql = "DELETE FROM $table WHERE " . join(' AND ', $arWhere);

   $hRes = pg_query($sql);
   if(! is_resource($hRes)) {
      $err = pg_last_error($this->hConn) . NL . $sql;
      throw new Exception($err);
   }
   return pg_affected_rows($hRes);
}
Zgłoś jeśli naruszono regulamin