database

<?php
/**
 * Created by PhpStorm.
 * User: lisav
 * Date: 31/03/2017
 * Time: 15:29
 */

$user = 'root';
$password = 'user';
$database = 'events';
$pdo=null;
$sql = 'SELECT * FROM ' .$database.'.Afspraak';

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

    $statement = $pdo->query($sql);
    $result= $statement->setFetchMode(PDO::FETCH_ASSOC);
    while($row = $statement->fetch()) {
        echo '<pre>';
        print_r($row);
        echo '</pre>';
    }
} catch ( PDOException $e ) {
    print 'Exception!: ' . $e->getMessage();
}
$pdo = null;