標籤：idt char oct imp value button trim .class from
首頁面<!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><h1>顯示資料</h1> <table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td>代號</td> <td>名稱</td> <td>操作</td> </tr> <tbody id="tb"> </tbody> </table> </body><script type="text/javascript"> //載入資料Load(); //載入資料的方法function Load(){$.ajax({ url:"jiazai.php", 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 = str+"<tr><td>"+lie[0]+"</td><td>"+lie[1]+"</td><td><input type=‘button‘ code=‘"+lie[0]+"‘ value=‘刪除‘ class=‘sc‘ /></td></tr>"; } $("#tb").html(str); //刪除事件 $(".sc").click(function(){ var code = $(this).attr("code"); $.ajax({ url:"shanchu.php", data:{code:code}, dataType:"TEXT", type:"POST", success: function(d){ if(d.trim()=="OK") { alert("刪除成功"); Load(); } else { alert("刪除失敗"); } } }); }) } }); } </script></html>
首頁中，ajax引用的載入頁面
<?phpinclude("../LZY.class.php");$db = new LZY(); $sql = "select * from nation";$arr = $db->Query($sql); $str = "";foreach($arr as $v){ $str = $str.implode("^",$v)."|";}$str = substr($str,0,strlen($str)-1);echo $str;
效果如
接著我們刪除處理頁面
<?phpinclude("../LZY.class.php");$db = new LZY();$code = $_POST["code"];$sql = "delete from nation where code=‘{$code}‘";if($db->Query($sql,0)){ echo "OK";}else{ echo "NO";}
用ajax做登入與刪除
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
