session_start();
global $scode;
$linkID = mysql_connect("localhost", "root", "zangtang");
mysql_select_db("SciPark");
$ExhbtCode = $_GET["ExbtCode"]; $_SESSION["ExhbtCode"] = $ExhbtCode ; //echo $_SESSION["ExhbtCode"];
$query0 = "SELECT * FROM ExhbtMaster where ExhbtId = '$ExhbtCode' "; //echo $query0;
$result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error());
$tung0=mysql_affected_rows();
if($tung0 != 0)
{
while ($r = mysql_fetch_array($result0))
{
$ItemType = $r["ItemType"]; $_SESSION["ItemType"] = $ItemType ;
$StdId = $r["StdId"]; $_SESSION["StdId"] = $StdId ;
$ExhbtEName = $r["ExhbtName"]; $_SESSION["ExhbtEName"] = $ExhbtEName ;
$ExhbtEPrincipal = $r["ExhbtPrincipal"]; $_SESSION["ExhbtEPrincipal"] = $ExhbtEPrincipal ;
$ExhbtScientist = $r["Exhbt_Scientist"]; $_SESSION["ExhbtScientist"] = $ExhbtScientist ;
$ExhbtEDescription = $r["ExhbtDescr"]; $_SESSION["ExhbtEDescription"] = $ExhbtEDescription ;
$ExhbtMName = $r["ExhbtNameMarathi"]; $_SESSION["ExhbtMName"] = $ExhbtMName ;
$ExhbtMDescription = $r["ExhbtDescMarathi"]; $_SESSION["ExhbtDescMarathi"] = $ExhbtMDescription ;
$ExhbtMPrincipal = $r["ExhbtPrincipalMarathi"]; $_SESSION["ExhbtPrincipalMarathi"] = $ExhbtMPrincipal ;
$ExhbtCount = $r["ExhbtCount"]; $_SESSION["ExhbtCount"] = $ExhbtCount ;
$ExhbtWCount = $r["ExhbtWCount"]; $_SESSION["ExhbtWCount"] = $ExhbtWCount ;
$ExhbtNWCount = $r["ExhbtNWCount"]; $_SESSION["ExhbtNWCount"] = $ExhbtNWCount ;
$ExtraInfo = $r["ExhbtRemark"]; $_SESSION["ExhbtRemark"] = $ExtraInfo ;
$Vendor_Name = $r["Vendor_ID"]; $_SESSION["Vendor_Name"] = $Vendor_Name ; //echo "-".$_SESSION["Vendor_Name"];
$VendorArtist = $r["VendorArtist"]; $_SESSION["VendorArtist"] = $VendorArtist ;
$ExhbtPopularity = $r["ExhbtPopularity"]; $_SESSION["ExhbtPopularity"] = $ExhbtPopularity ;
$WebVisible = $r["WebShow"]; $_SESSION["WebShow"] = $WebVisible ;
$Exhbt_Image = $r["Exhbt_Image"]; $_SESSION["Exhbt_Image"] = $Exhbt_Image ;
$Exhbt_Audio = $r["Exhbt_Audio"]; $_SESSION["Exhbt_Audio"] = $Exhbt_Audio ;
$Exhbt_Video = $r["Exhbt_Video"]; $_SESSION["Exhbt_Video"] = $Exhbt_Video ;
}
}//tung0
//P0103001
switch($ItemType)
{ case "E": $TypeNm = "Exhibit"; break;
case "K": $TypeNm = "Kits"; break;
case "T": $TypeNm = "Teaching Aid"; break;
case "D": $TypeNm = "Demo Experiements"; break;
case "O": $TypeNm = "Other"; break;
}
$ScCode = substr($ExhbtCode,-7,2); //echo $BranchCode."-";
$ScSubCode = substr($ExhbtCode,-5,2); //echo $SubCatCode."
";
$query0 = "SELECT * FROM ExhbtCountMaster where SubjectCode='$ScCode' AND SubCatCode='$ScSubCode'";
$result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error());
$tung0=mysql_affected_rows();
if($tung0 != 0)
{ while ($r = mysql_fetch_array($result0)) { $SubjectName = $r["SubjectName"]; $SubCatName = $r["SubCatName"]; } }
$query1 = "SELECT * FROM VendorMaster where Vendor_ID='$Vendor_Name'";
$result1 = mysql_db_query("SciPark", $query1) or die ("could not query" . mysql_error());
$tung1=mysql_affected_rows();
if($tung1 != 0)
{ while ($r = mysql_fetch_array($result1)) { $VendorName = $r["VendorName"]; } }
?>
SCIENCE PARK UNIVERSITY OF PUNE
Home
Exhibit Selected for Updation :
Delete Exhibit