bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php 
	include "admin/dbc.php";

$qry = mysqli_query($link,"select * from blog where status=0"); 
	$n = mysqli_num_rows($qry);
	if($n>0){
		$result = $n/8;
	}

$value = $_POST['value'];
	$value1 = $value+1;
	$value2 = $value-1;
	$msg="";

if($value==1){
			$sblog = mysqli_query($link,"select * from blog where status=0 limit 9");
		}
		if($value>1){
			$val = $value*8;
			$quantity = $val-8;

$sblog = mysqli_query($link,"select * from blog where status=0 and id>$quantity limit 8");
		}

$msg .= '<div class="row clearfix">
           <div class="content-column col-lg-9 col-md-8 col-sm-12 col-xs-12">
        	<div class="row clearfix">';

while($blog = mysqli_fetch_array($sblog)){

$msg .= '<div class="news-style-one col-md-6 col-sm-6 col-xs-12">
                    <div class="inner-box">
                        <div class="image-box">
                            <a href="blog_view.php?id='.$blog['id'].'"><img src="admin/'.$blog['image'].'" alt="" /></a>
                        </div>
                        <div class="lower-box">
                            <div class="title">'.$blog['sub_title'].'</div>
                            <h3><a href="blog_view.php?id='.$blog['id'].'">'.$blog['title'].'</a></h3>
                            <div class="text">'.$out = strlen($blog['short_desc']) > 181 ? substr($blog['short_desc'],0,181)."..." : $blog['short_desc'].'</div>
                           <a href="blog_view.php?id='.$blog['id'].'" class="read-more">Read More</a>
                        </div>
                    </div>
                </div>';

}
     $msg .= '
     		</div>
        </div>
        <div class="sidebar-side col-lg-3 col-md-4 col-sm-8 col-xs-12">
            <div class="sidebar">
            <div class="sidebar-widget search-box">
            	<form method="post" action="#">
                    <div class="form-group">
                        <input type="search" name="search-field" value="" placeholder="Search" required="">
                        <button type="submit"><span class="icon fa fa-search"></span></button>
                    </div>
                </form>
            </div>

<div class="sidebar-widget sidebar-category">
            	<div class="sidebar-title">
                    <h2>PRODUCT CATEGORIES</h2>
                </div>
                <ul class="list">';
                	$cblog = mysqli_query($link,"select * from blog_category where status=0");
                    while($cat_rw = mysqli_fetch_array($cblog)){ 
                    $msg .= '<li><a href="blog.php?cat='.$cat_rw['cat_id'].'">'.$cat_rw['cat_name'].'</a></li>';
                    }
                $msg .= '</ul>
            </div>
           </div>
		</div>
		</div>';
		
		$msg .= '<div class="styled-pagination text-center">
            <ul>';
            $i=1; $pagination = ceil($result);
            if($values>1){
            $msg .= '<li><a id="'.$value2.'" class="li_value" href="#">Previous</a></li>';
            }else{
                $msg .= '<li><a href="blog.php" class=" ">Previous</a></li>';
            }
            
				while($pagination>0){ 
					if($i==1){
						$msg .= '<li><a href="blog.php" class=" ">'.$i.'</a></li>';
					}
					if($i>1){
					    $nt = $i+1;
					 	if($value==$i){
					 		$msg .= '<li><a href="#" id="'.$i.'" class="active li_value">'.$i.'</a></li>';
					 	}else{
					 		$msg .= '<li><a href="#" id="'.$i.'" class="li_value">'.$i.'</a></li>';
					 	}
					 }
					 $pagination--; $i++; }
                    if($value<$pagination){
            		$msg .= '<li><a id="'.$value1.'" class="li_value" href="#">Next</a></li>';
            		}else{
            		    $msg .= '<li style="padding: 15px;border: 1px solid #dddddd;">Next</li>';	
            		}
                $msg .= '</ul>
            </div>';
        
            echo $msg;

?>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
	<script type="text/javascript">
		$(document).ready(function(){
			$(".li_value").click(function(){
				var value = $(this).attr("id");
				var category = $("#category").val();
				$.ajax({
				    type: "POST",  
				    url: "blog_item.php",  
				    data: { value: value },
				   	success: function(msg){ 
				   	   
					    $("#blog_section").html(msg); 
				    }
			    }); 
			});	
		});
		
	</script>