这篇文章主要介绍了PHP实现数据库的增删查改功能及完整代码,需要的朋友可以参考下
本文用到:jquery、tp框架
TP_3.2.2/Application/Home/Controller/StuController.class.php
display("school/stu"); } public function getdata(){ $Studata = M('stu'); $data['id']=''; $data['name']=I('get.name'); $data['age']=I('get.age'); $data['num']=I('get.num'); $data['address']=I('get.add'); $Studata->add($data); $this->success("正在。。。",U('Stu/showdata')); } public function showdata() { $Studata = M('stu'); $data=$Studata->select(); $this->assign('info',$data); $this->display('school/showdata'); } public function del(){ $id = I('get.id'); $Studata = M('stu'); $bool = $Studata->where(['id'=>$id])->delete(); if($bool){ echo 1; }else{ echo 0; } } public function updata() { $id = I('get.id'); $Studata = M('stu'); $data = $Studata->where(['id'=>$id])->find(); $this->assign('data',$data); $this->display("school/upshowdata"); } public function updatadeal() { $Studata = M('stu'); $id = I('get.id'); $data['name']=I('get.name'); $data['age']=I('get.age'); $data['num']=I('get.num'); $data['address']=I('get.add'); $bool = $Studata->where(['id'=>$id])->save($data); if($bool){ $this->showdata(); }else{ echo 0; } } }
TP_3.2.2/Application/Home/View/school/showdata.html
TP_3.2.2/Application/Home/View/school/stu.html
学号注册查询系统
TP_3.2.2/Application/Home/View/school/stu.html
学号注册查询系统
执行在浏览器里面输入:http://127.0.0.1:90/TP_3.2.2/index.php/Home/Stu/stushow
点击删除
修改:
总结
以上所述是小编给大家介绍的PHP实现数据库的增删查改功能及完整代码,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对html中文网网站的支持!
以上就是PHP实现数据库的增删查改功能及完整代码的详细内容,更多请关注0133技术站其它相关文章!