Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2020
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.55 KB | None | 0 0
  1. $sql ="SELECT fields.. FROM customer
  2. INNER JOIN addresses USING(customer_id )
  3. WHERE customer_id = 123
  4. ";
  5.  
  6. $statement = $this->connection->query($sql);
  7.  
  8. $loadedCustomers = [];
  9. while($row = $statment->fetch()){
  10. if(!isset($loadedCustomers[$row->customer_id])){
  11. $customer = $customerHydrator->createFromStdObject($row);
  12. $loadedCustomers[$row->customer_id] = $customer;
  13. }
  14. $customer = $loadedCustomers[$row->customer_id];
  15. $address = $addressHydrator->createFromStdObject($row);
  16. $customer->addAddress($address);
  17. }
  18.  
  19. return array_values($loadedCustomers);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement