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 : examtimetable.php

<?php

include("database.php");

include("commandb.php");

//session_start();
$UNIVCODE  = $_SESSION['UNIVCODE'];
$query = "INSERT INTO menulog(funivcode,fdate,fthtimetable)
VALUES('{$UNIVCODE}',date_format(now(),'%Y-%m-%d'),1)
ON DUPLICATE KEY UPDATE fthtimetable = if(ifnull(fthtimetable,'') = '', 1,fthtimetable+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']}', 
	'TTMN', 'TTMN - {$_SESSION['REGNO']} Viewed Theory Time Table')";
$result = mysqli_query($conndb,$strUserLogQuery);

$regno  = $_SESSION['REGNO'];
$screen = $_POST['screen'];

$query = "select cd.fregno, dg.fexamname, cd.fexamno, st.fname,
concat(cd.fdegree,' - ',dg.fdescpn) as fdegree, cd.fexamtype, 
concat(dg.fexamdate, ' Examination') as fexamdate, cd.fyear, 
su.fqpcode, su.fsubname, 
concat(date_format(su.fdoe,'%d/%m/%Y'),' [',dayname(su.fdoe),']') as fdoe, re.fdescpn,
concat('[', cs.fcntrcode, '] ', cl.fcollname, ', ' , cl.ftown) as centre 
from canddet cd
inner join subject su
on cd.fdegree = su.fdegree
and cd.fexamno = su.fexamno
and cd.fsubcode = su.fsubcode
and ifnull(su.fqpcode,'') <> ''
inner join degree dg on
cd.fdegree = dg.fdegree 
and cd.fexamno = dg.fexamno
inner join student st on 
cd.fcollcode = st.fcollcode
and cd.fdegree = st.fdegree
and cd.fregno =st.fregno
inner join reason re
on su.fsession = re.freasoncd
inner join candsum cs
on cd.fdegree = cs.fdegree
and cd.fcollcode = cs.fcollcode
and cd.fregno = cs.fregno
and cs.fyear = dg.fmeyear
and cs.fexamtype = dg.fmeexamtyp
inner join college cl
on cs.fcntrcode = cl.fcollcode
where cd.fregno = '{$regno}'
and ifnull(cd.fpassmth,'') = ''
and ifnull(cd.fpresent,'') = 'P'
and su.ftheory = 'T'";
//var_dump($query);
$result = mysqli_query($conn,$query);
//var_dump(count($result));
$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'];
		$fregno = $row['fregno'];
		$strCentre = $row['centre'];
		$rgExamno[$i] = $row['fexamno'];
		$rgExamname[$i] = $row['fexamname'];
		$fqpcode[$i] = $row['fqpcode'];
		$fdoe[$i] = $row['fdoe'];
		$fdescpn[$i] = $row['fdescpn'];
		$fsubname[$i] = $row['fsubname'];
		
		$i++;

}
	
	$app['error_code'] = 1;
	$app['fqpcode'] = $fqpcode;
	$app['fsubname'] = $fsubname;
	$app['fdescpn'] = $fdescpn;
	$app['fdoe'] = $fdoe;
	$app['fname'] = $fname;
	$app['fdegree'] = $fdegree;
	$app['strCentre'] = $strCentre;
	$app['fexamname'] = $rgExamname;
	$app['rgExamno'] = $rgExamno;
	$app['fexamdate'] = $fexamdate;
	$app['fregno'] = $fregno;

echo json_encode($app);
}else
{
	$app['data'] = "Exam Time Table Not Available";
	$app['error_code'] = 0;
	echo json_encode($app);
}

${this.title}

Code Editor : examtimetable.php