我有一个
PHP脚本,它从我的sql Server返回以下json:
$server = "DEVTEST-PC\\SRVCLT";
$options = array("UID"=>"sa","PWD"=>"1234","Database"=>"Test");
$conn = sqlsrv_connect($server,$options);
if ($conn === false) die("
".print_r(sqlsrv_errors(),true));
//echo "Successfully connected!";
$result = sqlsrv_query($conn,"SELECT Currency,USDRate FROM Pax.CurrencyRate
WHERE GBPRate BETWEEN 80 AND 800;");
if($result === false) {
die( print_r( sqlsrv_errors(),true) );
}
while( $row = sqlsrv_fetch_array($result,sqlSRV_FETCH_ASSOC) ) {
$myArray['paxcurjson'][] = $row;
}
echo json_encode($myArray);
?>
输出如下:
{"paxcurjson":[
{"Currency":"AFN","USDRate":49.5},{"Currency":"ALL","USDRate":103.567},{"Currency":"BDT","USDRate":77.562},{"Currency":"DZD","USDRate":79.6146}]}
我正在使用Jquery来解析它但由于某种原因它无法解析.我的代码如下:
var url = 'CurrencyQuery.PHP';
$.getJSON(url,function(data){
for (i = 0; i < data.paxcurjson.length; i++) {
console.log(data.paxcurjson[2].Currency);
};
});
我从控制台获取的唯一错误消息是:
08:52:52.661找不到元素1 CurrencyQuery.PHP:24:4
这基本上是指我的PHP脚本返回json.我不知道为什么这不起作用.我已经使用在线验证器验证了JSON,看起来没问题和Jquery,它应该没问题.谁能给我一个线索?