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

<?php

include ("database.php");

include("commandb.php");

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

$query = "INSERT INTO menulog(funivcode,fdate,fhelpdesk)
VALUES('{$UNIVCODE}',date_format(now(),'%Y-%m-%d'),1)
ON DUPLICATE KEY UPDATE fhelpdesk = if(ifnull(fhelpdesk,'') = '', 1,fhelpdesk+1)";

$results = mysqli_query($conndb,$query);

$query = "select concat(fcollname,', ',FTOWN,'[ ',fcollcode,' ]') as fcollcode,
		  FPRINCIPALNAME as principalname,
		  ifnull(fphone,'') as phone, ifnull(FMOBILE,'') as FMOBILE, 
		  FEMAIL as FEMAIL,
		  ifnull(FCOLLADD1,'') as FCOLLADD1,
		  ifnull(FCOLLADD2,'') as FCOLLADD2, ifnull(FCOLLADD3,'') as FCOLLADD3,
		  ifnull(FCOLLADD4,'') as FCOLLADD4
		  from college 
		  where fcollcode = '{$_SESSION['COLLCODE']}'";
//var_dump($query);
$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);
if($count > 0)
{
	$row = mysqli_fetch_assoc($result);
	
	$row['ftechcontact'] = $_SESSION['FTECHCONTACT'];
	$row['ftechemail'] = $_SESSION['FTECHEMAIL'];
	$row['status'] = 'success';
	echo json_encode($row);
}
else
{
	$data = array("status"=>"failure");
	echo json_encode($data);
}

${this.title}

Code Editor : helpDesk.php