test_results.php

<?php 
include('../includes/config.php');

$user_id = $_SESSION['user_id'];

if(isset($_POST['totalScore']))
{
    $totalScore = $_POST['totalScore'];
    date_default_timezone_set('Asia/Kolkata');
    $created_date = date('d-m-Y H:i:s');

$select = "SELECT * FROM iv_mem_details WHERE iv_mem_details_id='$user_id'";

$query = mysqli_query($conn,$select);
    $row = mysqli_fetch_assoc($query);

$down_level = $row['iv_mem_download_level']+1;

if($totalScore >=5)
    {
        $insert = mysqli_query($conn,"INSERT INTO iv_exam_results(user_id,total_score,result,
        exam_date) VALUES('$user_id','$totalScore','pass','$created_date')");

$update = "UPDATE iv_mem_details SET iv_mem_download_level='$down_level' WHERE iv_mem_details_id='$user_id'";
   
        $sql = mysqli_query($conn,$update);

if($sql == 1)
 {
 echo $result ='congratulations! You Have Successfully Passed The Exam
 Your Current Download Level is '.$down_level.'';
 }
 else
 {
 echo $result = 'Something Went Wrong Contact Admin';
 }

}
 else
 {
 $insert = mysqli_query($conn,"INSERT INTO iv_exam_results(user_id,total_score,result,
 exam_date) VALUES('$user_id','$totalScore','fail','$created_date')");
 echo $result = 'Sorry You Are Failed The Test Try Again Later...';
 }

}

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/ajax

	.	4096
	..	4096
	chats	27
	download	30
	event_search	6
	gallery_images	51
	gallery_videos	51
	officer_search	44
	temple_search	85
X	test_results.php	1705
X	update_quantity.php	1608