<?php
/**
 * Created by PhpStorm.
 * User: admin
 * Date: 13/06/2017
 * Time: 13:52
 */

$xml = simplexml_load_file("configDatabank.xml");// or die("Error: Cannot create xml object");

$user = $xml->Login->Username->__toString();
$password = $xml->Login->Password->__toString();
$database = $xml->Login->DatabaseName->__toString();

$hostname = $xml->Login->Hostname->__toString();

$pdo = null;

try {
    $pdo = new PDO("mysql:host=$hostname;dbname=$database",
        $user, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE,
        PDO::ERRMODE_EXCEPTION);


    $statement = $pdo->prepare('SELECT bescrijving FROM beschrijving WHERE id=1');
    $statement->execute();
    $results = $statement->fetchAll(PDO::FETCH_ASSOC);
    $json = json_encode($results);
    echo $json;




} catch (PDOException $ex){

}