include "header.php";?> |
|
if ( isset($HTTP_POST_VARS["fsubmit"]) && ($HTTP_POST_VARS["fsubmit"] == "FindList") )
{
$findq="SELECT fname FROM showlist WHERE deptname='".$_POST['dept']."' ORDER BY priority;";
$findrs=mysql_query($findq,$link);
$frows=mysql_num_rows($findrs);
if ($frows > 0)
{
?>
}
}
?>
|
if ( isset($HTTP_POST_VARS["esubmit"]) && ($HTTP_POST_VARS["esubmit"] == "Edit-Faculty") )
{
$facname=$_POST['fname'];
$editq="SELECT * FROM showlist WHERE fname='".$_POST['fname']."';";
$editrs=mysql_query($editq,$link);
$erows=mysql_num_rows($editrs);
if ($erows > 0)
{
?>
}
}
?>
|
if (isset($HTTP_POST_VARS["usubmit"]) && ($HTTP_POST_VARS["usubmit"] == "Update-Faculty"))
{
$facname=$_POST['fname'];
echo $facname;
$updateq="UPDATE showlist SET fname='".$_POST['fname']."',linkshow='".$_POST['filelink']."',qual='".$_POST['qual']."',desg='".$_POST['desg']."',ophone='".$_POST['ophone']."',rphone='".$_POST['home']."',mobile='".$_POST['mobile']."',email='".$_POST['emails']."',subjects='".$_POST['subjects']."',aoi='".$_POST['aoi']."',priority='".$_POST['priority']."' WHERE fname='".$_POST['facname']."';";
echo $updateq;
$updaters=mysql_query($updateq,$link);
if ($updaters)
{
?>
echo "Faculty Details are Successfully Updated of :-".$_POST['fname'];?> |
}
else
{
?>
echo "Update Query Did not Work for :-".$_POST['fname']; ?> |
}
}
?>
if (isset($HTTP_POST_VARS["dsubmit"]) && ($HTTP_POST_VARS["dsubmit"] == "Delete-Faculty"))
{
$facname=$_POST['fname'];
echo $facname;
$deleteq="DELETE FROM showlist WHERE fname='".$_POST['fname']."';";
echo $deleteq;
$deleters=mysql_query($deleteq,$link);
if ($deleters)
{
?>
echo "Faculty Details are Successfully Removed of :-".$_POST['fname'];?> |
}
else
{
?>
echo "Delete Operation Did not Work for :-".$_POST['fname']; ?> |
}
}
?>