Untitled

<?php
session_start();
if ( !isset( $_SESSION["id"] )) {
    header("Location: index.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Verander uw planning</title>
<link rel="stylesheet" type="text/css" href="style.css">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" integrity="sha384-WskhaSGFgHYWDcbwN70/dfYBj47jz9qbsMId/iRN3ewGhXQFZCSftd1LZCfmhktB" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js" integrity="sha384-smHYKdLADwkXOn1EmN1qk/HfnUcbVRZyYmZ4qpPea6sjB/pTJ0euyQp0Mk8ck+5T" crossorigin="anonymous"></script>
</head>
<body>
<div class="list">
  <h4 id="titel1">Uw opgeslagen ideeën worden hier beneden weergeven.</h4>
  <?php

  $server = "localhost";
  $db = "wptexamen";
  $username = "root";
  $password = "";

  $conn = new PDO( "mysql:host=$server;dbname=$db", $username, $password );
  $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
//prepares the correct sql/selection from the db
$sql = "SELECT weekplan.id, weekplan.dag, weekplan.oefening, weekplan.user_id FROM weekplan, user WHERE weekplan.id = ? AND user.id = ?";
$stmt = $conn->prepare($sql);
$stmt->bindParam( 1, $_GET["id"] ); //Selected ID from the list of ideas
$stmt->bindParam(2, $_SESSION["id"]); //Current user's ID
$stmt->execute();

$result = $stmt->fetch();//If there is a planning with this ID for this user
function getDayFromNumber( $dayNum ) {
    switch( $dayNum ) {
        case 1:
            return "Maandag";
        case 2:
            return "Dinsdag";
        case 3:
            return "Woensdag";
        case 4:
            return "Donderdag";
        case 5:
            return "Vrijdag";
        case 6:
            return "Zaterdag";
        case 7:
            return "Zondag";

        default:
            return null;
    }
}

  if (isset($result)) {
  echo '
  <form class="" action="saveIdee.php" method="post">
          <div class="form-group">
            <select class="form-control" id="exampleFormControlSelect1" name="dag">
                <option value="1" ' . $result["dag"] == 1 ? 'selected="selected"' : null . '>Maandag</option>
                <option value="2" ' . $result["dag"] == 2 ? 'selected="selected"' : null . '>Dinsdag</option>
                <option value="3" ' . $result["dag"] == 3 ? 'selected="selected"' : null . '>Woensdag</option>
                <option value="4" ' . $result["dag"] == 4 ? 'selected="selected"' : null . '>Donderdag</option>
                <option value="5" ' . $result["dag"] == 5 ? 'selected="selected"' : null . '>Vrijdag</option>
                <option value="6" ' . $result["dag"] == 6 ? 'selected="selected"' : null . '>Zaterdag</option>
                <option value="7" ' . $result["dag"] == 7 ? 'selected="selected"' : null . '>Zondag</option>
            </select>
            <div class="form-group">
                  <label id="titel1" for="idee">Oefeningen</label>
                  <textarea class="form-control" name="idee" id="idee" rows="10">
                  ' . $result["oefening"] . '
              </textarea>
            </div>
            <input type="hidden" name="id" value="' . $result["id"] . '" />
          <input type="submit" class="form-control" value="Sla op" />
      </form>
  ';
}
;
?>
<a href="bekijk.php">Terug naar bekijk planning</a>
<a href="signout.php">Log uit</a>
</div>
</body>
</html>