コード例 #1
0
ファイル: addSyllabus.php プロジェクト: DaOYit/WeAreHr
<?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);
        }
    }
コード例 #2
0
ファイル: addSyllabus.php プロジェクト: riteshtandon23/WeRHR
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"];
                }
コード例 #3
0
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;
}
コード例 #4
0
        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;