1.添加html
<form action="{:U('Tel/add')}" method="post">
手机名称 <input type="text" name="mname" id=""><br>
手机价格 <input type="number" name="mprice" id=""><br>
所属品牌 <select name="bid">
<option value="">--请选择品牌--</option>
<foreach name="data" item="vo">
<option value="{$vo.bid}">{$vo.bname}</option>
</foreach>
</select><br>
<input type="submit" value="手机添加">
</form>
2.修改.html
<form action="{:U('Tel/update')}" method="post">
<!-- 使用隐藏域传id值到修改页面 -->
<input type="hidden" name="id" value="{$telinfo.id}">
手机名称 <input type="text" name="mname" value="{$telinfo.mname}"><br>
手机价格 <input type="number" name="mprice" value="{$telinfo.mprice}"><br>
所属品牌 <select name="bid">
<option value="">--请选择品牌--</option>
<foreach name="data" item="vo">
<eq name="vo.bid" value="$telinfo.bid">
<option value="{$vo.bid}" selected >{$vo.bname}</option>
<else/>
<option value="{$vo.bid}">{$vo.bname}</option>
</eq>
</foreach>
</select><br>
<input type="submit" value="手机修改">
</form>
3.控制器
<?php
namespace Home\Controller;
use Think\Controller;
use Think\Request;
class TelController extends Controller{
public function create(){
// 查询品牌表中数据
$Brand = M("Brand");
$data = $Brand->select();
$this->assign("data",$data);
$this->display();
}
public function add(){
$Tel = M("Tel");
$data['bid'] = I("bid");
$data['mname'] = I("mname");
$data['mprice'] = I("mprice");
$data['mtime'] = date("Y-m-d h:i:s",time());
$res = $Tel->add($data);
if($res){
$this->success("添加成功",U("tel/show"));die;
}else{
$this->error("添加失败",U("tel/create"));die;
}
}
//列表
public function show(){
//两表联查
$Tel = M('Tel a');
$list = $Tel->join('brand b ON a.bid=b.bid')->select();
$this->assign("list",$list);
$this->display();
}
//删除
public function delete(){
//接收id值
$id = I("id");
$Tel = M("Tel");
$res = $Tel->where("id=$id")->delete();
if($res){
$this->success("删除成功",U("tel/show"));die;
}else{
$this->error("删除失败",U("tel/show"));die;
}
}
// 编辑
public function edit(){
$id = I("id");
$Tel = M("Tel");
$telinfo = $Tel->where("id=$id")->find();
$this->assign("telinfo",$telinfo);
// 查询品牌表中数据
$Brand = M("Brand");
$data = $Brand->select();
$this->assign("data",$data);
$this->display();
}
//修改
public function update(){
$Tel = M("Tel");
$id = I("id");
$data["bid"] = I("bid");
$data["mname"] = I("mname");
$data["mprice"] = I("mprice");
$res = $Tel->where("id=$id")->save($data);
if($res===1){
$this->success("修改成功",U("show"));die;
}else if($res===0){
$this->error("数据未做修改",U("tel/edit/id/".$id));die;
}else{
$this->error("修改失败",U("tel/edit/id/".$id));die;
}
}
}
4.tel表(手机表)
记录学习点滴,支持原创,希望对您有所帮助!