<?php require_once "../includes/dbconnection.php"; require_once "../includes/all_functions.php"; if (isset($_POST['submit'])) { $domain_id = $_POST['topicId']; $question_name = $_POST['questionName']; $questiont_type = $_POST['questionType']; $question_desc = $_POST['questionDesc']; $question_ans = $_POST['questionAns']; $domainID = select_Domain_id($domain_id); $question_ans = ltrim($question_ans, ","); $answeroption = ""; foreach ($_POST['option'] as $key => $value) { $answeroption .= $value . ","; } $answeroption = substr($answeroption, 0, -2); if (isset($domainID)) { while ($row = $domainID->fetch_assoc()) { $temp = $row["Topic_id"]; } $stmt = $connection->prepare("call addQuestion(?,?,?,?,?,?,?)"); $stmt->bind_param('sssssis', $question_name, $questiont_type, $answeroption, $question_ans, $question_desc, $temp, $domain_id); $result = $stmt->execute(); if ($result) { echo "Success"; redirect_to("addProblem.php"); } else { die("Database connection fail" . $connection->connect_errno . " " . $temp); } }
if (isset($_POST['Agree']) && isset($_SESSION["email"])) { //echo $_SESSION["email"]; $cn = $_SESSION["CName"]; $todayDate = date("Y-m-d"); //$todayDate=date("2016-04-13"); $em = $_SESSION["email"]; $tn = $cn . $todayDate; $result25 = checkFormultipleattemp($em, $tn); //while ($row25=$result25->fetch_assoc()) $row25 = $result25->fetch_assoc(); if (!isset($row25['SerialNo'])) { $result3 = CountVisibleQuestion($_SESSION["CName"], $todayDate); while ($row1 = $result3->fetch_assoc()) { $visi = (int) $row1['Visible']; } $result = select_Domain_id($_SESSION["CName"]); $id = ""; $time = ""; while ($row = $result->fetch_assoc()) { $id = $row["Topic_id"]; } $result4 = SelectExamDateTime($_SESSION["CName"] . $todayDate, $_SESSION["email"]); while ($row2 = $result4->fetch_assoc()) { $examDate = $row2['SerialNo']; } if ($visi !== 0) { if (isset($examDate)) { $result2 = SelectExamTime($id); while ($row = $result2->fetch_assoc()) { $time = $row["Time"]; }
function selectDate($cname) { global $connection; date_default_timezone_set('Asia/Kolkata'); $todayDate = date("Y-m-d"); $result1 = select_Domain_id($cname); while ($row = $result1->fetch_assoc()) { $id = $row['Topic_id']; } // $stmt=$connection->prepare("call selectDate(?)"); // $stmt->bind_param('i',$id); // $stmt->execute(); // $result=$stmt->get_result(); $query = "select Exam_Date from exam_details where Topic_id='{$id}' and Exam_Date >= '{$todayDate}' ORDER BY Exam_Date ASC"; $result = mysqli_query($connection, $query); confirm_query($result); return $result; }
redirect_to("../addAlgoDetails.php?id=000011"); } } ?> <?php if (isset($_POST['AddTest'])) { $company = $_POST['Company_Name3']; $_SESSION["COMPNAME"] = $company; $courseName = $_POST['topicId']; $Edate = $_POST['inputExamdate']; // $exam_date=date_create($Edate); // $exam_date=date_format($exam_date,"Y-m-d"); $exam_date = DateTime::createFromFormat('d/m/Y', $Edate); $exam_date = $exam_date->format('Y-m-d'); $TestPercentage = $_POST['TestPercentage']; $result25 = select_Domain_id($courseName); while ($row25 = $result25->fetch_assoc()) { $tid = $row25['Topic_id']; } $result26 = checkforExamName($tid, $exam_date); if ($result26->num_rows > 0) { $Test = $courseName . $exam_date; $stmt3 = $connection->prepare("call addTestnPercentage(?,?,?)"); $stmt3->bind_param('sss', $Test, $TestPercentage, $company); $result3 = $stmt3->execute(); if ($result3) { redirect_to("../addAlgoDetails.php?id=000011"); } } else { redirect_to("../addAlgoDetails.php?id=000001"); echo $exam_date . " " . $tid;