1#@!#!123s

22527 1#@!#!123s
: / home / parchhayin / www /
Filename : new1.php
back
<?php include("header.php"); ?>
<div id="main-content">
    <div class="wrapper clearfix">
        <div class="col-a">
            <div class="breadcrumb clearfix">
                <a href="<?php echo $base_url; ?>"><i class="fa fa-home"></i>होम</a>
                <span>/</span>
                <span class="current-page"><?php 
									if( isset($_GET['cat']) && $_GET['cat']!='') {
										echo $category=str_replace('-',' ',$_GET['cat']); 
									} else{
										echo "<script>window.location.replace('".$base_url."');</script>";
									}
								?> </span>
            </div>
			<div class="widget-area-5">
                <div class="widget kopa-article-list-widget">
                    <ul class="clearfix">
						<?php 
						 
						   
						   
							$limit = 10;  
							if (isset($_GET["page"])) { 
							    
							    
							    $page  =$_GET["page"];
							    
							    
							} 
						    else { 
						        
							     $page=1;
							      
							 };  
							 
							$start_from = ($page-1) * $limit;
							
							/* for pagination */
							$tbl_name="news";	
							$query = "SELECT *  FROM $tbl_name where news_cat like '%$category%' order by id desc limit $start_from, $limit";
							
							$que   = mysqli_query($con,$query);
							while($row = mysqli_fetch_object($que)){	
							
						
							echo '<li>
                            <article class="entry-item clearfix">
                                <div class="entry-thumb">
                                    <a href="'.$base_url.'details.php?title='.$row->id.'"><img src="'.$path.$row->news_image.'" style="height:250px;" /></a>
                                    <div class="mask"><a href="#" data-icon="&#xe125;"></a></div>
                                    <span class="category-title">'.str_replace(",स्लाइडर"," ",$row->news_cat).'</span>
                                </div>
                                <!-- entry-thumb -->
                                <div class="entry-content">
                                    <header>
                                        <h5 class="entry-title"><a href="'.$base_url.'details.php?title='.$row->id.'">'.$row->news_title.'</a></h5>
                                        <span class="entry-date">&mdash;'.date("M d Y",strtotime($row->date)).'</span>
										<span>
											<a href="http://www.twitter.com/share?url='.$base_url .'news.php?cat='.$category.'&text='.$row->news_title.'" target="_blank"data-icon="&#xe1c8;"></a>&nbsp;&nbsp;&nbsp;
											<a href="https://www.facebook.com/sharer/sharer.php?u='.$base_url.'news.php?cat='.$category.'" target="_blank" data-icon="&#xe1c4;"></a>&nbsp;&nbsp;&nbsp;
											<a href="whatsapp://send?text='.$base_url .'news.php?cat='.$category.' '.$row->news_title.'" target="_blank""><i class="fa fa-whatsapp"></i></a>&nbsp;&nbsp;&nbsp;
										</span>
										<meta property="og:title" content="'.$row->news_title.'" />
                                        <meta property="og:url" content="'.$base_url .'news.php?cat='.$category.'" />
                                        <meta property="og:description" content="'.$row->news_title.'" />
                                        <meta property="og:image" content="'.$path.$row->news_image.'" />
                                    </header>
                                    
                                </div>
                                <!-- entry-content -->
                            </article>
                            <!-- entry-item -->
                        </li>';
							}
						?>
						
					</ul>
                </div>
                <!-- kopa-article-list-widget -->
            </div>
           
            <!-- breadcrumb -->
		
	
	  <div class="pagination">
            
        
          
				<?php 
					$sql = "SELECT COUNT(id) FROM news where news_cat like '%$category%'";  
					$rs_result = mysqli_query($con,$sql);  
					$row = mysqli_fetch_row($rs_result);  
					$total_records = $row[0];  
					$total_pages = ceil($total_records / $limit); 
				
				?>
		
		

<?php
				
					$pagLink = "<ul class='page-numbers clearfix'>";  
				
	            	
						    
                    if($page >= 2){   
                     
                        $pagLink .= "<li><a href='".$base_url."news.php?cat=".$category."&page=".($page-1)."' class='page-numbers'>  Prev </a></li>";   
                    }      
		
					for ($i=1; $i<=10; $i++) {
					    
					if($i==$page){		
							
						 $pagLink .= "<li class='active'><a href='".$base_url."news.php?cat=".$category."&page=".$i."' class='page-numbers'>&nbsp;&nbsp;".$i."</a></li>"  ;
						 
					}else{
					    
					     $pagLink .= "<li><a href='".$base_url."news.php?cat=".$category."&page=".$i."' class='page-numbers'>&nbsp;&nbsp;".$i."</a></li>"  ;
					    
					};  
					
				
				}
					
					if($page < $total_pages){   
                         	 $pagLink .= "<li><a href='".$base_url."news.php?cat=".$category."&page=".($page+1)."' class='page-numbers'>  Next </a></li>"  ;  
                    } 
					
					
					
					echo $pagLink . "</ul>";  
				
				
				
				
				
					
				?>
             

	  
	  </div>
            <!--pagination-->
        </div>
        <!-- col-a -->
        <div class="sidebar col-b widget-area-2">
			<?php include("include/sidebar.php"); ?>
		</div>
        <!-- col-b -->
        <div class="clear"></div>
    </div>
    <!-- wrapper -->
    <div class="widget-area-7">
        <div class="widget kopa-adv-widget">
            <a href="#"><img src="placeholders/ad_728x90_v4.gif" alt="" /></a>
        </div>
        <!-- kopa-adv-widget -->
    </div>
    <!-- widget-area-7 -->    
</div>

<?php include("footer.php"); ?>