Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
attendance.php	2.43 KB	-rwxr-xr-x
database.php	476 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	445 B	-rwxr-xr-x
examtimetable.php	2.2 KB	-rwxr-xr-x
hallticket.php	2.31 KB	-rwxr-xr-x
helpDesk.php	831 B	-rwxr-xr-x
iamarks.php	2.51 KB	-rwxr-xr-x
login.php	299 B	-rwxr-xr-x
logout.php	212 B	-rwxr-xr-x
practicaltimetable.php	2.55 KB	-rwxr-xr-x
profile.php	2.17 KB	-rwxr-xr-x
results.php	676 B	-rwxr-xr-x

Code Editor : iamarks.php

<?php

include("database.php");
$regno  = $_SESSION['REGNO'];
$screen = $_POST['screen'];

$query = "select DATE_FORMAT(NOW(),'%Y-%m-%d') as presentdate, 
DATE_ADD(collexam.fiato, INTERVAL 80 DAY) AS FROMDATE, 
DATE_FORMAT(collexam.fiato, '%Y-%m-%d') as lastdate,  
DATE_FORMAT(DATE_SUB(collexam.fiato, INTERVAL 3 DAY), '%d/%m/%Y')  as bforelaste from collexam 
where fcollcode = '{$_SESSION['COLLCODE']}' 
and fdegree = '{$_SESSION['DEGREE']}'  
and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_SUB(collexam.fiato, INTERVAL 3 DAY)
AND DATE_ADD(collexam.fiato,INTERVAL 80 DAY)";

$result = mysqli_query($conn,$query);

$count = mysqli_num_rows($result);

if($count > 0)
{
	$query = "select mr.fregno, st.fname, dg.fexamname, concat(dg.fexamdate, ' Examnination') as fexamdate,
	mr.fexamno, concat(mr.fdegree,' - ',dg.fdescpn) as fdegree,
	mr.fcollcode, su.fcsubcode, concat(su.fsubname,' - ',su.fssubname) as fsubname,su.fvalmax as fvalmax, 
	su.fsubshort, su.fshortname, 
	if(ifnull(mr.fmarks,'') = '-2','Ab.',mr.fmarks) as fmarks 
	from marks mr 
	inner join degree dg on
	mr.fdegree = dg.fdegree 
	and mr.fexamno = dg.fexamno
	inner join subject su 
	on mr.fdegree = su.fdegree 
	and mr.fexamno = su.fexamno 
	and mr.fsubcode = su.fcsubcode
	inner join student st on 
	mr.fcollcode = st.fcollcode
	and mr.fdegree = st.fdegree
	and mr.fregno =st.fregno
	where mr.fregno = '{$regno}'
	and ifnull(mr.fmarks,'') <> '-1'
	order by fcsubcode";

$result = mysqli_query($conn,$query);
	$count = @mysqli_num_rows($result);

if($count > 0)
	{
		$i = 0;
		while($row = mysqli_fetch_assoc($result))
		{
			$fname = $row['fname'];
			$fdegree = $row['fdegree'];
			$fexamdate = $row['fexamdate'];
			$fexamname = $row['fexamname'];
			$fregno = $row['fregno'];
			$fcsubcode[$i] = $row['fcsubcode'];
			//$fshortname[$i] = $row['fshortname'];
			$fsubname[$i] = $row['fsubname'];
			$fvalmax[$i] = $row['fvalmax']; 
			$fmarks[$i] = $row['fmarks'];
			$i++;

}

$app['error_code']  = 1;
		$app['fcsubcode']   = $fcsubcode;
		$app['fsubname']    = $fsubname;
		$app['fvalmax']     = $fvalmax;
		$app['fmarks']      = $fmarks;
		$app['fname']       = $fname;
		$app['fdegree']     = $fdegree;
		$app['fexamname']   = $fexamname;
		$app['fexamdate']   = $fexamdate;
		$app['fregno']      = $fregno;

echo json_encode($app);
	}else
	{
		$app['data'] = "IA MARKS NOT AVAILABLE";
		$app['error_code'] = 0;
		echo json_encode($app);
	}
}
else
{
	$row = mysqli_fetch_assoc($result);
	$app['data'] = "IA MARKS NOT AVAILABLE";
	$app['error_code'] = 0;
	echo json_encode($app);
}

${this.title}

Code Editor : iamarks.php