Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Tickets.php	7.03 KB	-rw-rw-r--
attendance.php	3.07 KB	-rwxr-xr-x
commandb.php	412 B	-rwxr-xr-x
database.php	476 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	1.1 KB	-rwxr-xr-x
examtimetable.php	2.85 KB	-rwxr-xr-x
hallticket.php	3.1 KB	-rwxr-xr-x
helpDesk.php	1.12 KB	-rwxr-xr-x
iamarks.php	3.12 KB	-rwxr-xr-x
login.php	703 B	-rwxr-xr-x
logout.php	212 B	-rwxr-xr-x
practicaltimetable.php	3.21 KB	-rwxr-xr-x
profile.php	2.19 KB	-rwxr-xr-x
results.php	1.58 KB	-rwxr-xr-x

Code Editor : results.php

<?php
	
	include 'database.php';

include("commandb.php");

//session_start();
	$UNIVCODE  = $_SESSION['UNIVCODE'];

$query = "INSERT INTO menulog(funivcode,fdate,fresults)
	VALUES('{$UNIVCODE}',date_format(now(),'%Y-%m-%d'),1)
	ON DUPLICATE KEY UPDATE fresults = if(ifnull(fresults,'') = '', 1,fresults+1)";
	$results = mysqli_query($conndb,$query);
	
	$strUserLogQuery = "insert into userlog 
	(funivcode, fregno, fmobileno, fipadd, FREASONCODE, FDESCPN)
	values ('{$_SESSION['UNIVCODE']}', '{$_SESSION['REGNO']}', 
	'{$_SESSION['MOBILE']}', '{$_SERVER['REMOTE_ADDR']}', 
	'REMN', 'REMN - {$_SESSION['REGNO']} Viewed Results')";
	$result = mysqli_query($conndb,$strUserLogQuery);

$id = $_POST['id'];
	$reg_no = $_SESSION['REGNO'];
	$folder = $_SESSION['FOLDER'];
	
	$sql = "SELECT re.fexamno,dg.fexamname FROM res_fee re
	inner join degree dg on re.fdegree = dg.fdegree and re.fexamno = dg.fexamno
	where re.fregno = '{$reg_no}' order by fexamno"; 
	$result = mysqli_query($conn,$sql);
	while ($row1 = $result->fetch_assoc()) 
	{
		$array[] = $row1;
		
	}
	//var_dump(count($array));

$query = "select fregno, fdegree, fcaste from student where fregno = '{$reg_no}'"; 
	$result = mysqli_query($conn,$query);
	while ($studentrow = $result->fetch_assoc()) 
	{
		$fcaste = $studentrow['fcaste'];
		
	}

if($array > 0)
	{
		$row['sem'] = $array;
		$row['fregno'] = $reg_no;
		$row['folder'] = $folder;
		$row['fcaste'] = $fcaste;
		$row['UNIVCODE'] = $_SESSION['UNIVCODE'];
		$row['status'] = 'success';
		echo json_encode($row);
	}
	else
	{
		$data = array("status"=>"failure");
		echo json_encode($data);
	}
?>

${this.title}

Code Editor : results.php