5月21日 JavaScrip应用t练习
从数据库中查出一张表,实现功能:
1.查看详情:点击时用弹窗显示出详细内容
2.全选:点击时选框全选
3.批量删除:选中的内容点击按钮可以实现删除
主页:
<head> <script src="../jquery-2.2.3.min.js"></script> <script type="text/javascript" src="tanchuang.js"></script>//弹窗引入 <link href="tanchuang.css" rel="stylesheet" type="text/css" /> <style type="text/css"> *{ margin: 0px auto; } </style> </head> <body> <div>请输入名称:<input type="text" id="xinxi" /><input type="button" id="btn" value="查询"/></div> <table id="xianshi" width="100%" border="1" cellpadding="0" cellspacing="0"> </table> </body> <script type="text/javascript"> $(document).ready(function(e) { //做表 $("#btn").click(function(){ var name = $("#xinxi").val(); $.ajax({ async:false, url:"chuli.php", data:{d:name}, type:"POST", dataType:"TEXT", success: function(data){ var str = "<tr><td>代号</td><td>名称</td><td>价格</td><td>产地</td><td>操作</td></tr>"; var hang = data.split("|"); for(var i=0;i<hang.length;i++) { var lie = hang[i].split("^"); str +="<tr><td><input type='checkbox' class='t' value='"+lie[0]+"'/>"+lie[0]+"</td><td>"+lie[1]+"</td><td>"+lie[2]+"</td><td>"+lie[3]+"</td><td><div class='ck' bs='"+lie[0]+"'>查看详情</div></td></tr>"; } str +="<tr><td><input type='checkbox' id='all' />全选 <input type='button' value='批量删除' id='delete' /></td></tr>"; $("#xianshi").html(str); //设置弹窗 $(".ck").click(function(){ var t = $(this).attr("bs"); $.ajax({ async:false, url:"chakan.php", data:{t:t}, type:"POST", dataType:"TEXT", success: function(data) { //alert(data); var lie = data.split("^"); var html = "<div>代号:"+lie[0]+"名称:"+lie[1]+"价格:"+lie[2]+"产地:"+lie[3]+"</div>"; //alert(html); var wd = new Window({ width : 700, //宽度 height : 500, //高度 title : '弹窗', //标题 content : html, //内容 isMask : true, //是否遮罩 buttons :"", //按钮 isDrag:true, }); } }); }); //设置全选 $("#all").click(function(){ var ck = $(".t"); var xz = $(this)[0].checked; ck.prop("checked",xz); }); //取选中的值,删除 $("#delete").click(function(){ var ck = $(".t"); for(var i=0;i<ck.length;i++) { if(ck.eq(i).prop("checked")) { var v = $(".t").eq(i).val(); $.ajax({ url:"shanchu.php", data:{v:v}, type:"POST", dataType:"TEXT", success: function(data){ //alert(data); if(data=="OK") { alert("删除成功!"); window.location="text.php"; } else { alert("删除失败!"); } } }); } } }) } }); }) }) </script>
chuli.php页面:
<?php $name = $_POST["d"]; include("../DBDA.class.php"); $db = new DBDA(); $sql = "select * from fruit where name like'%{$name}%'"; echo $db->StrQuery($sql);
chakan.php页面:
<?php $code = $_POST["t"]; include("../DBDA.class.php"); $db = new DBDA(); $sql = "select * from fruit where Ids = '{$code}'"; echo $db->StrQuery($sql);
shanchu.php页面:
<?php $ids = $_POST["v"]; include("../DBDA.class.php"); $db = new DBDA(); $sql = "delete from fruit where Ids ='{$ids}'"; //echo $sql; $r = $db->Query($sql,0); if($r) { echo "OK"; } else { echo "NO"; }