PHP TP增删改
添加数据(注意表名大小写)
1.数组方式(add)
$model=D("Info"); $info=array("Code"=>"p080","Name"=>"学习","Sex"=>true,"Nation"=>"n001","Birthday"=>"1998-2-3"); $model->add($info);
2.AR方式(给成员赋值后直接调用add方法)
$model=D("Info"); $model->Code="p081"; $model->Name="学习1"; $model->Sex=0; $model->Nation="n001"; $model->Birthday="1998-2-3"; $model->add();
3.自动收集表单(create)
if(empty($_POST)) { $nation=D("Nation"); $attr=$nation->select(); $this->assign("attr",$attr); $this->display(); } else { $model=D("Info"); $rules=array( array("Code","require","代号不能为空",0,"regex",3), ); if(!$model->validate($rules)->create()) { echo $model->getError(); } else { $model->Sex=$_POST["Sex"]=="1"?true:false; $bs=$model->add(); //跳转页面 //1.成功后跳转:success("提示的话","跳转的操作方法",等待的时长) //2.失败后跳转:error("提示的话","默认跳回上一个页面") if($bs) { $this->success("添加成功","test"); } else { $this->error("添加失败"); } } }
test.html
<form action="__ACTION__" method="post"> <div>代号:<input id="dh" type="text" name="Code" /></div> <span id='dhyz'></span> <div>姓名:<input type="text" name="Name" /></div> <div>性别:男<input type="radio" name="Sex" value="1" /> 女<input type="radio" name="Sex" value="0" /></div> <div>民族: <select name="Nation"> <foreach name="attr" item="v"> <option value="<{$v.code}>"><{$v.name}></option> </foreach> </select> </div> <div>生日:<input type="text" name="Birthday" /></div> <div><input type="submit" value="提交" /></div> </form>
修改(save)
function XiuGai() { //修改(save) $code=$_GET["code"]; $model=D("Info"); $nation=D("Nation"); if(empty($_POST)) { $info=$model->find($code); $nations=$nation->select(); $names=$info["nation"]; $this->assign("nation",$nations); $this->assign("info",$info); $this->display(); } else { $model->create(); $model->save(); } }
xiugai.html
<form action="__ACTION__" method="post"> <input type="hidden" name="Code" value="<{$info.code}>" /> <div>姓名:<input type="text" name="Name" value="<{$info.name}>" /></div> <div>性别: <if condition="$info.sex == 1"> 男<input type="radio" name="Sex" value="1" checked="checked" /> 女<input type="radio" name="Sex" value="0" /> <else /> 男<input type="radio" name="Sex" value="1" /> 女<input type="radio" name="Sex" value="0" checked="checked" /> </if> </div> <div>民族: <select name="Nation"> <foreach name="nation" item="v"> <if condition="$v['code'] == $info['nation']"> <option selected="selected" value="<{$v.code}>"> <{$v.name}> </option> <else /> <option value="<{$v.code}>"> <{$v.name}> </option> </if> </foreach > </select> </div> <div>生日:<input type="text" name="Birthday" value="<{$info.birthday}>" /></div> <div><input type="submit" value="修改" /></div> </form>
删除(delete)
function ShanChu() { $model=D("Info"); //1.根据where条件删除多条 $model->where("Code='p083'")->delete(); //2.$model->delete("主键值");删除一条数据 $model->delete("p082"); }