本文实例讲述了ThinkPHP基本的增删查改操作,是ThinkPHP项目开发中最常用的基础操作,有着十分重要的应用价值。现将完整的实例代码与大家分享,希望能对大家有所帮助。具体如下:
一、表aoli_user字段设置:
表aoli_user主要有以下几个字段:
id username password createtime createip
二、view模板部分
1.用户首页模板:
aoli/Home/Tpl/default/User/index.html页面代码如下:
1
2
3
4
5
6
7
8
9
10
|
< form action = "__URL__/add" method = "post" >
用户名:< input type = "text" name = "username" />< br />
密码:< input type = "password" name = "password" />< br />
重复密码:< input type = "repassword" name = "repassword" />< br />
< input type = "submit" value = "注册" />
</ form >
< volist name = "alist" id = "vo" >
< li >< span >ID:</ span >{$vo['id']}< span >用户名:</ span >{$vo['username']}< span >注册ip:</ span >{$vo['createip']}< a href = "__URL__/del/id/{$vo['id']}" >删除</ a > < a href = "__URL__/edit/id/{$vo['id']}" >编辑</ a ></ li >
</ volist >
|
2.用户编辑模板:
aoli/Home/Tpl/default/User/edit.html页面代码如下:
1
2
3
4
5
6
7
8
|
< form action = "__URL__/update" method = "post" >
用户名:< input type = "text" name = "username" value = "{$data['username']}" />< br />
密码:< input type = "password" name = "password" value = "{$data['password']}" />< br />
IP:< input type = "text" name = "createip" value = "{$data['createip']}" />< br />
时间:< input type = "text" name = "createtime" value = "{$data['createtime']}" />< br />
< input type = "hidden" value = "{$data['id']}" name = "id" />
< input type = "submit" value = "更新" />
</ form >
|
二、action部分:
aoli/Home/Lib/Action/UserAction.class.php页面如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
class UserAction extends Action {
function index(){
$user =M( 'user' );
$list = $user ->field( array ( 'id' , 'username' , 'createip' ))->select();
$this ->assign( 'title' , 'thinkphp视频演示' );
$this ->assign( 'alist' , $list );
$this ->display();
}
//删除
function del(){
$user =D( 'user' );
if ( $user -> delete ( $_GET [ 'id' ])){
$this ->success( '删除成功' );
} else {
$this ->error( '删除失败' );
}
}
//增加
function add(){
Load( 'extend' );
if ( $_POST [ 'password' ]!= $_POST [ 'repassword' ]){
$this ->error( '两次密码不一致' );
}
$user =D( 'user' );
if ( $vo = $user ->create()){
$user ->password=md5( $user ->password);
$user ->createtime=time();
//$user->createip=$_SERVER[];
$user ->createip=get_client_ip();
if ( $user ->add()){
$this ->success( '用户注册成功,返回上级页面' );
} else {
$this ->error( '用户注册失败,返回上级页面' );
}
} else {
$this ->error( $user ->getError());
}
}
//显示用户的修改项
function edit(){
$user =M( 'user' );
$id =(int) $_GET [ 'id' ];
$list = $user ->where( "id=$id" )->find();
$this ->assign( 'data' , $list );
$this ->assign( 'title' , '显示用户编辑信息' );
$this ->display();
}
//将更新数据写入数据库
function update(){
$user =M( 'user' );
$user ->password=md5( $user ->password);
if ( $user ->create()){
if ( $insertid = $user ->save()){
$this ->success( '更新成功,受影响的行数为' . $insertid );
} else {
$this ->error( '更新失败' );
}
}
}
}
?>
|
感兴趣的读者可以在项目中调试运行一下本文所述实例,以加深对ThinkPHP增删查改操作的理解,方便在以后的项目中加以灵活运用。