Guest User

Untitled

a guest
Feb 28th, 2019
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. <?php
  2.  
  3. $host = '*****';
  4. $user = '*****';
  5. $password = '*******';
  6. $dbname = '*******';
  7.  
  8. $dsn = 'mysql:host='.$host.';dbname='.$dbname;
  9. $pdo = new PDO($dsn, $user, $password);
  10. $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
  11. $pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
  12.  
  13. $sql = 'SELECT EAN, NAME FROM Books';
  14. $stmt = $pdo->prepare($sql);
  15. $stmt->execute();
  16.  
  17.  
  18. $values[] = array();
  19. while($row = $stmt->fetch()){
  20. $values[] = $row;
  21. }
  22.  
  23. encode_json($value);
Add Comment
Please, Sign In to add comment