thinkphp增删改查范例

config.php

<?php 
return array(
//配置数据库连接
'DB_TYPE'=>'mysql',
'DB_HOST'=>'localhost',
'DB_NAME'=>'joys',
'DB_USER'=>'root',
'DB_PWD'=>'root',
'DB_PREFIX'=>'joys_',
'DB_CHARSET'=>'utf8',
);

joys_user.sql

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for joys_user
-- ----------------------------
DROP TABLE IF EXISTS `joys_user`;
CREATE TABLE `joys_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

UserController.class.php

<?php

namespace Home\Controller;
use Think\Controller;


class UserController extends Controller {
    public function index(){
        $user=M('User');        
    $list=$user->select();
        $this->assign('title','用户列表');
    $this->assign('ulist',$list); 
        $this->display();
    }
    function add(){
    $this->assign('title','添加用户');
    $this->display();
    }
    function edit(){
    $this->assign('title','编辑用户');
    $id=$_GET['id'];
    if(!empty($id)){
    $user=M('User');
    $date=$user->getById($id);
    $this->assign('udate',$date);
    }
    $this->display();
    }
    
function insert(){
$user=M('User'); 
if($data=$user->create()){
if(false!==$user->add()){
$uid=$user->getLastInsID();
$this->assign('jumpUrl','index');
$this->success('操作成功，插入数据编号为：'.$uid);
}else{
$this->error('操作失败：adduser'.$user->getDbError());
}
}else{
$this->error('操作失败：数据验证( '.$user->getError().' )');
}
}


function update(){
$user=new UserModel();
if($data=$user->create()){
if(!empty($data['id'])){
if(false!==$user->save()){
$this->assign('jumpUrl','index');
$this->success('操作成功');
}else{
$this->error('操作失败：'.$user->getDbError());
}
}else{
$this->error('请选择编辑用户');
}
}else{
$this->error('操作失败：数据验证( '.$user->getError().' )');
}
}

function delete(){
$id=$_GET['id'];
if(!empty($id)){
$user=new UserModel();
if(false!==$user->delete($id)){
$this->success('操作成功');
}else{
$this->error('操作失败：'.$user->getDbError());
}
}else{
$this->error('请选择删除用户');
}
}

}

index.html

<script>
function del(){
if(window.confirm('请确认是否删除？')){

}
}
</script>
<p>{$title}</p>
<table border="1px">
<tr>
<td>用户编号</td>
<td>用户名称</td>
<td>操作</td>
</tr>
<volist name="ulist" id="user">
<tr>
<td>{$user['id']}</td>
<td><a href="__URL__/edit/id/{$user['id']}">{$user['username']}</a></td>
<td><a href="__URL__/delete/id/{$user['id']}" onclick="del();">刪除</a></td>
</tr>
</volist>
</table>

add.html

<form action="__URL__/insert" method="post">
用户名:<input type="text" name="username"/><br/>
<input type="submit"  value="添加" />
</form>

edit.html

<form action="__URL__/update" method="post">
<input type="hidden" name="id" value="{$udate['id']}"/>
用户名:<input type="text" name="username" value="{$udate['username']}"/><br/>
<input type="submit"  value="保存" />
</form>