我有以下PHP代码:
while($row = mysqli_fetch_array($query))
{
$data = $row['name'];
}
我在数据库中获取列名"name"的所有数据。我怎么能这样输出它?
["John", "Doe", "Deer"]
你必须$data数组类型变量。
while($row = mysqli_fetch_array($query))
{
$data[] = $row['name'];
}
print_r($data); // required output
while($row = mysqli_fetch_array($query))
{
$data[] = $row['name'];
}
print_r($data); // output key wise display like
Array ( [0] => John [1] => Doe ) etc.
但是按照您的建议输出,然后只需添加json_encode()
print_r(json_encode($data)); // output like
["John", "Doe", "Deer"]
$data = [];
while($row = mysqli_fetch_array($query))
{
$data = $row['name'];
}
echo json_encode($data); // or you can use print_r for debugging.
你需要对数组使用 json_encode() 方法才能在 jquery 中被接受。重新排列代码,如下所示..
$data = array();
while($row = mysqli_fetch_array($query))
{
$data[] = $row['name'];
}
$new_array = json_encode($data);
echo $new_array; // use 'echo' to print. The json_encode() convert $data array to string.