This article introduces you to a detailed example of how thinkphp implements updated data and five methods for thinkphp to update the database. This article introduces very well and has reference value. Interested friends can refer to it
Before introducing the main text, let me introduce to you the coherent operation methods supported by the data update method:
In the previous article In this article, we implemented data deletion and batch deletion. In this article, we will implement data update.
The first is still the expected rendering:
Click to modify and enter the modi.html page, and then Make modifications, such as modifying the real name attribute here:
Click to save:
The above is the effect to be achieved. The following is the specific code to achieve:
The first is still the code in the view:
The next is the controller: What needs to be explained is that what is needed here The purpose of writing the unmodified value is mainly to facilitate the user's memo, so it is necessary to make an if branch judgment:
public function modi(){ if (IS_POST) { $adminUsersModel = D("adminUsers"); $adminUsersModel->create(); // var_dump($adminUsersModel); // exit("创建成功!"); if($adminUsersModel->save()){ $this->success("修改成功", U("Admin/User/lists")); } else { $this->error($adminUsersModel->getError()); } } else { $id = isset($_GET['id']) ? intval($_GET['id']) : ''; if ($id == '') { exit("bad param! 请输入id"); } $adminUsersModel=D("adminUsers"); $adminUsers=$adminUsersModel->find($id); //var_dump($adminUsers); $this->assign("adminUsers", $adminUsers); $this->display(); } }
The following will introduce how thinkphp updates the database. Five methods
The first method:
$Model->where('id=1')->save( $data);
Second method:
$model->where('id=1')->data($data)-> ;save();
The third method:
$Model->create();
$Model-> ;save();
The form must contain a hidden field named with the primary key
Fourth method:
$ Model->where('id=5')->setField('name','ThinkPHP');
$Model->where('id=5')-> ;setField(array('name','email'),array('TP','TP@163.com'));
//The fourth method, when passing an array, I can't implement it . . .
Fifth method:
$Model->setInc('score','id=5',3); // Point addition 3
$Model->setInc('score','id=5'); // Points plus 1
$Model->setDec(' score','id=5',5); //Score minus 5
$model->setDec('score','id=5'); //Score minus 1
Related recommendations:
thinkphp implements 163, QQ mailbox method of sending and receiving emails_php skills
##ThinkPHP implements simple login function
The above is the detailed content of How to update data in ThinkPHP? (detailed examples). For more information, please follow other related articles on the PHP Chinese website!