今天小编跟大家分享一下tp5的简单的增删改查和一个数据输出;废话不多,上代码
控制器方法代码
index.php
<?php
namespace app\index\controller;
use think\Controller;
use think\Model;
use think\Db;
use think\Log;
header("Content-type:text/html;charset=UTF-8");
class Index extends Controller
{
//渲染首页输出信息
public function index()
{
if(request()->isPost()){
$a=input('search');
$result = db('work')->where('sex',$a)->select();
}else{
$result = db('work')->select();
}
return $this->fetch('index',array('a'=>$result));
}
//添加信息
public function insert()
{
return view('insert');
}
public function insertdo()
{
$data = input('post.');
$sql = db('work')->insert($data);
if($sql){
$this->success('新增成功', 'Index/index');
}else{
return $this->error('添加失败!');
}
}
//修改信息
public function updete()
{
$info = Db::table('work')->where('id',input('id'))->find();
return $this->fetch('updete',array('info'=>$info));
}
public function updetedo()
{
$data['num'] = input('num');
$data['name'] = input('name');
$data['sex'] = input('sex');
$data['phone'] = input('phone');
$data['que'] = input('que');
$res = Db::table('work')->where('id',input('post.id'))->update($data);
if($res){
$this->success('更新成功','index');
}else{
$this->error('更新失败!');
}
}
//删除信息
public function deletes()
{
$res = Db::table('work')->where('id',input('id'))->delete();
if($res){
$this->success('删除成功!','index');
}else{
$this->error('删除失败!');
}
}
//搜索信息导出
public function indexdo()
{
$a=input("fed");
$b=explode(',',$a);
$va = [];
if(count($b) > 1){
foreach($b as $v){
$where['id'] = $v;
$va[] = db('work')->where($where)->find();
}
}else{
$va = db('work')->select();
}
//var_dump($va);exit;
$strTable ='<table border="1">';
$strTable .='<tr>';
$strTable .='<td>工号</td>';
$strTable .='<td>姓名</td>';
$strTable .='<td>性别</td>';
$strTable .='<td>电话</td>';
$strTable .='<td>职位</td>';
$strTable .='</tr>';
foreach($va as $k=>$val){
$strTable .='<tr>';
$strTable .='<td>'.$val['num'].'</td>';
$strTable .='<td>'.$val['name'].'</td>';
$strTable .='<td>'.$val['sex'].'</td>';
$strTable .='<td>'.$val['phone'].'</td>';
$strTable .='<td>'.$val['que'].'</td>';
$strTable .='</tr>';
}
$strTable .='</table>';
header("Content-type: application/vnd.ms-excel");
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=".'员工表'."_".date('Y-m-d').".xls");
header('Expires:0');
header('Pragma:public');
echo '<html><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />'.$strTable.'</html>';
}
}
首页代码
index.html
<html lang="en">
<head>
<meta charset="UTF-8">
<title>信息管理</title>
<script src="/static/js/jquery.js" type="text/javascript" charset="utf-8"></script>
<style>
a{
text-decoration:none;
background-color:#fffaaa;
padding:2px;
}
</style>
</head>
<body>
<h4>用户信息管理</h4>
<a href="{:url('index/insert')}" style='color:orange; margin-bottom:20px;'>添加</a>
<form action="{:url('index/index')}" method="post" >
查找:<input type="search" class="search" name="search" value="">
<input type="submit" value="搜索">
</form>
<form action="{:url('index/indexdo')}" method="post" id="export" style="display:none;">
</form>
<button onclick="data()">导出</button>
<table border="1" cellpadding="10" cellspacing="0" style='margin-top:20px;'>
<tr>
<td><button id="alls">全选</button></td>
<td>工号</td>
<td>姓名</td>
<td>性别</td>
<td>电话</td>
<td>岗位</td>
<td>操作</td>
</tr>
{volist name="a" id="aa"}
<tr>
<td><input class="checkbox" type="checkbox" value="{$aa.id}" name="checkbox"/></td>
<td>{$aa.num}</td>
<td>{$aa.name}</td>
<td>{$aa.sex}</td>
<td>{$aa.phone}</td>
<td>{$aa.que}</td>
<td>
<a href="{:url('index/updete',['id' => $aa['id']])}" style='color:blue;'>编辑</a>
<a href="{:url('index/deletes',['id' => $aa['id']])}" style='color:red;'>删除</a>
</td>
</tr>
{/volist}
</table>
</body>
<script>
var values=[];//存放判断过后的值
//全选按钮
var all=$("#alls");
var check=$('.checkbox');
alls.onclick = function() {
for (var i = 0; i < check.length; i++) {
check[i].checked = true;
}
len();
}
function len(){
values.splice(0,values.length);
$('input:checkbox:checked').each(function(){
values.push($(this).val());
});
}
//导出按钮
function data(){
len();
$("#export").html('');
$("#export").append("<input type='text' name='fed' value="+values+" >");
$('#export').submit();
}
</script>
</html>
添加信息
insert.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>信息管理</title>
</head>
<body>
<form action="{:url('index/insertdo')}" method="post">
工号 :<input type="text" name="num" value=""><br>
姓名 :<input type="text" name="name" value=""><br>
性别 :男<input type="radio" name="sex" value="男">
女<input type="radio" name="sex" value="女"><br>
电话 :<input type="text" name="phone" value=""><br>
岗位 :<input type="text" name="que" value=""><br>
<input type="submit" value="确定">
</form>
</body>
</html>
修改信息
updete.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>信息管理</title>
</head>
<body>
<form action="{:url('index/updetedo')}" method="post">
工号 :<input type="text" name="num" value="{$info.num}"><br>
姓名 :<input type="text" name="name" value="{$info.name}"><br>
性别 :
{if condition="$info.sex eq '男'"}
男<input type="radio" name="sex" value="男" checked="checked">
女<input type="radio" name="sex" value="女">
{elseif condition="$info.sex eq '女'"}
男<input type="radio" name="sex" value="男">
女<input type="radio" name="sex" value="女" checked="checked">
{/if}<br>
电话 :<input type="text" name="phone" value="{$info.phone}"><br>
岗位 :<input type="text" name="que" value="{$info.que}"><br>
<input type="hidden" value="{$info['id']}" name="id">
<input type="submit" value="确定">
</form>
</body>
</html>
小编建议:PHP初学者的话,要不想一下,先按自己的想法过一遍,试一下,是否行的通,要多试,多想!!!!