|
Welcome to ePapers |
$id=1;
$connHomePage=mysql_connect("localhost","epaper_epaperU","Zsvf2IOioFU8");
mysql_select_db("epaper_epaperDB",$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'];
?>
|
}
?>
|
ePapers by Country |
$connCountry=mysql_connect("localhost","epaper_epaperU","Zsvf2IOioFU8");
mysql_select_db("epaper_epaperDB",$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'];
if ($iCountry % 5==0)
{
$iCountry=$iCountry+1;
?>
}
?>
|
}
?>
|
ePapers by Category |
$connCategory=mysql_connect("localhost","u526307700_newepaper","Zsvf2IOioFU8");
mysql_select_db("u526307700_newepaper",$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'];
if ($iCategory % 5==0)
{
$iCategory=$iCategory+1;
?>
}
?>
|
}
?>
|
|
|
$connePapers=mysql_connect("localhost","epaper_epaperU","Zsvf2IOioFU8");
mysql_select_db("epaper_epaperDB",$connePapers);
$TempSStatus="Active";
$sqlePapers="select * from ePapers where SStatus='$TempSStatus' order by NoofViews DESC";
$resultePapers=mysql_query($sqlePapers,$connePapers) or die(mysql_error());
$number_of_rowsePapers=mysql_num_rows($resultePapers);
$iePapers=$ePapersTempPSizeCount=0;
while ($newarrayePapers=mysql_fetch_array($resultePapers))
{
$ePapersTempPSizeCount=$ePapersTempPSizeCount+1;
if (7 >= $ePapersTempPSizeCount and 1 <= $ePapersTempPSizeCount)
{
$iePapers=$iePapers+1;
$ePapersid=$newarrayePapers['ePapersid'];
$MBlgName=$newarrayePapers['MBlgName'];
$ePapersName=$newarrayePapers['ePapersName'];
$imagename=$newarrayePapers['imagename'];
if ($iePapers % 8==0)
{
$iePapers=$iePapers+1;
?>
}
?>
|
}
}
?>
|
|
|