<?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);