File: /var/www/content-sp/work-sp/nqb_delete_all_single_question.php
<?php
include_once 'config.php';
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
date_default_timezone_set('Asia/Kolkata');
$curDate = date('Y-m-d H:i:s');
global $wpdb;
session_start();
$mType = 'sp';
include 'str_replace_type.php';
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';
if (!empty($_SESSION['editor'])) {
//current user
$editorData = json_decode($_SESSION['editor']);
$user_id = $editorData->eId;
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_DELETE_QUESTION_HISTORY = 'csp_sp_delete_question_history';
$question_id = '';
if (isset($_REQUEST['clicktosearch'])) {
$questioNo = $_REQUEST['question_no'];
if (is_numeric($questioNo) && $questioNo != '') {
$quesfetch = $conn->query("SELECT `question_id`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `correct_answer`, `question_hint`, `question_solution` FROM $SP_QUESTION WHERE `question_id`='$questioNo'");
$q = $quesfetch->fetch_assoc();
$question_id = $q['question_id'];
$instruction = str_replace('../', $root_link, $q['question_instruction']);
$instruction = str_replace($spaceArray, $replaceSpaceArray, $instruction);
$question = str_replace('../', $root_link, $q['question_statement']);
$question = str_replace($spaceArray, $replaceSpaceArray, $question);
$option1 = str_replace('../', $root_link, $q['option_1']);
$option1 = str_replace($spaceArray, $replaceSpaceArray, $option1);
$option2 = str_replace('../', $root_link, $q['option_2']);
$option2 = str_replace($spaceArray, $replaceSpaceArray, $option2);
if ($q['option_3']) {
$option3 = str_replace('../', $root_link, $q['option_3']);
$option3 = str_replace($spaceArray, $replaceSpaceArray, $option3);
} else {
$option3 = "";
}
if ($q['option_4']) {
$option4 = str_replace('../', $root_link, $q['option_4']);
$option4 = str_replace($spaceArray, $replaceSpaceArray, $option4);
} else {
$option4 = "";
}
if ($q['option_5']) {
$option5 = str_replace('../', $root_link, $q['option_5']);
$option5 = str_replace($spaceArray, $replaceSpaceArray, $option5);
} else {
$option5 = "";
}
$correct_answer = $q['correct_answer'];
$solution = str_replace('../', $root_link, $q['question_solution']);
$solution = str_replace($spaceArray, $replaceSpaceArray, $solution);
//medium
$mediumQuery = $conn->query("SELECT id, question_instruction, question_statement, medium_id, option_1, option_2, option_3, option_4, option_5, question_hint, question_solution FROM $SP_QUESTION_MEDIUM_WISE WHERE question_id='$question_id'");
}
}
//delete all
if (isset($_POST['deleteall'])) {
$ques = $_REQUEST['question'];
if (is_numeric($ques) && $ques != '') {
//save question
$question_details = array();
$makearray = $conn->query("SELECT * FROM $SP_QUESTION_MEDIUM_WISE WHERE question_id='$ques'");
foreach ($makearray as $queshistory) {
$secondID = $queshistory['id'];
$question_details[] = $queshistory;
}
$json_question_details = json_encode($question_details);
$historyQry = $conn->query("INSERT INTO $SP_DELETE_QUESTION_HISTORY SET `question_id`='$ques',`secondary_id`='$secondID',`question_history`='$json_question_details',`deleted_by`='$user_id',`deleted_at`='$curDate'");
if ($historyQry) {
$conn->query("DELETE FROM $SP_QUESTION_MEDIUM_WISE WHERE question_id='$ques'");
}
//save question
$question_master_details = array();
$makemasterarray = $conn->query("SELECT * FROM $SP_QUESTION WHERE `question_id`='$ques'");
foreach ($makemasterarray as $masterhistory) {
$question_master_details[] = $masterhistory;
}
$json_question_master_details = json_encode($question_master_details);
$masterhistoryQry = $conn->query("INSERT INTO $SP_DELETE_QUESTION_HISTORY SET `question_id`='$ques',`secondary_id`='0',`question_history`='$json_question_master_details',`deleted_by`='$user_id',`deleted_at`='$curDate'");
$conn->query("DELETE FROM $SP_QUESTION WHERE question_id='$ques'");
}
}
//deletesingle
if (isset($_POST['deletesingle'])) {
$masterques = $_REQUEST['masterquestion'];
$sub_ques = $_REQUEST['subquestion'];
if (is_numeric($sub_ques) && $sub_ques != '') {
$sub_question_details = array();
$subquestionarray = $conn->query("SELECT * FROM $SP_QUESTION_MEDIUM_WISE WHERE `id`='$sub_ques'");
foreach ($subquestionarray as $subhistory) {
$sub_question_details[] = $subhistory;
}
$json_sub_question_details = json_encode($sub_question_details);
$masterhistoryQry = $conn->query("INSERT INTO $SP_DELETE_QUESTION_HISTORY SET `question_id`='$masterques',`secondary_id`='$sub_ques',`question_history`='$json_sub_question_details',`deleted_by`='$user_id',`deleted_at`='$curDate'");
if ($masterhistoryQry) {
$conn->query("DELETE FROM $SP_QUESTION_MEDIUM_WISE WHERE id='$sub_ques'");
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Delete Question's</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"></script>
<style>
html,
body {
overflow-x: hidden;
}
body {
padding-top: 20px;
}
.text-white-50 {
color: rgba(255, 255, 255, .5);
}
.bg-purple {
background-color: #6f42c1;
}
.form-check {
display: block;
min-height: 1.5rem;
padding-left: 0;
margin-bottom: 1.125rem;
}
.show-answer {
padding: 10px 15px;
background-color: #f5f5f5;
border-top: 1px solid #ddd;
border-bottom-right-radius: 3px;
border-bottom-left-radius: 3px;
}
/* panel */
.panel {
box-shadow: -1px 0px 10px 1px rgb(203 198 198 / 55%);
border: 1px #0a0a0a !important;
margin-bottom: 25px;
margin-top: 19px;
border-radius: 15px;
background-color: #fff;
}
.panel .panel-heading {
padding: 12px 12px 12px 12px;
overflow: hidden;
border-top-left-radius: 0;
border-top-right-radius: 0;
border: 0 !important;
height: 40px;
font-size: 14px;
font-weight: 600;
}
.panel .panel-heading+.panel-body {
padding: 0 20px 20px 20px;
}
.panel .panel-body {
position: relative;
padding: 0px 15px 0px 15px;
border-bottom-left-radius: 0;
border-bottom-right-radius: 0;
}
.deletequestion {
margin-top: -78px;
border-radius: 0px 12px 0px 0px;
font-weight: 500;
padding: 4px 6px 3px;
text-decoration: none;
background: #7d7d7d;
border: 3px solid #fff;
color: #FFF !important;
box-shadow: 0 2px 6px rgba(0, 0, 0, 0.5), inset 0 2px 4px rgba(0, 0, 0, 0.3);
}
.deletequestion:hover {
background: #dc3545;
color: #FFF !important;
border: 3px solid #fff;
padding: 3px 7px 5px;
top: -11px;
right: -11px;
}
/* end panel */
.hindiquestionDiv {
background: aliceblue !important;
box-shadow: 0px 0px 5px 0px rgb(97 97 97 / 19%) !important;
}
</style>
</head>
<body class="bg-light">
<main class="container">
<div class="d-flex align-items-center p-2 my-3 text-white bg-purple rounded shadow-sm">
<div class="row">
<div class="my-2">
<h1 class="h6 mb-0 text-white lh-1">Question Verify And Delete</h1>
</div>
<div class="col-md-12">
<div class="col-md-9">
<form method="post">
<div class="input-group">
<input type="text" name="question_no" class="form-control" placeholder="Enter Question No" value="<?php if (isset($_REQUEST['question_no'])) {
echo $_REQUEST['question_no'];
} ?>" required autocomplete="off">
<button type="submit" class="btn btn-secondary" name="clicktosearch">CLICK TO SEARCH</button>
</div>
</form>
</div>
</div>
</div>
</div>
<div class="my-3 p-3 bg-body rounded shadow-sm">
<div class="border-bottom pb-2 mb-0 row">
Result Of Question No :- <?php if (isset($_REQUEST['question_no'])) {
echo $_REQUEST['question_no'];
} ?>
</div>
<?php if (is_numeric($question_id) && $question_id != '') { ?>
<!-- Row -->
<div class="row">
<div class="col-md-6">
<div class="panel">
<div class="panel-heading">Question Instructions </div>
<div class="ms-auto" style="text-align: end;">
<form method="post" onsubmit="return confirm('Do you really want to delete all question of question no - <?php echo $question_id; ?> ?');">
<input type="hidden" name="question" value="<?php echo $question_id; ?>">
<button type="submit" name="deleteall" class="btn btn-sm deletequestion">Delete All</button>
</form>
</div>
<hr>
<div class="panel-body ques-maindiv">
<div class="form-check" style="padding-left: 0;">
<label>Question No -<strong><?php echo $question_id; ?></strong></label>
</div>
<?php if ($instruction != '') { ?>
<div>
<p><?php echo $instruction; ?></strong> </p>
</div>
<hr>
<?php } ?>
<div class="m-t-sm" style="font-weight: 600;">
<p><?php echo $question; ?></p>
</div>
<div class="optiondiv">
<?php if (isset($option1)) { ?>
<div class="row">
<div class="col-md-1">1</div>
<div class="col-md-1">
<input class="radio_ans" type="radio" value="1" <?php if ($correct_answer == 1) {
echo "checked='checked'";
} ?> />
</div>
<div class="col-md-9">
<?php if (isset($option1)) {
echo $option1;
} ?>
</div>
</div>
<?php } ?>
<?php if (isset($option2)) { ?>
<div class="row">
<div class="col-md-1">2</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="2" <?php if ($correct_answer == 2) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($option2)) {
echo $option2;
} ?>
</div>
</div>
<?php } ?>
<?php if ($option3 != '') { ?>
<div class="row">
<div class="col-md-1">3</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="3" <?php if ($correct_answer == 3) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($option3)) {
echo $option3;
} ?>
</div>
</div>
<?php } ?>
<?php if ($option4 != '') { ?>
<div class="row">
<div class="col-md-1">4</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="4" <?php if ($correct_answer == 4) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($option4)) {
echo $option4;
} ?>
</div>
</div>
<?php } ?>
<?php if ($option5 != '') { ?>
<div class="row">
<div class="col-md-1">5</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="5" <?php if ($correct_answer == 5) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($option5)) {
echo $option5;
} ?>
</div>
</div>
<?php } ?>
</div>
</div>
<?php if ($solution != '') { ?>
<div class="show-answer"><?php echo $solution; ?></div>
<?php } ?>
</div>
</div>
<div class="col-md-6">
<?php foreach ($mediumQuery as $mediumwise) {
$mquestion_id = $mediumwise['id'];
$mmedium_id = $mediumwise['medium_id'];
$minstruction = str_replace('../', $root_link, $mediumwise['question_instruction']);
$minstruction = str_replace($spaceArray, $replaceSpaceArray, $minstruction);
$mquestion = str_replace('../', $root_link, $mediumwise['question_statement']);
$mquestion = str_replace($spaceArray, $replaceSpaceArray, $mquestion);
$msolution = str_replace('../', $root_link, $mediumwise['question_solution']);
$msolution = str_replace($spaceArray, $replaceSpaceArray, $msolution);
$moption1 = str_replace('../', $root_link, $mediumwise['option_1']);
$moption1 = str_replace('../', $root_link, $mediumwise['option_2']);
$moption2 = str_replace($spaceArray, $replaceSpaceArray, $moption1);
$moption2 = str_replace($spaceArray, $replaceSpaceArray, $moption2);
// get question proof reading status
if ($mediumwise['option_3']) {
$moption3 = str_replace('../', $root_link, $mediumwise['option_3']);
$moption3 = str_replace($spaceArray, $replaceSpaceArray, $moption3);
} else {
$moption3 = "";
}
if ($mediumwise['option_4']) {
$moption4 = str_replace('../', $root_link, $mediumwise['option_4']);
$moption4 = str_replace($spaceArray, $replaceSpaceArray, $moption4);
} else {
$moption4 = "";
}
if ($mediumwise['option_5']) {
$moption5 = str_replace('../', $root_link, $mediumwise['option_5']);
$moption5 = str_replace($spaceArray, $replaceSpaceArray, $moption5);
} else {
$moption5 = "";
}
?>
<!-- Multiple -->
<div class="panel hindiquestionDiv">
<div class="panel-heading">Question Instructions</div>
<div class="ms-auto" style="text-align: end;">
<form method="post" onsubmit="return confirm('Do you really want to delete this question?');">
<input type="hidden" name="subquestion" value="<?php echo $mquestion_id; ?>">
<input type="hidden" name="masterquestion" value="<?php echo $question_id; ?>">
<button type="submit" name="deletesingle" class="btn btn-sm deletequestion">Delete</button>
</form>
</div>
<hr>
<div class="panel-body">
<div>
<div class="form-check" style="padding-left: 0;">
<label>Question No -<strong><?php echo $mquestion_id . ' [' . $question_id . ']' .' ['.$mmedium_id.']'; ?></strong></label>
</div>
<?php if ($minstruction != '') { ?>
<div>
<p><?php echo $minstruction; ?></strong> </p>
</div>
<hr>
<?php } ?>
<div class="m-t-sm" style="font-weight: 600;"><?php echo $mquestion; ?></div>
</div>
<div class="optiondiv">
<?php if (isset($moption1)) { ?>
<div class="row">
<div class="col-md-1">1</div>
<div class="col-md-1">
<input class="radio_ans" type="radio" value="1" <?php if ($correct_answer == 1) {
echo "checked='checked'";
} ?> />
</div>
<div class="col-md-9">
<?php if (isset($moption1)) {
echo $moption1;
} ?>
</div>
</div>
<?php } ?>
<?php if (isset($moption2)) { ?>
<div class="row">
<div class="col-md-1">2</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="2" <?php if ($correct_answer == 2) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($moption2)) {
echo $moption2;
} ?>
</div>
</div>
<?php } ?>
<?php if ($moption3 != '') { ?>
<div class="row">
<div class="col-md-1">3</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="3" <?php if ($correct_answer == 3) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($moption3)) {
echo $moption3;
} ?>
</div>
</div>
<?php } ?>
<?php if ($moption4 != '') { ?>
<div class="row">
<div class="col-md-1">4</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="4" <?php if ($correct_answer == 4) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($moption4)) {
echo $moption4;
} ?>
</div>
</div>
<?php } ?>
<?php if ($moption5 != '') { ?>
<div class="row">
<div class="col-md-1">5</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="5" <?php if ($correct_answer == 5) {
echo "checked='checked'";
} ?> /></div>
<div class="col-md-9">
<?php if (isset($moption5)) {
echo $moption5;
} ?>
</div>
</div>
<?php } ?>
</div>
</div>
<?php if ($msolution != '') { ?>
<div class="show-answer"><?php echo $msolution; ?></div>
<?php } ?>
</div>
<?php } ?>
</div>
<!-- Multiple -->
</div><!-- row -->
<?php } ?>
</div>
</main>
</body>
</html>
<?php } else {
echo 'login first';
} ?>