php - 将 jquery 字符串转换为 php

Question

所以我有一个从数据库获取坐标集的 php，我希望它通过 jquery 变量运行。 这是 PHP -

$sql = "SQL that works";
$vari = mysqli_query($con,$sql);
while($row = mysqli_fetch_array($loc))
{echo "[";
 echo "''";
 echo $row['cor1'];
 echo ",";
 echo $row['cor2'];
 echo "]";
}

这是我希望它以这种形式传递的 jquery -

var markers = [
['', 51.503454,-0.119562],
['', 51.499633,-0.124755]
];

Answer 1

实际上你必须像下面这样更改你的 php 代码:-

$sql = "SQL that works";
$vari = mysqli_query($con,$sql);
$data = array(); //create an rray variable
while($row = mysqli_fetch_assoc($loc)){ // use assoc for lighter $row array 
 $data[] = array('',$row['cor1'],$row['cor2']); // create sub-array and assign to final array
}

echo json_encode($data); //return final data to ajax

注意:-现在通过 parseJSON() 在 jQuery 中解码此 json 并执行进一步的代码。