}
}
//connect to database and load startup row
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
$qry = "SELECT * FROM `table_data` WHERE ID='Startup'";
$res = mysql_query($qry);
if (!mysql_query($qry, $bd)) {
die("An unexpected error occured while saving the record, Please try again!");
}
$Startup = mysql_fetch_assoc($res);
$status = $Startup['Data1'];
if ($status == 0) {
header("location: index.php?e=1");
}
$Subject = getSubName(stripSubCode($Allocation));
$FacName = getFacName(stripFacEmpCode($Allocation));
$FacCode = strtolower(stripFacEmpCode($Allocation));
$ClientIP = HashString($_SERVER['REMOTE_ADDR']);
//echo $_SERVER['REMOTE_ADDR'];echo "<br>";
//echo $ClientIP;
//echo $Subject;
//echo $FacName;echo "<br>";
//echo $FacCode;
//Create a new table if the table doesn't exists
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . $FacCode . "'")) == 0) {
$query = "CREATE TABLE {$FacCode} LIKE `table_dummyfac`";
//$res=mysql_query($query);
if (!mysql_query($query)) {
$facSubMapData["sub"]["5"]["subFacName"] = getFacName(stripFacEmpCode($row['Data5']));
$facSubMapData["sub"]["5"]["subSubName"] = getSubName(stripSubCode($row['Data5']));
if ($row['Data6'] != NULL) {
$facSubMapData["sub"]["6"]["subDep"] = getSubDep(stripSubCode($row['Data6']));
$facSubMapData["sub"]["6"]["subFacName"] = getFacName(stripFacEmpCode($row['Data6']));
$facSubMapData["sub"]["6"]["subSubName"] = getSubName(stripSubCode($row['Data6']));
}
if ($row['Data7'] != NULL) {
$facSubMapData["sub"]["7"]["subDep"] = getSubDep(stripSubCode($row['Data7']));
$facSubMapData["sub"]["7"]["subFacName"] = getFacName(stripFacEmpCode($row['Data7']));
$facSubMapData["sub"]["7"]["subSubName"] = getSubName(stripSubCode($row['Data7']));
}
if ($row['Data8'] != NULL) {
$facSubMapData["sub"]["8"]["sub8Dep"] = getSubDep(stripSubCode($row['Data8']));
$facSubMapData["sub"]["8"]["sub8FacName"] = getFacName(stripFacEmpCode($row['Data8']));
$facSubMapData["sub"]["8"]["sub8SubName"] = getSubName(stripSubCode($row['Data8']));
}
header('Content-Type:application/json');
echo json_encode($facSubMapData, JSON_PRETTY_PRINT);
} else {
echo "Something Went Wrong while Getting Faculty List!";
}
}
//To Return Faculty List of a Department
$mapClassDep = $_REQUEST['mapClassDep'];
if ($mapClassDep != NULL) {
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
//For Faculty List
$query = "SELECT name,empcode FROM `table_faculty_info` WHERE dep='" . $mapClassDep . "'";
$res = mysql_query($query);