} } //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);