|
Welcome to eMagazines |
$id=2;
$connHomePage=mysql_connect("localhost","u526307700_epaper_epaperU","Ee9?T;^d#");
mysql_select_db("u526307700_epaper_epaperU",$connHomePage);
$sqlHomePage="select * from HomePage where HomePageid=".$id;
$resultHomePage=mysql_query($sqlHomePage, $connHomePage) or die(mysql_error());
$number_of_rowsHomePage=mysql_num_rows($resultHomePage);
if($newarrayHomePage=mysql_fetch_array($resultHomePage))
{
$HomePageBody=$newarrayHomePage['HomePageBody'];
?>
|
}
?>
|
eMagazines by Country |
$connCountry=mysql_connect("localhost","u526307700_epaper_epaperU","Ee9?T;^d#");
mysql_select_db("u526307700_epaper_epaperU",$connCountry);
$sqlCountry="select * from Country order by CountryName";
$resultCountry=mysql_query($sqlCountry,$connCountry) or die(mysql_error());
$number_of_rowsCountry=mysql_num_rows($resultCountry);
$iCountry=0;
while ($newarrayCountry=mysql_fetch_array($resultCountry))
{
$iCountry=$iCountry+1;
$CountryNameLnk=$newarrayCountry['CountryName'];
$CountryBlgNameLnk=$newarrayCountry['CountryBlgName'];
$CountryePaperURL=$newarrayCountry['CountryePaperURL'];
$CountryURL=$newarrayCountry['CountryURL'];
if ($iCountry % 5==0)
{
$iCountry=$iCountry+1;
?>
}
?>
|
}
?>
|
eMagazines by Category |
$connCategory=mysql_connect("localhost","u526307700_epaper_epaperU","Ee9?T;^d#");
mysql_select_db("u526307700_epaper_epaperU",$connCategory);
$sqlCategory="select * from Category order by CategoryName";
$resultCategory=mysql_query($sqlCategory,$connCategory) or die(mysql_error());
$number_of_rowsCategory=mysql_num_rows($resultCategory);
$iCategory=0;
while ($newarrayCategory=mysql_fetch_array($resultCategory))
{
$iCategory=$iCategory+1;
$CategoryNameLnk=$newarrayCategory['CategoryName'];
$CategoryBlgNameLnk=$newarrayCategory['CategoryBlgName'];
$CategoryePaperURL=$newarrayCategory['CategoryePaperURL'];
$CategoryURL=$newarrayCategory['CategoryURL'];
if ($iCategory % 5==0)
{
$iCategory=$iCategory+1;
?>
}
?>
|
}
?>
|
eMagazines by Language |
$connLangageus=mysql_connect("localhost","u526307700_epaper_epaperU","Ee9?T;^d#");
mysql_select_db("u526307700_epaper_epaperU",$connLangageus);
$sqlLangageus="select * from Langageus order by LangageusName";
$resultLangageus=mysql_query($sqlLangageus,$connLangageus) or die(mysql_error());
$number_of_rowsLangageus=mysql_num_rows($resultLangageus);
$iLangageus=0;
while ($newarrayLangageus=mysql_fetch_array($resultLangageus))
{
$iLangageus=$iLangageus+1;
$LangageusNameLnk=$newarrayLangageus['LangageusName'];
$LangageusBlgNameLnk=$newarrayLangageus['LangageusBlgName'];
$LanguageePaperURL=$newarrayLangageus['LanguageePaperURL'];
$LanguageURL=$newarrayLangageus['LanguageURL'];
if ($iLangageus % 5==0)
{
$iLangageus=$iLangageus+1;
?>
}
?>
|
}
?>
|
|
|
$conneMagazines=mysql_connect("localhost","u526307700_epaper_epaperU","Ee9?T;^d#");
mysql_select_db("u526307700_epaper_epaperU",$conneMagazines);
$TempSStatus="Active";
$sqleMagazines="select * from eMagazines where Status='$TempSStatus' order by NoofViews DESC";
$resulteMagazines=mysql_query($sqleMagazines,$conneMagazines) or die(mysql_error());
$number_of_rowseMagazines=mysql_num_rows($resulteMagazines);
$ieMagazines=$eMagazinesTempPSizeCount=0;
while ($newarrayeMagazines=mysql_fetch_array($resulteMagazines))
{
$eMagazinesTempPSizeCount=$eMagazinesTempPSizeCount+1;
if (7 >= $eMagazinesTempPSizeCount and 1 <= $eMagazinesTempPSizeCount)
{
$ieMagazines=$ieMagazines+1;
$eMagazinesid=$newarrayeMagazines['eMagazinesid'];
$MBlgName=$newarrayeMagazines['MBlgName'];
$eMagazinesName=$newarrayeMagazines['eMagazinesName'];
$imagename=$newarrayeMagazines['imagename'];
if ($ieMagazines % 8==0)
{
$ieMagazines=$ieMagazines+1;
?>
}
?>
|
}
}
?>
|
|
|