ThinkPHP3.2.2-CURD
1、解压thinkphp_3.2.3_full.zip至项目目录;
2、查看目录
3、再看目录,生成项目home目录
/thinkphp_3.2.3/index.php/home/index/index
4、创建控制器(ShowController.class.php)
<?php
namespace Home\Controller;
use Think\Controller;
class ShowController extends Controller {
public function index(){
echo 123;
//访问/thinkphp_3.2.3/index.php/home/show/index //123--ok
}
}
连接数据库/Home/Conf/config.php
控制器ShowController.class.php
<?php
namespace Home\Controller;
use Think\Controller;
use Home\Model\ShowModel;
class ShowController extends Controller {
public function index(){
$this->display('show/index');
}
public function addData(){
$post=I();
$model=D('Show');
$res=$model->getData($post);
if($res){
$this->success('添加成功',U('Show/info'),'2');
}else{
$this->error('添加失败');
}
}
public function info(){
$model=D('Show');
$data=$model->getInfo();
$this->assign('info',$data);
$this->display('show/show');
}
public function delRow(){
$id=I('id');
$model=D('Show');
$res=$model->delOne($id);
if($res){
echo '<script>alert("删除成功");location.href="'.U('Show/info').'";</script>';
}
}
public function getRow(){
$id=I('id');
$model=D('Show');
$row=$model->getOne($id);
$this->assign('row',$row);
$this->display('show/save');
}
public function saveData(){
$post=I();
$model=D('Show');
$res=$model->saveOne($post);
if($res){
$this->success('修改成功',U('Show/info'),'2');
}
}
}
创建模型ShowModel.class.php
<?php
namespace Home\Model;
use Think\Model;
class ShowModel extends Model {
protected $tableName = 'reg';
public function getData($post){
$post['hobby']=implode(',', $post['hobby']);
$Show = M("reg");
return $Show->add($post);
}
public function getInfo(){
$Show = M("reg");
return $Show->select();
}
public function delOne($id){
$Show = M("reg");
return $Show->where('id='.$id)->delete();
}
public function getOne($id){
$Show=M('reg');
$row=$Show->where(array('id'=>$id))->find();
$row['hobby']=explode(',', $row['hobby']);
return $row;
}
public function saveOne($post){
$Show=M('reg');
$id=$post['id'];
$data['username']=$post['username'];
$data['sex']=$post['sex'];
$data['hobby']=implode(',',$post['hobby']);
$data['age']=$post['age'];
return $Show->where(array('id'=>$id))->save($data);
}
}
?>
创建视图View/show/index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>index</title>
</head>
<body>
<center>
<h4>index</h4>
<form action="{:U('show/addData')}" method="post">
<table border="1">
<tr>
<td>USERNAME</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>SEX</td>
<td>
<input type="radio" name="sex" value="1">男
<input type="radio" name="sex" value="0">女
</td>
</tr>
<tr>
<td>HOBBY</td>
<td>
<input type="checkbox" name="hobby[]" value="篮球">篮球
<input type="checkbox" name="hobby[]" value="足球">足球
<input type="checkbox" name="hobby[]" value="球球">球球
</td>
</tr>
<tr>
<td>AGE</td>
<td>
<select name="age" id="">
<?php for($i=18;$i<30;$i++){ ?>
<option value="<?=$i?>"><?=$i?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
创建视图View/show/show.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>show</title>
</head>
<body>
<center>
<h4>show</h4>
<table border="1">
<tr>
<td>ID</td>
<td>USERNAME</td>
<td>SEX</td>
<td>HOBBY</td>
<td>AGE</td>
<td>OPTION</td>
</tr>
<?php foreach($info as $k => $v){ ?>
<tr>
<td><?= $v['id'] ?></td>
<td><?= $v['username'] ?></td>
<td><?= $v['sex']==1?'男':'女' ?></td>
<td><?= $v['hobby'] ?></td>
<td><?= $v['age'] ?></td>
<td>
<a href="delRow?id=<?= $v['id'] ?>">DEL</a>
<a href="getRow?id=<?= $v['id'] ?>">UPDATE</a>
</td>
</tr>
<?php } ?>
</table>
</center>
</body>
</html>
创建视图View/show/save.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>save</title>
</head>
<body>
<center>
<h4>save</h4>
<form action="{:U('show/saveData')}" method="post">
<input type="hidden" name="id" value="<?= $row['id'] ?>">
<table border="1">
<tr>
<td>USERNAME</td>
<td><input type="text" name="username" value="<?= $row['username'] ?>"></td>
</tr>
<tr>
<td>SEX</td>
<td>
<input type="radio" name="sex" value="1" <?= $row['sex']==1?'checked':'' ?>>男
<input type="radio" name="sex" value="0" <?= $row['sex']==0?'checked':'' ?> >女
</td>
</tr>
<tr>
<td>HOBBY</td>
<td>
<input type="checkbox" name="hobby[]" value="篮球" <?= in_array('篮球', $row['hobby'])?'checked':'' ?> >篮球
<input type="checkbox" name="hobby[]" value="足球" <?= in_array('足球', $row['hobby'])?'checked':'' ?> >足球
<input type="checkbox" name="hobby[]" value="球球" <?= in_array('球球', $row['hobby'])?'checked':'' ?> >球球
</td>
</tr>
<tr>
<td>AGE</td>
<td>
<select name="age" id="">
<?php for($i=18;$i<30;$i++){ ?>
<option value="<?=$i?>" <?= $row['age']==$i ?'selected':'' ?> ><?=$i?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Save"></td>
</tr>
</table>
</form>
</center>
</body>
</html>