Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = '*****';
- $user = '*****';
- $password = '*******';
- $dbname = '*******';
- $dsn = 'mysql:host='.$host.';dbname='.$dbname;
- $pdo = new PDO($dsn, $user, $password);
- $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
- $pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
- $sql = 'SELECT EAN, NAME FROM Books';
- $stmt = $pdo->prepare($sql);
- $stmt->execute();
- $values[] = array();
- while($row = $stmt->fetch()){
- $values[] = $row;
- }
- encode_json($value);
Add Comment
Please, Sign In to add comment