php - MySQL 结果到 PHP 数组
问题描述
我正在尝试获取这种格式的 json 数组:
var js_array = [
["Name1", "Address1", "Url1"],
["Name2", "Address2", "Url2"],
etc...
]
来自 MySQL 查询。这是我的数据库:
+---------+-------------+---------+
| Name | Address | URL |
+---------+-------------+---------+
| Name1 | Address1 | Url1 |
| Name2 | Address2 | Url2 |
| Name3 | Address3 | Url3 |
+---------+-------------+---------+
我试过这个:
$query = $bdd->query('SELECT Name, Adress, URL FROM festivals');
while ($row = $query->fetch()) {
$array[] = $row['Name'];
$array[] = $row['Adress'];
$array[] = $row['URL'];
}
//Then I return it as an js array that I use later
$js_array = json_encode($array);
结果是:
["Name1", "Address1", "Url1", "Name2", "Address2", "Url2", "Name3", "Address3", "Url3"]
我也试过这个:
$query = $bdd->query('SELECT Name, Adress, URL FROM festivals');
while ($row = $query->fetch()) {
$array[] = $row;
}
//Then I return it as an js array that I use later
$js_array = json_encode($array);
返回这个:
[
{0: "Name1", 2: "Address1", 2: "Url1", Name: "Name1", Address: "Address1", URL: "Url1"},
{0: "Name2", 2: "Address2", 2: "Url2", Name: "Name2", Address: "Address2", URL: "Url2"}
]
有没有办法得到我想要的?谢谢
解决方案
您只需要为其中只有值的每一行创建一个数组:
$query = $bdd->query('SELECT Name, Adress, URL FROM festivals');
while ($row = $query->fetch()) {
$array[] = array($row['Name'], $row['Adress'], $row['URL']);
}
//Then I return it as an js array that I use later
$js_array = json_encode($array);
推荐阅读
- css - 如何在 video.js 播放器中禁用框阴影和边框
- ssl - 错误 488 此处不可接受
- php - CodeIgniter BMI 计算器不工作
- ruby-on-rails - rails - 获取模型保存的 SQL
- mayavi - 在 mayavi 中沿流线检索值
- ruby-on-rails - 亚马逊 ec2 t2micro 实例上的 Elasticsearch
- r - 使用 R 在 GLM 回归中运行所有可能的交互
- angular - 当我是 Observable.interval 时如何允许函数 sortbydate()
- vba - 如何选择过滤器位置而不是它的实际名称?
- node.js - Mongoose 5.0.15 / MongoDB 3.6.4 转换为数组失败的值 [NaN,NaN]