php - 将数据合并到一个数组中
问题描述
你能告诉我我想念什么吗?如何将所有数据放在一个数组中?查询 atm 看起来像这样
$query = $this->db->query("SELECT
oc_fast_order_option.*,
oc_product_description.name AS product_name,
oc_fast_order.quantity
FROM oc_fast_order_option
LEFT JOIN oc_fast_order ON (oc_fast_order.id = '" . $order_id . "')
LEFT JOIN oc_product_description ON (oc_product_description.product_id = oc_fast_order.product_id)
WHERE order_id = '" . $order_id . "'");
return $query->rows;
此查询的结果在几个数组中是分开的,当我循环时,我无法正确显示结果
Array
(
[0] => Array
(
[order_option_id] => 56
[order_id] => 118
[order_product_id] => 52
[product_option_id] => 745
[product_option_value_id] => 1104
[name] => Цветове:
[value] => Черен
)
[1] => Array
(
[order_option_id] => 55
[order_id] => 118
[order_product_id] => 52
[product_option_id] => 746
[product_option_value_id] => 0
[name] => new input
[value] => 3
)
)
我怎么能得到这样的东西?
Array
(
[option_id] = >
Array(
[order_option_id] => 56
[order_option_id] => 55
)
[order_id] => 118
[order_product_id] => 52
[product_option_id] => 745
[product_option_value_id] => 1104
[options] = >
Array(
[name] => Цветове:
[value] => Черен
)
)
我试图做的是循环它们并放入一个数组
foreach ($query->rows as $data) {
$data['info_options'][] = array(
'options' => array(
'option_name' => $data['name'],
'value_name' => $data['value']
),
'quantity' => $data['quantity'],
'product_link' => HTTP_CATALOG.'index.php?route=product/product&product_id=' . $product_id,
'product_name' => $data['product_name']
);
}
但结果仍然不合格
Array
(
[0] => Array
(
[options] => Array
(
[option_name] => Цветове:
[value_name] => Черен
)
[quantity] => 1
[product_name] => aapp
)
[1] => Array
(
[options] => Array
(
[option_name] => new input
[value_name] => 3
)
[quantity] => 1
[product_name] => aapp
)
[2] => Array
(
[options] => Array
(
[option_name] => Custom-Input
[value_name] => 5
)
[quantity] => 1
[product_name] => aapp
)
)
更新 终于我得到了我需要的东西
Array
(
[op] => Array
(
[0] => Array
(
[name] => Цветове:
[value] => Черен
)
[1] => Array
(
[name] => new input
[value] => 3
)
[2] => Array
(
[name] => Custom
[value] => 5
)
)
[name] => aapp
[quantity] => 1
)
我所做的是 2 个查询,一个用于选项,一个用于其余信息,然后我循环选项查询并将结果放入一个数组中,然后循环第二个查询并放入我添加的新数组和选项数组
解决方案
推荐阅读
- php - Symfony 4 错误:编译错误:无法声明类,因为名称已在使用中
- python - 与轮廓中大多数点接触的最大正方形
- database - react-native mongo db数据更新缓冲
- ios - UIView 显示/隐藏动画:隐藏动画似乎不起作用
- javascript - 如何在 JSON 数组中呈现第 n 个对象:ReactJS
- vue.js - 字体颜色 v-select 项不能更改
- android - 使用 Retrofit 和 moshi -Android 解析 Json 失败
- r - \\n 是什么意思以及如何删除它?
- c++ - 如何判断#define 是否有值
- elasticsearch - 带有必须和应该的 Elasticsearch 术语查询