require_once "../includes/functions.php"; require_once "../includes/validation-functions.php"; ?> <?php $page = "assign-question.php"; ?> <?php include '../includes/layouts/header.php'; ?> <?php // If question does not exist, redirect back to Manage Questions Page $id = isset($_GET["question_id"]) ? $_GET["question_id"] : ""; $question = get_question_by_id($id); if (!$question) { redirect_to("manage-questions.php"); } ?> <?php if (isset($_POST['submit-assign-question'])) { // The Assign Question Form was submitted $_POST = array_map('mysql_real_escape_string', $_POST); $quiz_name = $_POST['quiz_name']; $query = "SELECT * FROM quiz WHERE quiz_name = '{$quiz_name}' LIMIT 1"; $result = mysqli_query($db, $query); if ($result && mysqli_affected_rows($db) == 1) { $row = mysqli_fetch_assoc($result); $quiz_id = $row["quiz_id"];
<?php require_once "../includes/sessions.php"; require_once "../includes/db-connection.php"; require_once "../includes/functions.php"; ?> <?php $question = get_question_by_id($_GET["question_id"]); if (!$question) { // Question id was missing or invalid or // could not be found in the database. $_SESSION["error_message"] = "Failed to delete question. Question does not exist."; redirect_to("manage-questions.php"); } $id = $question["question_id"]; $query = "DELETE FROM question WHERE question_id = {$id} LIMIT 1"; $result = mysqli_query($db, $query); if ($result && mysqli_affected_rows($db) == 1) { $query2 = "DELETE FROM answer WHERE question_id = {$id}"; $result2 = mysqli_query($db, $query2); if ($result2) { $query3 = "DELETE FROM quiz_has_question WHERE question_id = {$id}"; $result3 = mysqli_query($db, $query3); if ($result3) { // Success $_SESSION["message"] = "Successfully deleted question with id: {$id}."; redirect_to("manage-questions.php"); } } } else {
<a href="manage-quizzes.php" id="cancel-edit-quiz" name="cancel-edit-quiz" class="btn btn-default pull-right margin-right-10">Cancel</a> </form> </div> <div class="table-responsive"> <table class="table table-bordered"> <tbody> <?php $i = 1; while ($row = mysqli_fetch_assoc($linked_questions)) { $current_question = get_question_by_id($row['question_id']); //pr($current_question); ?> <tr><td class="tbp-question-list-header">Question <?php echo $i++; ?> <div style="float:right;"><i class="fa fa-minus"></i> <a href="remove-question.php?quiz_id=<?php echo $quiz["quiz_id"]; ?> &question_id=<?php echo $current_question['question_id']; ?> " onclick="return confirm('Are you sure to remove this question');">Remove from Test</a></div><h4></td></tr> <tr><td><h4 class="tbp-question-list-body"><?php echo $current_question['question_text'];
switch ($request[0]) { case 'questions': if ($requestSize == 1) { exit(get_questions()); } if ($requestSize == 2) { if ($request[1] == "") { // special case. // http://localhost/cardboard-qr-marker-frontend/api.php/questions/ exit(get_questions()); } exit(get_question_by_id($request[1])); } if ($requestSize == 3) { if ($request[2] == "") { exit(get_question_by_id($request[1])); } } handle_error(); case 'qrcodes': exit(get_qrcodes_by_id($request[1], 200)); case 'qrcodesprint': exit(get_qrcodes_by_id($request[1], 400)); case 'particleqrcode': exit(get_particlesystem_qrcode_by_id($request[1], 200)); case 'particleqrcodeprint': exit(get_particlesystem_qrcode_by_id($request[1], 400)); case 'questioncount': exit(get_question_count()); case 'particlesystems': if ($requestSize == 1) {