ThinkPHP基本的增删查改操作

表aoli_user字段:

id   username   password    createtime    createip

aoli/Home/Tpl/default/User/index.html:

1. <form action="__URL__/add" method="post"> 
2.   用户名:<input type="text" name="username" /><br /> 
3.   密码：<input type="password" name="password" /><br /> 
4.   重复密码：<input type="repassword" name="repassword" /><br /> 
5.   <input type="submit" value="注册" /> 
6. form> 
7. <volist name="alist" id="vo"> 
8.   <li><span>ID：span>{$vo[&＃39;id&＃39;]}<span>用户名：span>{$vo[&＃39;username&＃39;]}<span>注册ip：span>{$vo[&＃39;createip&＃39;]}<a href="__URL__/del/id/{$vo[&＃39;id&＃39;]}">删除a>  <a href="__URL__/edit/id/{$vo[&＃39;id&＃39;]}">编辑a>li> 
9. volist> 

aoli/Home/Tpl/default/User/edit.html:

1. <form action="__URL__/update" method="post"> 
2.   用户名:<input type="text" name="username" value="{$data[&＃39;username&＃39;]}" /><br /> 
3.   密码：<input type="password" name="password" value="{$data[&＃39;password&＃39;]}" /><br /> 
4.   IP：<input type="text" name="createip" value="{$data[&＃39;createip&＃39;]}" /><br /> 
5.   时间：<input type="text" name="createtime" value="{$data[&＃39;createtime&＃39;]}" /><br /> 
6.   <input type="hidden" value="{$data[&＃39;id&＃39;]}" name="id" /> 
7.   <input type="submit" value="更新" /> 
8. form> 

aoli/Home/Lib/Action/UserAction.class.php:

1. class UserAction extends Action { 
2.      function index(){ 
3.          $user=M(&＃39;user&＃39;); 
4.          $list=$user->field(array(&＃39;id&＃39;,&＃39;username&＃39;,&＃39;createip&＃39;))->select(); 
5.          $this->assign(&＃39;title&＃39;,&＃39;thinkphp视频演示&＃39;); 
6.          $this->assign(&＃39;alist&＃39;,$list); 
7.          $this->display();          
8.      } 
9.      //删除 
10.      function del(){ 
11.          $user=D(&＃39;user&＃39;); 
12.          if($user->delete($_GET[&＃39;id&＃39;])){ 
13.              $this->success(&＃39;删除成功&＃39;);      
14.          }else{ 
15.              $this->error(&＃39;删除失败&＃39;); 
16.          } 
17.      } 
18.      //增加 
19.      function add(){ 
20.          Load(&＃39;extend&＃39;); 
21.          if($_POST[&＃39;password&＃39;]!=$_POST[&＃39;repassword&＃39;]){ 
22.              $this->error(&＃39;两次密码不一致&＃39;);      
23.          } 
24.          $user=D(&＃39;user&＃39;); 
25.          if($vo=$user->create()){ 
26.              $user->password=md5($user->password); 
27.              $user->createtime=time(); 
28.              //$user->createip=$_SERVER[]; 
29.              $user->createip=get_client_ip(); 
30.              if($user->add()){ 
31.                  $this->success(&＃39;用户注册成功，返回上级页面&＃39;);      
32.              }else{ 
33.                  $this->error(&＃39;用户注册失败，返回上级页面&＃39;); 
34.              } 
35.          }else{ 
36.              $this->error($user->getError());      
37.          } 
38.      } 
39.      //显示用户的修改项 
40.      function edit(){ 
41.          $user=M(&＃39;user&＃39;); 
42.          $id=(int)$_GET[&＃39;id&＃39;]; 
43.          $list=$user->where("id=$id")->find(); 
44.          $this->assign(&＃39;data&＃39;,$list); 
45.          $this->assign(&＃39;title&＃39;,&＃39;显示用户编辑信息&＃39;);  
46.          $this->display(); 
47.      } 
48.      //将更新数据写入数据库 
49.      function update(){ 
50.          $user=M(&＃39;user&＃39;); 
51.          $user->password=md5($user->password); 
52.          if($user->create()){ 
53.              if($insertid=$user->save()){ 
54.                  $this->success(&＃39;更新成功,受影响的行数为&＃39;.$insertid); 
55.              }else{ 
56.                  $this->error(&＃39;更新失败&＃39;);      
57.              } 
58.                        
59.          } 
60.      } 
61. }