ajax代码:
$.ajax ({
type:"GET",
url:'qinghua.php',
dataType:"json",
data: {'year':2015 //把year=2015传给php
},
success: function(data){
alert(eval(data)[4][0]);
}
});
php代码:
<?php
header('Content-type:text/json;charset=utf-8');
@ $db = mysqli_connect('localhost','root','');
mysqli_select_db($db,'mapdata');//找到数据库mpicture
if(mysqli_connect_errno()){
echo "Error:Could not connect to mysqli database.";
exit;
}
$year=$_GET['year']; //从ajax中获得year的值
$p1="SELECT x(site) FROM mapdata.$year";
$p2="SELECT y(site) FROM mapdata.$year";
$p3="SELECT * FROM mapdata.$year";
$q="SELECT count(*) FROM mapdata.$year";
$resultx = mysqli_query($db,$p1);//执行$p的mysql语句,并赋给resultx
$resulty = mysqli_query($db,$p2);
$resultinformation = mysqli_query($db,$p3);
$result2 = mysqli_query($db,$q);
$row2 = mysqli_fetch_array($result2);
//$rownum = mysqli_num_rows($result);//获取result的数据数量
//echo $row2[0];
$information=array(array());
for($i=0;$i<$row2[0];$i++){
$rowx = mysqli_fetch_assoc($resultx);//获取result的一条数据
$rowy = mysqli_fetch_assoc($resulty);//获取result的一条数据
$rowinformation=mysqli_fetch_assoc($resultinformation);
$information[0][$i]= $rowx;
$information[1][$i]= $rowy;
$information[2][$i]= $rowinformation['country'];
$information[3][$i]= $rowinformation['number'];
$information[4][$i]= $rowinformation['firstnumber'];
}
//echo $information[0][0];
//$information[5][0]=$row2[0];
echo json_encode($information); //读出information的值给ajax;
?>