File "question_edit_wes.php"
Full Path: /home/ccipcixf/public_html/hirepro/assets/extra-libs/datatables.net/js/question_edit_wes.php
File size: 7.3 KB
MIME-type: text/x-php
Charset: utf-8
<?php
session_start();
// Check if the user is not an Admin, redirect them to index.php
if (!isset($_SESSION["admin_role"]) || $_SESSION["admin_role"] !== "Admin") {
echo '<script type="text/javascript">window.location.href = "index.php";</script>';
exit();
}
include "menu.php";
include "config.php";
// Check if the question ID is provided in the URL
if (isset($_GET['id'])) {
$question_id = mysqli_real_escape_string($conn, $_GET['id']);
// Fetch the question details from the database
$sql = "SELECT * FROM `questions_wes` WHERE `question_id` = $question_id";
$result = mysqli_query($conn, $sql);
if ($result) {
$question = mysqli_fetch_assoc($result);
} else {
echo "Error: " . mysqli_error($conn);
}
} else {
// Redirect to the questions page if no ID is provided
echo '<script type="text/javascript">window.location.href = "show_junior_questions.php";</script>';
exit();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- Your head content here -->
</head>
<body>
<?php if ($_SESSION["admin_role"] || $_SESSION["admin_role"] == "Admin") : ?>
<div class="container mt-2">
<div class="page-breadcrumb">
<div class="row">
<a href="show_wes.php">
<button class="btn btn-primary float-end mt-3" style="background: linear-gradient(#0052D4, #2B32B2 );">
Show Questions
</button>
</a>
<h4 class="fw-bold py-1">
<span class="text-muted fw-light">Edit Work Engagement Survey Question</span>
</h4>
<form method="POST" action="update_question.php" class="col-12 mt-4">
<input type="hidden" name="question_id" value="<?php echo $question['question_id']; ?>">
<div class="form-group">
<label for="junior_level" class="fw-bold">Work Engagement Survey</label>
<select class="form-control" id="junior_level" name="junior_level">
<option value="Work Engagement Survey" <?php if ($question['question_level'] == 'Work Engagement Survey') echo 'selected'; ?>>Work Engagement Survey</option>
</select>
</div>
<div class="form-group mt-2">
<label for="competency" class="fw-bold">Competency</label>
<select class="form-control" id="competency" name="competency">
<option disabled>Select Competency</option>
<option value="Vigor" <?php if ($question['competency'] == 'Vigor') echo 'selected'; ?>>Vigor</option>
<option value="Dedication" <?php if ($question['competency'] == 'Dedication') echo 'selected'; ?>>Dedication</option>
<option value="Absorption" <?php if ($question['competency'] == 'Absorption') echo 'selected'; ?>>Absorption</option>
<!-- Add more options based on your requirements -->
</select>
</div>
<div class="form-group mt-2 ">
<label for="question_eng" class="fw-bold">English Question</label>
<input type="text" class="form-control" id="question_eng" name="question_eng" value="<?php echo $question['question_eng']; ?>">
</div>
<div class="form-group mt-2">
<label for="question_ur" class="fw-bold">Urdu Question</label>
<input type="text" class="form-control" id="question_ur" name="question_ur" value="<?php echo $question['question_ur']; ?>">
</div>
<?php for ($i = 1; $i <= 7; $i++) : ?>
<div class="row">
<div class="col-md-10">
<div class="form-group mt-2">
<label for="answer_<?php echo $i; ?>_eng" class="fw-bold">English Answer <?php echo $i; ?></label>
<input type="text" class="form-control" id="answer_<?php echo $i; ?>_eng" name="answer_<?php echo $i; ?>_eng" value="<?php echo isset($question["answer_{$i}_eng"]) ? $question["answer_{$i}_eng"] : ''; ?>">
</div>
</div>
<div class="col-md-2">
<div class="form-group mt-2">
<label for="rating_<?php echo $i; ?>" class="fw-bold">Rating <?php echo $i; ?></label>
<input type="text" class="form-control" id="rating_<?php echo $i; ?>" name="rating_<?php echo $i; ?>" value="<?php echo isset($question["rating_{$i}"]) ? $question["rating_{$i}"] : ''; ?>">
</div>
</div>
</div>
<div class="row">
<div class="col-md-10">
<div class="form-group mt-2">
<label for="answer_<?php echo $i; ?>_ur" class="fw-bold">Urdu Answer <?php echo $i; ?></label>
<input type="text" class="form-control" id="answer_<?php echo $i; ?>_ur" name="answer_<?php echo $i; ?>_ur" value="<?php echo isset($question["answer_{$i}_ur"]) ? $question["answer_{$i}_ur"] : ''; ?>">
</div>
</div>
</div>
<?php endfor; ?>
<button name="update_question_submit" type="submit" class="btn btn-primary mt-3">Update Question</button>
</form>
</div>
</div>
</div>
<?php endif; ?>
<!-- Your HTML content here -->
</body>
</html>