| |
| Welcome to eMagazines |
$id=2;
$connHomePage=mysqli_connect("localhost","u526307700_epaper_epaperU","Zsvf2IOioFU8","u526307700_epaper_epaperU");
$sqlHomePage="select * from HomePage where HomePageid=".$id;
$resultHomePage=mysqli_query($connHomePage,$sqlHomePage) or die(mysqli_error());
$number_of_rowsHomePage=mysqli_num_rows($resultHomePage);
if($newarrayHomePage=mysqli_fetch_assoc($resultHomePage))
{
$HomePageBody=$newarrayHomePage['HomePageBody'];
?>
|
}
?>
|
| eMagazines by Country |
$connCountry=mysqli_connect("localhost","u526307700_epaper_epaperU","Zsvf2IOioFU8","u526307700_epaper_epaperU");
$sqlCountry="select * from Country order by CountryName";
$resultCountry=mysqli_query($connCountry, $sqlCountry) or die(mysqli_error());
$number_of_rowsCountry=mysqli_num_rows($resultCountry);
$iCountry=0;
while ($newarrayCountry=mysqli_fetch_assoc($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=mysqli_connect("localhost","u526307700_epaper_epaperU","Zsvf2IOioFU8","u526307700_epaper_epaperU");
$sqlCategory="select * from Category order by CategoryName";
$resultCategory=mysqli_query($connCategory,$sqlCategory) or die(mysqli_error());
$number_of_rowsCategory=mysqli_num_rows($resultCategory);
$iCategory=0;
while ($newarrayCategory=mysqli_fetch_assoc($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=mysqli_connect("localhost","u526307700_epaper_epaperU","Zsvf2IOioFU8","u526307700_epaper_epaperU");
$sqlLangageus="select * from Langageus order by LangageusName";
$resultLangageus=mysqli_query($connLangageus,$sqlLangageus) or die(mysqli_error());
$number_of_rowsLangageus=mysqli_num_rows($resultLangageus);
$iLangageus=0;
while ($newarrayLangageus=mysqli_fetch_assoc($resultLangageus))
{
$iLangageus=$iLangageus+1;
$LangageusNameLnk=$newarrayLangageus['LangageusName'];
$LangageusBlgNameLnk=$newarrayLangageus['LangageusBlgName'];
$LanguageePaperURL=$newarrayLangageus['LanguageePaperURL'];
$LanguageURL=$newarrayLangageus['LanguageURL'];
if ($iLangageus % 5==0)
{
$iLangageus=$iLangageus+1;
?>
}
?>
|
|
}
?>
|
|
|
$conneMagazines=mysqli_connect("localhost","u526307700_epaper_epaperU","Zsvf2IOioFU8","u526307700_epaper_epaperU");
$TempSStatus="Active";
$sqleMagazines="select * from eMagazines where Status='$TempSStatus' order by NoofViews DESC";
$resulteMagazines=mysqli_query($conneMagazines,$sqleMagazines) or die(mysqli_error());
$number_of_rowseMagazines=mysqli_num_rows($resulteMagazines);
$ieMagazines=$eMagazinesTempPSizeCount=0;
while ($newarrayeMagazines=mysqli_fetch_assoc($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;
?>
}
?>
|
|
}
}
?>
|
|
|