questionnaire.php

<?php
  //Start the session
  require_once('templates/startsession.php');

  //Insert the page header
  $page_title='Questionnaire';
  require_once('templates/header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Make sure the user is logged in
  if(!isset($_SESSION['user_id'])){
    echo '<p class="login">Please <a href="login.php">log in</a> to access this page.</p>';
    exit();
  }

  // Show the nav menu
  require_once('templates/navmenu.php');

  // Connect to the db
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  // If the user has never answered the questionnaire, insert empty responses
  $query = "SELECT * FROM mismatch_response WHERE user_id='" . $_SESSION['user_id'] ."'";
  $data = mysqli_query($dbc, $query);
  if(mysqli_num_rows($data) == 0){
    // Grab the topics from topic table
    $query = "SELECT topic_id FROM mismatch_topic ORDER BY category_id, topic_id";
    $data = mysqli_query($dbc, $query);
    $topicIds = array();
    while($row = mysqli_fetch_array($data)){
      array_push($topicIds, $row['topic_id']);
    }

    // Insert empty response rows into the response table, one per topic
    foreach($topicIds as $topic_id){
      $query = "INSERT INTO mismatch_response (user_id, topic_id) VALUES ('" . $_SESSION['user_id'] . "', '$topic_id')";
      mysqli_query($dbc, $query);
    }
  }

  // If the questionnaire form has been submitted, write the form responses to the databse
  if(isset($_POST['submit'])){
    // Write the questionnaire response rows to the response table
    foreach($_POST as $response_id => $response){
      $query = "UPDATE mismatch_response SET response = '$response' WHERE response_id = '$response_id'";
      mysqli_query($dbc, $query);
    }
    echo '<p>Your response have been saved.</p>';
  }

  // Grab the response data from the database to generate the form
  $query = "SELECT mr.response_id, mr.topic_id, mr.response, mt.name AS topic_name, mc.name AS category_name " .
    "FROM mismatch_response AS mr " .
    "INNER JOIN mismatch_topic AS mt USING (topic_id) " .
    "INNER JOIN mismatch_category AS mc USING (category_id) " .
    "WHERE mr.user_id = '" . $_SESSION['user_id'] . "'";
  $data = mysqli_query($dbc, $query);
  $responses = array();
  while ($row = mysqli_fetch_array($data)) {
    array_push($responses, $row);
  }

  mysqli_close($dbc);

  // Generate the form by looping through the response array
  echo '<form method="post" action="' . $_SERVER['PHP_SELF']. '">';
  echo '<p> How do you feel about each topic?</p>';
  $category = $responses[0]['category_name'];
  echo "<fieldset><legend>$category</legend>";
  foreach ($responses as $response) {
    // Only start a new fieldset if the category has changed
    if($category != $response['category_name']){
      $category = $response['category_name'];
      echo "</fieldset><fieldset><legend>$category</legend>";
    }

    // Display the topic form field
    echo '<label ' . ($response['response'] == 0 ? 'class="error"' : '') .
      ' for="' . $response['response_id'] . '">' . $response['topic_name'] . ':</label>';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' .
      $response['response_id'] . '" value="1" ' .
      ($response['response'] == 1 ? 'checked="checked"' : '') . ' />Love ';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' .
      $response['response_id'] . '" value="2" ' .
      ($response['response'] == 2 ? 'checked="checked"' : '') . ' />Hate<br />';
  }
  echo '</fieldset>';
  echo '<input type="submit" value="Save" name="submit" />';
  echo '</form>';

  //Insert the page footer
  require_once('templates/footer.php');
?>