<?php
/**
 * Created by PhpStorm.
 * User: Karl
 * Date: 9/03/2016
 * Time: 14:03
 */


$user = 'student';
$password = 'student123';
$pdo = null;
try {

    // connectie maken met databank noelvaes
    $pdo = new PDO('mysql:host=noelvaes.eu;dbname=StudentDB', $user, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $pdo->query('SELECT Name from Beers');
    $stmt->setFetchMode(PDO::FETCH_ASSOC);
    if ($stmt->rowCount() > 0) {
        $columnNames = array();
        for ($i = 0; $i < $stmt->columnCount(); $i++) {
            $col = $stmt->getColumnMeta($i);
            $columnNames[] = $col['name'];
        }

        print("<table>");
        print('<tr><th>' . implode('</th><th>', $columnNames) .
            '</th></tr>');

        while ($row = $stmt->fetch()) {
            print('<tr><td>' . implode('</td><td>', $row) .
                '</td></tr>');
        }
        print("</table>");
    }

} catch (PDOException $e) {
    print 'Exception!: ' . $e->getMessage();
}
// connectie sluiten
$pdo = null;