Bootstrap+jq+jqajax+php+数据库增删改查源码

js

 script  //渲染页面 $.ajax({ url: index.php , data:{ action: get  dataType: json , success:function(data){ var html=  $(data).each(function (i,v) { html+= tr  html+= td input type= checkbox title= +data[i].id+ >
PHP
 ?php * Created by yangweishuo. * User: ASUS * Date: 2018/1/10 * Time: 16:11 require( lib/DB.php $sqls=new Mysqldb(); //渲染页面 if($_REQUEST[ action ]== get ){ $sql= select * from student $con=$sqls- query($sql); echo $con; //添加 else if($_REQUEST[ action ]== add ){ $username=$_REQUEST[ username $pwd=$_REQUEST[ pwd $sex=$_REQUEST[ sex $love=$_REQUEST[ like $sql= insert into student (username,pwd,sex,love)VALUES ( $username , $pwd , $sex , $love ) $con=$sqls- update($sql); echo $con; //删除 else if($_REQUEST[ action ]== del ){ $id=$_REQUEST[ id $sql= delete from student where id=$id $con=$sqls- update($sql); echo $con; //批量删除 else if($_REQUEST[ action ]== del ){ $id=$_REQUEST[ id $sql= delete from student where id in( $id ) $con=$sqls- update($sql); echo $con; //修改 //先cha查找 else if($_REQUEST[ action ]== upd ){ $id=$_REQUEST[ id $sql= select * from student where id= $id $con=$sqls- query($sql); echo $con;} else if($_REQUEST[ action ]== update ){ $id=$_REQUEST[ id $username=$_REQUEST[ username $pwd=$_REQUEST[ pwd $sex=$_REQUEST[ sex $love=$_REQUEST[ like $sql= update student set username= $username ,pwd= $pwd ,sex= $sex ,love= $love WHERE id=$id $con=$sqls- update($sql); echo $con; //查找 if($_REQUEST[ action ]== query ){ $username=$_REQUEST[ username $sql= select * from student WHERE username LIKE %$username% $con=$sqls- query($sql); echo $con; //按条件查找 if($_REQUEST[ action ]== limits ){ $username=$_REQUEST[ username $sql= select * from student limit $username $con=$sqls- query($sql); echo $con;? 
DB.php
 ?php header( Content-Type:Text/html;charset=UTF-8 class Mysqldb{ //创建属性 private $conn; public function __construct($host= localhost ,$user= root ,$pwd= root ,$database= test ){ $this- conn=mysqli_connect($host,$user,$pwd,$database); if($this- conn){ $this- conn- set_charset( utf8  } public function query($sql){ $result=mysqli_query($this- conn,$sql); $arr=array(); while($row=mysqli_fetch_array($result)){ array_push($arr,$row); mysqli_free_result($result); return json_encode($arr); } public function update($sql){ $result=mysqli_query($this- conn,$sql); $arr=array(); if($result){ $arr[ flag ]=true; $arr[ msg ]= 操作成功  }else{ $arr[ flag ]=false; $arr[ msg ]= 操作失败  } return json_encode($arr); } public function __destruct(){ mysqli_close($this- conn); $this- conn=null; }? 
js文档结构图 

本文讲解了Bootstrap+jq+jqajax+php+数据库增删改查源码 ，更多相关内容请关注php 。
相关推荐：
购物车功能实现 通过 php+MySQL+jQuery+Ajax，实现购物车功能
如何通过linux系统部Linux下Nginx+PHP+Mysql环境搭建流程
讲解署php+mysql+apache 相关操作
以上就是Bootstrap+jq+jqajax+php+数据库增删改查源码的详细内容，PHP教程        
郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。