php链接数据库实行增删查改_PHP实现数据库的增删查改功能及完整代码

本文用到：jquery、tp框架

TP_3.2.2/Application/Home/Controller/StuController.class.php

/**

* Created by PhpStorm.

* User: root

* Date: 2018/4/17

* Time: 16:32

*/

namespace Home\Controller;

use Think\Controller;

class StuController extends Controller

{

public function StuShow(){

$this->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

数据展示界面

学生信息展示

{$vo['id']}

{$vo['name']}

{$vo['age']}

{$vo['num']}

{$vo['address']}

删除

修改

$('.del').click(function () {

var where = $(this).attr('where');

$.ajax({

type: "get",

url: "{:U('Stu/del')}?id="+where,

success: function(msg){

if(msg==1){

alert('删除成功');

location.href('showdata');

}else {

alert('删除失败');

}

}

});

})

$('.up').click(function () {

var where = $(this).attr('where');

location.href('updata?id='+where);

// $.ajax({

// type: "get",

// url: "{:U('Stu/updata')}?id="+where,

// success: function(msg){

// $('#content').html(msg);

// }

// });

})

TP_3.2.2/Application/Home/View/school/stu.html

content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">

学号注册查询系统

名字:

年龄:

学号:

籍贯:

TP_3.2.2/Application/Home/View/school/stu.html

content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">

学号注册查询系统

名字:

年龄:

学号:

籍贯:

点击删除

修改：

总结

以上所述是小编给大家介绍的PHP实现数据库的增删查改功能及完整代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持！