Файловый менеджер - Редактировать - /www/wwwroot/gamenworld.store/static/img/logo/question.php.tar
�азад
www/wwwroot/gamenworld.store/admin/question.php 0000755 00000022175 15044542556 0016106 0 ustar 00 <?php require "../app/includes/function_general.php"; ?> <?php $page = "Questions"; require "../app/includes/question_fun.php"; $questionList = questionList(); include "includes/header.php"; ?> <?php $add = $_GET['add'] ?? ''; $edit = $_GET['edit'] ?? ''; if (isset($_POST) && !empty($_POST)) { if (isset($_POST['add_question'])) { $question = $_POST['question']; $correct_option = $_POST['correct_option']; $optionA = $_POST['optionA']; $optionB = $_POST['optionB']; $optionC = $_POST['optionC']; $optionD = $_POST['optionD']; $sql = "INSERT INTO zon_questions (`question`, `correct_option`, `optionA`, `optionB`, `optionC`,`optionD`) VALUES ('$question', '$correct_option', '$optionA', '$optionB', '$optionC','$optionD') "; if (mysqli_query($socket, $sql)) { echo "<script>window.location.href = '?';</script>"; } } } if (isset($_POST) && !empty($_POST)) { if (isset($_POST['update_question'])) { $id = $_GET['token_id']; $question = $_POST['question']; $correct_option = $_POST['correct_option']; $optionA = $_POST['optionA']; $optionB = $_POST['optionB']; $optionC = $_POST['optionC']; $optionD = $_POST['optionD']; mysqli_query($con, "SET GLOBAL max_allowed_packet=1073741824"); $sql = "UPDATE zon_questions SET `question`='$question', `correct_option`='$correct_option', `optionA`='$optionA', `optionB`='$optionB',`optionC`='$optionC',`optionD`='$optionD' WHERE id=$id "; if (mysqli_query($socket, $sql)) { echo "<script>window.location.href = '?';</script>"; } } } if (isset($_GET) && !empty($_GET)) { if (isset($_GET['action']) && isset($_GET['token_id'])) { if ($_GET['action'] == 'delete') { $id = $_GET['token_id']; if (mysqli_query($socket, "DELETE FROM zon_questions WHERE id=$id")) { echo "<script>window.location.href = '?';</script>"; } } } } function getBlogDataById($id) { global $socket; $sql = mysqli_query($socket, "SELECT * FROM zon_questions WHERE id=$id"); $data = mysqli_fetch_assoc($sql); return $data; } $data = []; if (isset($_GET) && isset($_GET['edit']) && isset($_GET['token_id'])) { $data = getBlogDataById($_GET['token_id']); } ?> <body> <main class="d-flex"> <?php include "includes/sidebar.php"; ?> <div class="main w-full px-12 py-6"> <?php if ($add == 'true' || $edit == 'true') { ?> <div class="games-list mt-6"> <form action="" method="post" id="add-page" enctype="multipart/form-data" class="tab"> <div class="input-group flex flex-column"> <label class="text-gray-500 uppercase text-[10px] mb-2">Question</label> <input value="<?php echo $edit == 'true' ? $data['question'] : '' ?>" required name="question" class="py-[15px] text-gray-500 outline-none focus:outline focus:outline-blue-500 transition-sm px-3 text-xs" type="text" placeholder="Blog title"> </div> <div class="input-group flex flex-column mt-6"> <label class="text-gray-500 uppercase text-[10px] mb-2">Correct Option</label> <input value="<?php echo $edit == 'true' ? $data['correct_option'] : '' ?>" required name="correct_option" class="py-[15px] text-gray-500 outline-none focus:outline focus:outline-blue-500 transition-sm px-3 text-xs" type="text" placeholder="Blog Description"> </div> <div class="input-group flex flex-column mt-6"> <label class="text-gray-500 uppercase text-[10px] mb-2">optionA</label> <input value="<?php echo $edit == 'true' ? $data['optionA'] : '' ?>" required name="optionA" class="py-[15px] text-gray-500 outline-none focus:outline focus:outline-blue-500 transition-sm px-3 text-xs" type="text" placeholder="Blog Description"> </div> <div class="input-group flex flex-column mt-6"> <label class="text-gray-500 uppercase text-[10px] mb-2">optionB</label> <input value="<?php echo $edit == 'true' ? $data['optionB'] : '' ?>" required name="optionB" class="py-[15px] text-gray-500 outline-none focus:outline focus:outline-blue-500 transition-sm px-3 text-xs" type="text" placeholder="Blog Description"> </div> <div class="input-group flex flex-column mt-6"> <label class="text-gray-500 uppercase text-[10px] mb-2">optionC</label> <input value="<?php echo $edit == 'true' ? $data['optionC'] : '' ?>" required name="optionC" class="py-[15px] text-gray-500 outline-none focus:outline focus:outline-blue-500 transition-sm px-3 text-xs" type="text" placeholder="Blog Description"> </div> <div class="input-group flex flex-column mt-6"> <label class="text-gray-500 uppercase text-[10px] mb-2">optionD</label> <input value="<?php echo $edit == 'true' ? $data['optionD'] : '' ?>" required name="optionD" class="py-[15px] text-gray-500 outline-none focus:outline focus:outline-blue-500 transition-sm px-3 text-xs" type="text" placeholder="Blog Description"> </div> <button name="<?php echo $edit == 'true' ? 'update_question' : 'add_question' ?>" class="bg-blue-600 text-white uppercase mt-4 text-sm rounded-sm py-2 px-3 "> <?php echo $edit == 'true' ? 'Update Questions' : 'Add Questions' ?> </button> </form> </div> <?php } else { ?> <div class="games-list"> <a href="?add=true" class="py-2 px-6 bg-blue-400 text-white uppercase text-xs rounded-md">ADD</a> <table class="w-full mt-10 "> <thead class="border-b-2 dark:border-zinc-900 px-16 border-gray-100 py-2"> <td class=" text-gray-400 py-2 text-xs px-6">#Id</td> <td class=" text-gray-400 py-2 text-xs px-6 w-full">Question</td> <td class=" text-gray-400 py-2 text-xs px-6 w-full">correctOption</td> <td class=" text-gray-400 py-2 text-xs text-right px-6">Action</td> </thead> <tbody class="py-4"> <?php $run = mysqli_query($con, 'select * from zon_questions') ?> <?php while ($row = mysqli_fetch_assoc($run)) { ?> <tr class="bg-[white] dark:bg-zinc-900 px-16 py-4 rounded-lg"> <td class="text-xs px-6 text-gray-500"> <?= $row['id'] ?> </td> <td class="text-gray-500 text-xs px-6 py-4"><a href="?edit=true&token_id=<?= $row['id'] ?>"> <?= $row['question'] ?> </a></td> <td class="text-gray-500 whitespace-nowrap text-xs px-6 py-4"> <?= $row['correct_option'] ?> </td> <td class="text-right relative px-6"> <button data-target="#dc_<?= $row['id'] ?>" class="bi-three-dots-vertical text-gray-500 drop_btn"></button> <div id="dc_<?= $row['id'] ?>" style="z-index: 99;" class="dropdown absolute bg-white text-right right-0 hidden flex-column "> <a href="?action=delete&token_id=<?= $row['id'] ?>" class="text-xs px-4 py-2 text-red-700">Delete</a> <a href="?edit=true&token_id=<?= $row['id'] ?>" class="text-xs px-4 py-2">Edit</a> </div> </td> </tr> <?php } ?> </tbody> </table> </div> <?php } ?> </div> </main> <script> var editor1 = new RichTextEditor("#editor"); </script> <?php include "includes/footer.php"; ?> </body> </html>