我有这个php脚本,它应该输出一个json数组,它确实输出了,但我的json数组以[[]开头,为什么会有两个额外的方括号[]?
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "mydb";
$conn = mysql_connect($servername, $username, $password,$dbname);
$result = mysql_query("select * from mydb.mytable" )
or die(mysql_error());
//create an array
$emparray[] = array();
while($row =mysql_fetch_assoc($result))
{
$emparray[] = $row;
}
$object = $emparray;
echo json_encode($object) ;
您不需要再次用array
分配$emparray[]
。
你可以试试下面的
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "mydb";
$conn = mysql_connect($servername, $username, $password,$dbname);
$result = mysql_query("select * from mydb.mytable" )
or die(mysql_error());
//create an array
//$emparray[] = array(); change this one below one
$emparray = array();
while($row =mysql_fetch_assoc($result))
{
$emparray[] = $row;
}
// no need to create additional variable
//$object = $emparray;
echo json_encode($emparray) ;