if(!mysql_connect($_ENV['DATABASE_SERVER'], 'j43ts4t_db85876', 'A&cY3j3v6evx%DZY'))
{
echo " Error Connecting to the Db.. Inform Administrator
";
die('Could not connect: ' . mysql_error());
}
mysql_select_db("j43ts4t_db85876_avcmain");
mysql_query('SET character_set_results=utf8');
mysql_query('SET names=utf8');
mysql_query('SET character_set_client=utf8');
mysql_query('SET character_set_connection=utf8');
mysql_query('SET character_set_result=utf8');
mysql_query('SET collation_connection=utf8_general_ci');
?>
Audio of Vedanta classes
if(isset($_REQUEST['category'])){
if($_REQUEST['category'] == "Dakshinamurtistotram"){
echo "Dakshinamurti Stotram classes";
}elseif($_REQUEST['category'] == "Vedanta"){
echo "Topics of Vedanta";
}elseif($_REQUEST['category'] == "Rudram"){
echo "Sri Rudram";
}elseif($_REQUEST['category'] == "NewSanskrit"){
echo "Sanskrit '11";
}else{
echo $_REQUEST['category'];
}
}else{
echo "All Audio Classes";
}
?>
 |
if(isset($_REQUEST['category'])){
}else{
echo " Topic | ";
} ?>
 Class Date |
 Description |
 |
if(isset($_REQUEST['category'])){
$catg = $_REQUEST['category'];
if ($catg == " "){
$query = "SELECT id,category,class_date,description,file_url,up_date FROM audio_files ORDER BY class_date DESC;" ;
}else{
$query = "SELECT id,category,class_date,description,file_url,up_date FROM audio_files WHERE category = '". $catg . "' ORDER BY class_date DESC;";
}
}else{
$query = "SELECT id,category,class_date,description,file_url,up_date FROM audio_files ORDER BY class_date DESC;" ;
}
//echo "just about to execut the query";
//echo "query:".$query;
$result = mysql_query($query);
$filepath = dirname(_FILE_)."/upload/";
$i=0;
while( $row = mysql_fetch_array($result) )
{
if($i>0)
{
echo "";
echo " | ";
echo "
";
}
$category = $row['category'];
if($category == "Dakshinamurtistotram"){
$category = "Dakshinamurti Stotram classes";
}
$cdate = $row['class_date'];
$desc = $row['description'];
echo "";
echo " | ";
if(isset($_REQUEST['category'])){
}else{
echo"".$category." | ";
}
echo "".$cdate." | ";
if (empty($desc)){
echo "".$category.$cdate." | ";
}else{
echo "".$desc." | ";
}
//echo
;
echo " | ";
echo "
";
$i++;
}
echo "";
echo " | ";
echo "
";
?>