Advertisement
bennetg

Untitled

Dec 15th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. $pdo = new PDO('mysql:host=localhost;dbname=tutorial', 'la', '123123');
  3.  
  4. $sql = "SELECT * FROM `kilian` WHERE `id` = 1";
  5. $sql2 = "SELECT * FROM `kilian` WHERE `id` = 2";
  6. foreach ($pdo->query($sql) as $row) {
  7. $date1 = $row['datum'];
  8. $weight1 = $row['gewicht'];
  9. }
  10. // neues:
  11. $sql = "SELECT * FROM kilian";
  12. $arr = array();
  13. foreach ($pdo->query($sql) as $row) {
  14. $arr[$row['id]] = $row;
  15. }
  16.  
  17. // Jetzt kannst du auf Daten mit $arr[<id>] zugreifen. Also wenn du das Gewicht für ID: 4 haben möchtest, sieht das dann so aus: $arr[4]["gewicht"];
  18.  
  19. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement