php教程改数据库,php实现数据库增删查改步骤详解

这次给大家带来php实现数据库增删查改步骤详解，php实现数据库增删查改的注意事项有哪些，下面就是实战案例，一起来看一下。

TP_3.2.2/Application/Home/Controller/StuController.class.php<?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">

学号注册查询系统

名字:

年龄:

学号:

籍贯:

执行在浏览器里面输入：http://127.0.0.1:90/TP_3.2.2/index.php/Home/Stu/stushow

点击删除

修改：

相信看了本文案例你已经掌握了方法，更多精彩请关注php中文网其它相关文章！

推荐阅读：