ArticleID; $articletitle=stripslashes($row->ArticleTitle); $articleteaser=$row->ArticleTeaser; $articleteaser=stripslashes($articleteaser); $articleteaser = str_replace("\n","
",$articleteaser); /*if(strlen($articledesc) > 400){ $articledesc = substr($articledesc,0,400); $articledesc = substr($articledesc,0,strrpos($articledesc," ")); $articledesc.= " .."; }*/ $ArticleAddDate=$row->ArticleAddDate; $ArticleAddDate=stripslashes($ArticleAddDate); $yyyy=substr($ArticleAddDate,0,4); $mm=substr($ArticleAddDate,5,2); $dd=substr($ArticleAddDate,8,2); $ArticleAddDate = date ("F d, Y", mktime(0,0,0,$mm,$dd,$yyyy)); $lastupdatedarticle = $ArticleAddDate; //$Status=$row->Status; //$Status=stripslashes($Status); $articleids[$i] = $articleid; $articletitles[$i] = $articletitle; $articleteasers[$i] = $articleteaser; if ($row->ImageName==NULL){ $articleimagename[$i]="default.jpg"; } else { $articleimagename[$i]="tn_".$row->ImageName; } $i++; } //Paging // Query to find number of articles... if (isset($_GET['cid'])){ $query="SELECT ArticleID,CategoryName FROM articlenew,articlecategory where Status='Show' and ArticleCategoryID=$cid and articlecategory.CategoryID=articlenew.ArticleCategoryID"; }else{ $query="SELECT ArticleID FROM articlenew where Status='Show'"; } $results = mysql_query($query) or die ("Invalid query"); $num_of_articles=mysql_num_rows($results); if (isset($_GET['cid'])){ $row = mysql_fetch_object($results); $tpl_categoryname=stripslashes($row->CategoryName); } //Paging Begins //Variables //Passed variables: $num_of_articles. //Configured: $pagesize plus $numofsidenumbers=3; $pagename="article_listing.php"; $newstartnum=$endnum; $pages=$num_of_articles/$pagesize; if (($num_of_articles%$pagesize)!=0) { $pages=$pages+1; } $pages=ceil($pages); //echo $pages."
"; $checknum=$newstartnum-$pagesize; //Previous if ($checknum!=0) { $PAGING=""; $prevnum=$checknum-$pagesize; if (isset($_GET['cid'])){ $PAGING.="Previous "; }else{ $PAGING.="Previous "; } } //others for ($i=0;$i<$pages;$i++) { //$num_of_articles%($pagesize*$i); $pagenum=$i+1; $testnum=$i*$pagesize; //echo $testnum."-".$pagenum."-".$checknum."
"; if ($testnum <$num_of_articles) { if ($testnum <= ($checknum + ($pagesize*$numofsidenumbers)) && $testnum >= ($checknum - ($pagesize*$numofsidenumbers)) ) { //check which page if($testnum!=$checknum) { if (isset($_GET['cid'])){ $PAGING=$PAGING."".$pagenum." "; }else{ $PAGING=$PAGING."".$pagenum." "; } } else { if ($num_of_articles > $pagesize) { // echo $pagenum; $PAGING=$PAGING." ".$pagenum." "; } } } } } //Next Page if ($checknum!=($pages-2)*$pagesize) { $nextnum=$checknum+$pagesize; if (isset($_GET['cid'])){ $PAGING.="Next"; }else{ $PAGING.="Next"; } } if ($startnum>$num_of_articles){ $PAGING="Invalid Query...."; } //Paging Ends include('tpl_article_listing.php'); ?>