標籤：
利用ajax資料庫
利用AJAX查詢資料<!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>AJAX查詢資料</title><script src="../jquery-1.11.2.min.js"></script> </head> <body><input type="button" value="顯示資料" id="btn" /><table id="xianshi" width="100%" cellpadding="0" cellspacing="0" border="1"></table> </body><script type="text/javascript">$(document).ready(function(e) { $("#btn").click(function(){ $.ajax({ url:"chuli1.php", dataType:"TEXT", success: function(data){ //alert(data); var str = "<tr><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>"+lie[0]+"</td><td>"+lie[1]+"</td><td>刪除</td></tr>"; str+="<tr>"; for(var j=0;j<lie.length;j++) { str+="<td>"+lie[j]+"</td>"; } str+="</tr>" } $("#xianshi").html(str); } }); }) }); </script></html>
處理頁面：主要是講二維數組裝換成字串的形式
<?php include("../test0506/DBDA.class.php");$db = new DBDA(); $sql = "select * from Nation"; $attr = $db->Query($sql);//返回一個二維數組 //將二維數群組轉換成字串格式因為ajax返回的是text格式的//echo "p001^漢族|p002^滿族|p003^回族";//類似這種格式的才可以 $str = "";foreach($attr as $v){ //$str = implode("^",$v);//$v裡面含有一條一條的資料，列與列之間的 $str = $str.implode("^",$v);//否則等再次迴圈時會被替換 $str = $str."|"; } $str = substr($str,0,strlen($str)-1);//截取字串的長度echo $str;
顯示結果
利用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
