"Add a new topic to your own mismatch_topic table with this SQL statement:
INSERT INTO mismatch_topic
(name, category) VALUES
('Virtual guitars', 'Activities')
3 View the questionnaire in the Mismatch application to see the new topic.
4 Respond to the new topic, submit the form, and check out your saved response.
2 Empty all the data from the mismatch_response table with this SQL statement:
DELETE FROM mismatch_response"
this is my code.
<?php
// Start the session
require_once('startsession.php');
// Insert the page header
$page_title = 'Questionnaire';
require_once('header.php');
require_once('appvars.php');
require_once('connectvars.php');
// Make sure the user is logged in before going any further.
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 navigation menu
require_once('navmenu.php');
//connect to database
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
//If this user has never answered the questionnaire, insert empty responses into the database
$query = "SELECT * FROM mismatch_response WHERE user_id = '" . $_SESSION['user_id'] . "'";
$data = mysqli_query($dbc, $query);
if (mysqli_num_rows($data) == 0) {
//First grab the list of topix IDs from the topic table
$query = "SELECT topic_id FROM mismatch_topic ORDER BY category, 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 from has been submitted, write the form responses to the database
if (isset($_POST['submit'])) {
//write the questionnaire response 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 responses have been saved.</p>';
}
// Grab the response data from the database to generate the form
$query = "SELECT response_id, topic_id, response FROM mismatch_response WHERE user_id = '" .
$_SESSION['user_id'] . "'";
$data = mysqli_query($dbc, $query);
$responses = array();
while ($row = mysqli_fetch_array($data)) {
// Look up the topic name for the response from the topic table
$query2 = "SELECT name, category FROM mismatch_topic WHERE topic_id = '" . $row['topic_id'] . "'";
$data2 = mysqli_query($dbc, $query2);
if (mysqli_num_rows($data2) == 1) {
$row2 = mysqli_fetch_array($data2);
$row['topic_name'] = $row2['name'];
$row['category_name'] = $row2['category'];
array_push($responses, $row);
}
}
mysqli_close($dbc);
//Generate the questionnaire 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>' . $responses[0]['category_name'] . '</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>' . $response['category_name'] . '</legend>';
}
//Display the topic form field
echo '<label ' . ($response['response'] == NULL ? '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 Questionnare" name="submit" />';
echo '</form>';
// Insert the page footer
require_once('footer.php');
?>
