+ # update
+ #
+
+ function data_update($params = array()){
+ $sgbd = $this->sgbd();
+ $table_name = isset($params["table_name"]) ? $params["table_name"] : false;
+ $values = (isset($params["values"]) && is_array($params["values"])) ? $params["values"] : false;
+ $index_name = isset($params["index_name"]) ? $params["index_name"] : false;
+ $index_value = isset($params["index_value"]) && (strlen($params["index_value"]) > 0) ? $params["index_value"] : false;
+ if(!$table_name || !$index_name || !$index_value || !$values) return false;
+ try{
+ $sql = "UPDATE `#--".$table_name."`";
+ $set = "";
+ foreach($values as $attribut_name => $attribut_value){
+ $set .= ($set ? ", " : "")."`".$attribut_name."`=".$this->eq($attribut_value);
+ }
+ $set = $set ? " SET ".$set : "";
+ $where = " WHERE `".$index_name."`=".$this->eq($index_value);
+ $sgbd->query($sql.$set.$where);
+ }
+ catch(Exception $e) { return false; }
+ return true;
+ }
+
+ # ----------------------------------------------------------------------------------------
+ # delete
+ #
+
+ function data_delete($params = array()){
+ $sgbd = $this->sgbd();
+ $table_name = isset($params["table_name"]) ? $params["table_name"] : false;
+ $index_name = isset($params["index_name"]) ? $params["index_name"] : false;
+ $index_value = isset($params["index_value"]) ? $params["index_value"] : false;
+ if(!$table_name || !$index_name || !$index_value) return false;
+ try{
+ $sql = "DELETE FROM `#--".$table_name."` WHERE `".$index_name."`=".$this->eq($index_value);
+ $sgbd->query($sql);
+ }
+ catch(Exception $e) { debug($e->getMessage()); return false; }
+ return true;
+ }
+
+ # ----------------------------------------------------------------------------------------