### update **修改數據，該函數將根據參數中設置的條件而更新表中數據** **參數** conditions 數組形式，查找條件，此參數的格式用法與find/findAll的查找條件參數是相同的。 row 數組形式，修改的數據， \* 此參數的格式用法與create的$row是相同的。在符合條件的記錄中，將對$row設置的字段的數據進行修改。 ~~~ public function update($conditions, $row) { $where = ""; $row = $this->__prepera_format ( $row ); if (empty ( $row )) return FALSE; if (is_array ( $conditions )) { $join = array (); foreach ( $conditions as $key => $condition ) { $condition = $this->__val_escape ( $condition ); $join [] = "{$key} = '{$condition}'"; } $where = "WHERE " . join ( " AND ", $join ); } else { if (null != $conditions) $where = "WHERE " . $conditions; } foreach ( $row as $key => $value ) { $value = $this->__val_escape ( $value ); //2011-01-04修改 //if ($value == 'NULL') if ($value === 'NULL') //2011-01-04修改 $vals [] = "{$key} = NULL"; else $vals [] = "{$key} = '{$value}'"; } $values = join ( ", ", $vals ); $sql = "UPDATE {$this->tbl_name} SET {$values} {$where}"; //echo $sql; return $this->_db->query ( $sql ); } ~~~