1#@!#!123s

22527 1#@!#!123s
: / home / parchhayin / public_html / admin /
Filename : news_list.php
back
<?php
 include('main.php');
?>

 <div class="content-page">
                <!-- Start content -->
                <div class="content">
                    <div class="container">

                        <!-- Page-Title -->
                        <div class="row">
                            <div class="col-sm-12">
                               
                             <!--   <h4 class="pull-left page-title">Welcome !</h4>-->
                                <ol class="breadcrumb pull-right">
                                     
                                        <li><a href="index.php">Dashboard</a></li>
                                    <li class="active">News List View</li>
                                </ol>
                            </div>
                        </div>
                        
<div class="col-lg-12">
                                <div class="portlet"><!-- /portlet heading -->
                                    <div class="portlet-heading">
                                        <h3 class="portlet-title text-dark text-uppercase">
                                
                                        </h3></br>
  <h4 class="hed"><i class="fa fa-user"></i>  News List</h4> <hr/></br>
 
    <form method="GET">
    <div class="col-md-4"> 
 <select id='standard' name='query' class='form-control input-lg' onchange="this.form.submit()">
<option>Select category</option>
  <?php  
  $get_cats = "select * from category";

     //varibale// 
	$run_cats = mysqli_query($con, $get_cats);

    while ($row_cats=mysqli_fetch_array($run_cats))
{
          
       echo $cat_title = $row_cats['category'];
      ?>
<option <?php if($_GET['query']=="$cat_title") { ?> selected=""<?php } ?>><?php echo $cat_title ?></option>
  
		<?php }
		 ?>
		 </select> 
          
    </div>
      <div class="col-md-6"> </div>
      </form>
<?php
	$tbl_name="news";		//your table name
	// How many adjacent pages should be shown on each side?
	$adjacents = 200000001;
	
	$query = $_GET['query']; 
	
	 $query2 = "SELECT COUNT(*) as num FROM $tbl_name WHERE (`news_cat` LIKE '%".$query."%')";
	$total_pages = mysqli_fetch_array(mysqli_query($con, $query2));
	 $total_pages = $total_pages['num'];
	/* Setup vars for query. */
	$targetpage = "news_list.php"; 	//your file name  (the name of this file)
	$limit = 10; 
									//how many items to show per page
	$page =  $_GET['page'];
	if($page) 
		$start = ($page - 1) * $limit; 			//first item to display on this page
	else
		$start = 0;								//if no page var is given, set start to 0
	
        $raw_results = mysqli_query($con, "SELECT * FROM $tbl_name
            WHERE (`news_cat` LIKE '%".$query."%') order by id desc LIMIT $start, $limit") or die(mysqli_error());
	
	
	if ($page == 0) $page = 1;					//if no page var is given, default to 1.
	$prev = $page - 1;							//previous page is page - 1
	$next = $page + 1;							//next page is page + 1
	$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
	$lpm1 = $lastpage - 1;						//last page minus 1
	
	/* 
		Now we apply our rules and draw the pagination object. 
		We're actually saving the code to a variable in case we want to draw it more than once.
	*/
	$pagination = "";
	if($lastpage > 1)
	{	
		$pagination .= "<div class=\"pagination\">";
		//previous button
		if ($page > 1) 
			$pagination.= "<a href=\"$targetpage?page=$prev\">&nbsp;&nbsp;previous</a>";
		else
			$pagination.= "<span class=\"disabled\">&nbsp;&nbsp;previous</span>";	
		
		//pages	
		if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
		{	
			for ($counter = 1; $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
			}
		}
		elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
		{
			//close to beginning; only hide later pages
			if($page < 1 + ($adjacents * 2))		
			{
				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">&nbsp;&nbsp;$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">&nbsp;&nbsp;$lastpage</a>";		
			}
			//in middle; hide some front and some back
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">&nbsp;&nbsp;$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">&nbsp;&nbsp;$lastpage</a>";		
			}
			//close to end; only hide early pages
			else
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
				}
			}
		}
		
		//next button
		if ($page < $counter - 1) 
			$pagination.= "<a href=\"$targetpage?page=$next\">&nbsp;&nbsp;next </a>";
		else
			$pagination.= "<span class=\"disabled\">&nbsp;&nbsp;next </span>";
		$pagination.= "</div>\n";		
	}
	
?>

</br></br>
  <form class="form-horizontal m-t-20" action="" method="post" enctype="multipart/form-data" >
	<?php

	 
	 echo "<table id='news'>
	 <tr>
     <th>S No.</th>
	  <th>Date</th>
	  <th> Image</th>	 
	 
	 <th>News Title</th>
	  <th> Category</th>
	 <th>Edit</th>
	 <th>Delete</th>	 
	
	 </tr> ";$s=1;
	 while($row = mysqli_fetch_array($raw_results)) {
		 
		 $id = $row['id'];
		$title = $row['news_title'];
		$cat = $row['news_cat'];
		
		$image = $row['news_image'];
		
		
		
		 echo "<tr>";
		 
		 echo "<td>$s</td>";
		 
		 	echo "<td>".$row['date']."</td>";
		 echo "<td><img src='../images/$image' width='135' height='100' style='border:2px solid;'/></td>";
		 
		echo "<td>$title</td>";
		echo "<td>$cat</td>";
		
	       echo "<td><a href='news_update.php?id=$id' class='btn btn-info'><i class='fa fa-pencil' aria-hidden='true'></i> Edit</a></td>";
		  
		  
		 echo "<td> <button onClick='return checkMe()' name='id' value='".$id."' type='submit' class='btn btn-danger'><i class='fa fa-trash'></i> </button>
   
   </td>";	
	 
	$s++;  }
	$id = $_POST['id'];  
 
 if($id != ""){ 
 
  $query = mysqli_query($con,"DELETE FROM $tbl_name WHERE id ='$id'");
	  

	  echo "<meta http-equiv='refresh' content='0'>";
	   
 }
		
	   
	  echo "</tr>";
 echo "</table>";
		
	?>

<?=$pagination ?>

</form>
  <script language="javascript">
function checkMe() {
    if (confirm("Are you sure you want to delete")) {
       
        return true;
    } else {
        
        return false;
    }
}
</script>
</div>
                                </div> <!-- /Portlet -->
                            </div>   
                            
                              </div>  
<?php

 include('footer.php');
?>