如何获取连接表数据并在php中传递内部数组

作者: 大魔王
发布时间: 2024-10-06 03:49:24 (21小时前)
转自：

4 条回复

0#
回复此人
不见你 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 有些情况下你没有收到送货地址，在这种情况下，你需要检查它是否存在。为此目的使用哈希实用程序。我将数据转换为数组，以便Hash类工作。 </p> <pre> <code> public function getOrderlist(){ if($this->processRequest){ $err = false; if(empty($this->requestData['id'])){ $this->responceData['message'] = "Please provide User ID"; $err = true; } if(!$err){ $id = trim($this->requestData['id']); $conditions = array('Order.user_id'=>$id); $data =(array) $this->Order->find('all',array('conditions'=>$conditions)); if(!empty($data)){ $c = array(); foreach ($data as $key => $value) { $c[] = array( 'Id' => Hash::get($value, 'Order.id'), 'deliveryAddress' => current(Hash::extract($value, 'OrderDetail.{n}.delivery_address', array())) ); } } $this->responceData['result'] = $c; $this->responceData['status'] = 1; } } } </code> </pre> </DIV>

编辑
1#
回复此人
一生浮华 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 你可以尝试下面的代码。 </p> <pre> <code> foreach ($data as $key => $value) { $c[] = array( 'Order' => array( 'id'=>$value['Order']['id'], 'detail_location_instructions' => $value['Order']['detail_location_instructions'], ), 'OrderDetail' => array( 'order_id'=>$value['Order']['id'], 'deliveryAddress' => $value['OrderDetail']['delivery_address'], ), ) } </code> </pre> </DIV>

编辑
2#
回复此人
NetworkAttachedStorage | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 您必须将deliveryAddress放在数组中 </p> <pre> <code> $c = array(); foreach ($data as $key => $value) { $myOrders = [ 'Id'=>$value['Order']['id'], 'deliveryAddress'=>[] ]; foreach($value['OrderDetail'] as $address){ $myOrders['deliveryAddress'][] = $address['delivery_address']; } $c[] = $myOrders; } </code> </pre> <P> 希望这会有所帮助 </p> </DIV>

编辑

登录后才能参与评论