Advertisement
Guest User

Untitled

a guest
Aug 26th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. Tabela1:
  2. Id int A_I;
  3. Modelo varchar;
  4.  
  5. Tabela2:
  6. Id int A_I;
  7. Id_fk int (foreign key da tabela1);
  8. cor;
  9.  
  10. SELECT * FROM Tabela1 JOIN Tabela2 ON Tabela1.id = Tabela2.Id_fk;
  11.  
  12. $selTab1 = mysqli_query($conn, "SELECT * FROM tabela1;");
  13. $dataJoin = array();
  14. while ($rowTab1 = $selTab1->fetch_assoc()) {
  15. $selTab2 = mysqli_query($conn, "SELECT * FROM tabela2 where Id_fk={$rowTab1['id']};");
  16. if($selTab2->num_rows > 0) {
  17. $rowTab2 = $selTab2->fetch_assoc();
  18. $dataJoin[] = array(
  19. 'tab1_id' => $rowTab1['id'],
  20. 'Modelo' => $rowTab1['Modelo'],
  21. 'tab2_id' => $rowTab2['id'],
  22. 'cor' => $rowTab2['cor']
  23. );
  24. }
  25. }
  26. echo '<pre>', print_r($dataJoin), '</pre>'; // aqui já vai ter os dados das duas
  27.  
  28. $selTab1 = mysqli_query($conn, "SELECT * FROM tabela1;");
  29. $dataJoin = array();
  30. while ($rowTab1 = $selTab1->fetch_assoc()) {
  31. $selTab2 = mysqli_query($conn, "SELECT * FROM tabela2 where Id_fk={$rowTab1['id']};");
  32. while($rowTab2 = $selTab2->fetch_assoc()) {
  33. $dataJoin[] = array(
  34. 'tab1_id' => $rowTab1['id'],
  35. 'Modelo' => $rowTab1['Modelo'],
  36. 'tab2_id' => $rowTab2['id'],
  37. 'cor' => $rowTab2['cor']
  38. );
  39. }
  40. }
  41. echo '<pre>', print_r($dataJoin), '</pre>'; // aqui já vai ter os dados das duas
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement