<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>无标题文档</title><script src="jquery-1.11.2.min.js"></script></head><body><div> ???<h1>新增</h1> ???辖区：<input type="text" /><br /> ???姓名：<input type="text" /><br /> ???性别：<input type="text" /><br /> ???????证件：<input type="text" /><br /> ???????电话：<input type="text" /><br /> ???住址：<input type="text" /><br /> ???<input type="submit" value="添加" /></div><div><h1>信息</h1><table width="100%" border="1px" cellspacing="0" cellspacing="0"> ???<tr> ???????<td>辖区</td> ???????<td>姓名</td> ???????<td>性别</td> ???????<td>证件</td> ???????<td>电话</td> ???????<td>住址</td> ???????<td>操作</td> ???</tr> ???????<tbody > ???</tbody></table><div style="border-left:2px solid #444; border-bottom:#444 2px solid; border-right:2px solid #444; text-align:center; display:none;color:red" >没有更多信息！！</div></div><div > ???</div></body></html><script type="text/jscript">jia();//添加信息$("#tj").click(function(){ ???????var xq = $("#xiaqu").val(); ???var name = $("#name").val(); ???var sex = $("#sex").val(); ???var zj = $("#zhengjian").val(); ???var tel = $("#tel").val(); ???var zz = $("#zhuzhi").val(); ???????????$.ajax({ ???url:"add.php", ???data:{xq:xq,name:name,sex:sex,zj:zj,tel:tel,zz:zz}, ???type:"POST", ???dataType:"text", ???success:function(data){ ???????????if(data=="1") ???????????{ ???????????????//alert("添加成功"); ???????????????window.location.href="test.php"; ???????????} ???????????else ???????????{ ???????????????alert(""); ???????????????} ???????????????????} ???})})//大方法function jia(){//显示信息$.ajax({url:"cha.php",type:"POST",dataType:"text",success: function(data){ ???????var str = ""; ???????if(data=="111") ???????{ ???????????$("#ts").css("display","block"); ???????} ???????else ???????{ ???????var hang = data.split("|"); ???????????????for(var i=0;i<hang.length;i++) ???????{ ???????????var lie = hang[i].split("^"); ???????????????????????str += "<tr><td>"+lie[1]+"</td><td>"+lie[2]+"</td><td>"+lie[3]+"</td><td>"+lie[4]+"</td><td>"+lie[5]+"</td><td>"+lie[6]+"</td><td><span class=‘sc1‘ bs=‘"+lie[0]+"‘>删除</span> <span class=‘xg1‘ bs=‘"+lie[0]+"‘>修改</span></td></tr>"; ???????} ???????$("#aa1").html(str); ???????//删除信息$(".sc1").click(function(){var code = $(this).attr("bs")if(confirm(‘确定删除么‘)){$.ajax({ ???????url:"shanchu.php", ???????data:{a:code}, ???????type:"POST", ???????dataType:"text", ???????success:function(data){ ???????????if(data=="1") ???????????{ ???????????????//alert("删除成功") ???????????????????window.location.href="test.php"; ???????????} ???????????else ???????????{ ???????????????alert("删除失败") ???????????????????????????????} ???????????????????} ???})}}) ???????????//查询修改的信息$(".xg1").click(function(){var code = $(this).attr("bs")$.ajax({ ???url:"xiugai.php", ???data:{a:code}, ???type:"POST", ???dataType:"text", ???success:function(data){ ???????var str = ""; ???????var hang = data.split("|"); ???????for(var i=0;i<hang.length;i++) ???????{ ???????????var lie = hang[i].split("^"); ???????????????????????str += "<h1>修改</h1><input type=‘hidden‘ id=‘yc‘ value=‘"+lie[0]+"‘ />辖区：<input type=‘text‘ id=‘xiaqu1‘ value=‘"+lie[1]+"‘/><br />姓名：<input type=‘text‘ id=‘name1‘ value=‘"+lie[2]+"‘/><br />性别：<input type=‘text‘ id=‘sex1‘ value=‘"+lie[3]+"‘/><br /> ???证件：<input type=‘text‘ id=‘zhengjian1‘ value=‘"+lie[4]+"‘/><br /> ???电话：<input type=‘text‘ id=‘tel1‘ value=‘"+lie[5]+"‘/><br />住址：<input type=‘text‘ id=‘zhuzhi1‘ ?value=‘"+lie[6]+"‘/><br /><input type=‘submit‘ id=‘xiugai‘ value=‘修改‘ />"; ???????} ???????$("#xgnr").html(str);//修改信息$("#xiugai").click(function(){var yc1 = $("#yc").val();var xq1 = $("#xiaqu1").val();var name1 = $("#name1").val();var sex1 = $("#sex1").val();var zj1 = $("#zhengjian1").val();var tel1 = $("#tel1").val();var zz1 = $("#zhuzhi1").val();$.ajax({url:"xiugaichuli.php",data:{yc:yc1,xq:xq1,name:name1,sex:sex1,zj:zj1,tel:tel1,zz:zz1},type:"POST",dataType:"text",success:function(data){ ???????if(data=="1") ???????{ ???????????//alert("添加成功"); ???????????window.location.href="test.php"; ???????} ???????else ???????{ ???????????alert("11"); ???????????} ?????} ???}) ?})}})})}}}) ???????????????}</script>添加处理页面
1 2 3 4 5 6 7 8 9 10 11 | <?phpinclude("./xsdb.class.php");$xq = $_POST["xq"];$name = $_POST["name"];$sex = $_POST["sex"];$zj = $_POST["zj"];$tel = $_POST["tel"];$zz = $_POST["zz"];$db =newxsdb();$sql ="insert into shuju values(‘‘,‘{$xq}‘,‘{$name}‘,‘{$sex}‘,‘{$zj}‘,‘{$tel}‘,‘{$zz}‘)";echo $db->Query($sql,0); |
删除处理页面
1 2 3 4 5 6 7 8 | <?phpinclude("./xsdb.class.php");$code = $_POST["a"];$db =newxsdb();$sql ="delete from shuju where id=‘{$code}‘";echo $db->StrQuery($sql,0); |
修改处理页面（查找要修改的数据信息）
1 2 3 4 5 6 7 8 | <?phpinclude("./xsdb.class.php");$a = $_POST["a"];$db =newxsdb();$sql ="select * from shuju where id=‘{$a}‘";echo $db->StrQuery($sql); |
修改处理页面（实现数据修改）
1 2 3 4 5 6 7 8 9 10 11 12 | <?phpinclude("./xsdb.class.php");$yc=$_POST["yc"];$xq=$_POST["xq"];$name=$_POST["name"];$sex=$_POST["sex"];$zj=$_POST["zj"];$tel=$_POST["tel"];$zz=$_POST["zz"];$db=newxsdb();$sql="update shuju set xiaqu=‘{$xq}‘,name=‘{$name}‘,sex=‘{$sex}‘,zhengjian=‘{$zj}‘,tel=‘{$tel}‘,zhuzhi=‘{$zz}‘ where id=‘{$yc}‘";echo$db->Query($sql,0); |
查询处理页面
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <?phpinclude("./xsdb.class.php");$db=newxsdb();$sql="select * from shuju";$r=$db->StrQuery($sql);if($r){echo$r;}else{echo"111";} |
数据库封装及返回数据TEXT JSON
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | <?phpclassxsdb{public$host="localhost";public$uid="root";public$pwd="密码";public$dbname="test";//成员方法publicfunctionQuery($sql,$type=1){$db=newMySQLi($this->host,$this->uid,$this->pwd,$this->dbname);$r=$db->query($sql);if($type==1){return$r->fetch_all();}else{return$r;}}//返回字符串的方法publicfunctionStrQuery($sql,$type=1){$db=newMySQLi($this->host,$this->uid,$this->pwd,$this->dbname);$r=$db->query($sql);if($type==1){$attr=$r->fetch_all();$str="";foreach($attras$v){$str.= implode("^",$v)."|";}returnsubstr($str,0,strlen($str)-1);}else{return$r;}}//返回JSONfunctionJSONQuery($sql,$type=1)
我的编程学习网——分享web前端后端开发技术知识。 垃圾信息处理邮箱 tousu563@163.com 网站地图
icp备案号 闽ICP备2023006418号-8
不良信息举报平台
互联网安全管理备案
Copyright 2023 www.wodecom.cn All Rights Reserved |