js
$.ajax({
url:'http://localhost/IQCInspect/resources/DataFinder.php',type:'GET',
dataType:'json',
timeout:1000,
cache:false,
beforeSend:function(){
$("#findtable").html('加载中。。。');
},
error:function(){
alert("error");
},
success:succFunction
});
function succFunction(json){
$("#findtable").html('');
// var json = eval(data);
$.each(json, function (index, item) {
//循环获取数据
var iccid = json[index].iccid;
var partno = json[index].partno;
var lotno = json[index].lotno;
var po = json[index].po;
$("#findtable").append("<tr><td>"+iccid+"</td><td>"+partno+"</td><td>"+lotno+"</td><td>"+po+"</td></tr>");
});
}
php
<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE);
header("Access-Control-Allow-origin:*");
header("Content-type:text/html;charset=utf-8");
$link=@mysql_connect('localhost','root','pudding') or die('连接数据库失败');
mysql_select_db('upload_iccid',$link);
mysql_query('set names utf8');
$sql = "SELECT * FROM iccid";
$result = mysql_query($sql);
if(!$result){
printf("Error: %s\n",mysql_error());
exit();
}
$jarr = array();
while($rows=mysql_fetch_array($result,MYSQL_ASSOC)){
$count=count($rows);
for($i=0;$i<$count;$i++){
unset($rows[$i]);
}
array_push($jarr,$rows);
}
echo $str=json_encode($jarr);
?>