1.controller ModelController.php
//建议
public function actionSavedeDail(){
$update = array('model_id'=>$_POST['model_id'],'model_sql'=>$_POST['model_sql'],'model_sql_type'=>$_POST['model_sql_type'],'source'=>$_POST["source"]);
if($this->genClass->SaveSql($update)){
exit('修改成功');
}else {
exit('修改失败');
}
}
//不建议
public function actionSavedeDail(){
$update = array('model_id'=>$_POST['model_id'],'model_sql_type'=>$_POST['model_sql_type'],'source'=>$_POST["source"]);
$rs = $this->genClass->SaveSql('model_sql', $update,array('model_id'=>$_POST['model_id'],'model_sql_type'=>$_POST['model_sql_type'],'source'=>$_POST["source"]));
$this->display('Task/Detailed');
}
2.model ModelModel.php
//建议
public function SaveSql($update) {
return $this->db->update('model_sql',$update,array('model_id'=>$update['model_id'],'model_sql_type'=>$update['model_sql_type'],'source'=>$update['source']));
}
//不建议
public function SaveSql($table,$array,($model_id,$model_sql_type,$source)) {
$where = "model_id = '$model_id' and model_sql_type = '$model_sql_type' and source='$source'";
return $this->db->update($table,$array,$where);
}
//建议
public function actionSavedeDail(){
$update = array('model_id'=>$_POST['model_id'],'model_sql'=>$_POST['model_sql'],'model_sql_type'=>$_POST['model_sql_type'],'source'=>$_POST["source"]);
if($this->genClass->SaveSql($update)){
exit('修改成功');
}else {
exit('修改失败');
}
}
//不建议
public function actionSavedeDail(){
$update = array('model_id'=>$_POST['model_id'],'model_sql_type'=>$_POST['model_sql_type'],'source'=>$_POST["source"]);
$rs = $this->genClass->SaveSql('model_sql', $update,array('model_id'=>$_POST['model_id'],'model_sql_type'=>$_POST['model_sql_type'],'source'=>$_POST["source"]));
$this->display('Task/Detailed');
}
2.model ModelModel.php
//建议
public function SaveSql($update) {
return $this->db->update('model_sql',$update,array('model_id'=>$update['model_id'],'model_sql_type'=>$update['model_sql_type'],'source'=>$update['source']));
}
//不建议
public function SaveSql($table,$array,($model_id,$model_sql_type,$source)) {
$where = "model_id = '$model_id' and model_sql_type = '$model_sql_type' and source='$source'";
return $this->db->update($table,$array,$where);
}