Advertisement
Guest User

Untitled

a guest
May 31st, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. <?php
  2. header('Content-Type: application/json');
  3. $host = "localhost";
  4. $dbname = "portfoliowebsite";
  5. $user = "root";
  6. $password = "";
  7. $dbh = new PDO ("mysql:host=$host;dbname=$dbname", $user, $password);
  8. $sql = "SELECT naam , korteOmschrijving, langeOmschrijving FROM project";
  9. $result = $dbh->query($sql);
  10. while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
  11.  
  12. $data[]['naam'] = $row['naam'];
  13. $data[]['kort']= $row['korteOmschrijving'];
  14. $data[]['lang'] = $row['langeOmschrijving'];
  15.  
  16. }
  17. $data = array_merge($naam, $kort, $lang);
  18. console.log($data[0]['naam'])
  19. echo json_encode($data);
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement