agenda.php

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="style.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
  <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
</head>
<body>


</body>
</html>

<?php
	require_once("classes/LoginClass.php");
	require_once("classes/SessionClass.php");

    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "melkweg";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
         die("Connection failed: " . $conn->connect_error);
    }

    $sql = "SELECT * FROM agenda";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
         while($row = $result->fetch_assoc()) {
             echo "
            <div class='container-fluid'>
            <div class='row'>
            <div class='col-sm-2'><img src=".$row["image"]."height='120' width='120';></div>
            <a href='artiest.php?id=".$row["id"]."'>
            <div class='col-sm-5'><h6>".$row["naam"]."</h6>
            <h6>".$row["beschrijving"]."</h6>
            <a href='tickets.php?id=".$row["id"]."' class='btn btn-info' role='button'>Tickets</a></div>
            </a>
        </div>
        </div>";
         }
    } else {
         echo "0 results";
    }

    $conn->close();
?>