// asp2php (vbscript) converted
include "../global.php";
?>
//option explicit
$CurrentAlpha=$HTTP_POST_VARS["Alpha"]; // Current Alphabet Letter
$DisplayGlossary=$HTTP_POST_VARS["Glossary"]; //Boolean to display Glossary
$CurrentTermID=$HTTP_POST_VARS["Term"]; // Current Term to display Glossaries
if ($CurrentAlpha == "")
{
$CurrentAlpha="A";
}
//response.write CurrentAlpha & DisplayGlossary & CurrentTerm & "Terms" // commented out in asp
if ($DisplayGlossary=="")
{
$DisplayGlossary="NO";
}
else
if ($DisplayGlossary!="NO")
{
GetGlossary($CurrentTermID);
}
?>
}
else
{
print " ";
} ?>
if ($DisplayGlossary!="YES")
{
?>
} ?>
function getCurrentTerms($str1)
{
extract($GLOBALS);
if ($str1!="0")
{
$StrSQL="where Term LIKE '".$str1."%'";
}
$StrSQL="SELECT * FROM Glossary ".$StrSQL."order by Term";
// $oConn is of type "ADODB.Connection"
// oConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & //Server.MapPath("../database/clir.mdb")
// echo $Application["AppConnectionStr"];
$oConn = mysql_connect(OUR_HOST, OUR_USER, OUR_PWD);
mysql_select_db(OUR_DB,$oConn);
$oRS_query = mysql_query($StrSQL, $oConn);
$oRS = mysql_fetch_array($oRS_query);
if (($oRS==0))
{
print "No records";
}
else
{
while(!($oRS==0))
{
$temp_str="";
$temp_str=$temp_str."".$oRS["Term"]." ";
echo $temp_str;
$oRS=mysql_fetch_array($oRS_query);
}
}
// Clean up 1 and say goodbye.
// $getCurrentTerms=$temp_str;
$oRS=null;
mysql_close($oConn);
$oConn=null;
return $function_ret;
}
function GetGlossary($CurTerm)
{
// extract($GLOBALS);
global $CurrentTerm, $TermDescription;
$temp_str="SELECT Term, Term_Desc FROM Glossary where TermID = ".$CurTerm;
$oConn=mysql_connect(OUR_HOST,OUR_USER,OUR_PWD);
mysql_select_db(OUR_DB,$oConn); // TEST echo (mysql_error($oConn)." ");
$oRS_query = mysql_query($temp_str, $oConn); // TEST echo (mysql_error($oConn)." ");
$oRS = mysql_fetch_array($oRS_query); // TEST echo (mysql_error($oConn)." ");
if (($oRS==0))
{
print "No records";
}
else
{
$temp_str="";
while(!($oRS==0))
{
$CurrentTerm=$oRS["Term"]; // TEST echo $CurrentTerm ." ";
$TermDescription=$oRS["Term_Desc"];
$oRS=mysql_fetch_array($oRS_query);
// }
// while($oRS=mysql_fetch_row($oRS_query)){
// TEST echo mysql_error($oConn) . " ";
//$CurrentTerm=$oRS["Term"]; echo $CurrentTerm ." ";
//$TermDescription=$oRS["Term_Desc"];
}
}
// Clean up 2 and say goodbye.
$oRS=null;
mysql_close($oConn);
$oConn=null;
return $function_ret;
}
?>