Gecko [ sachasauda.akalacademy.ac.in ]

Name	Size	Permission
bootstrap	[ DIR ]	drwxr-xr-x
build	[ DIR ]	drwxr-xr-x
cbse	[ DIR ]	drwxr-xr-x
dist	[ DIR ]	drwxr-xr-x
file	[ DIR ]	drwxr-xr-x
gallery	[ DIR ]	drwxr-xr-x
news-coverage	[ DIR ]	drwxr-xr-x
pdf	[ DIR ]	drwxr-xr-x
photo	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
shining-star	[ DIR ]	drwxr-xr-x
slider	[ DIR ]	drwxr-xr-x
sym	[ DIR ]	drwxr-xr-x
tc	[ DIR ]	drwxr-xr-x
toppers	[ DIR ]	drwxr-xr-x
.htaccess	197 B	-r--r--r--
.mad-root	0 B	-rw-r--r--
Gruntfile.js	6.49 KB	-rwxr-xr-x
add-album.php	1.75 KB	-rwxr-xr-x
add-cbse-corner.php	2.18 KB	-rwxr-xr-x
add-class.php	1.75 KB	-rwxr-xr-x
add-fee.php	3.65 KB	-rwxr-xr-x
add-gallery.php	3.1 KB	-rwxr-xr-x
add-news-coverage.php	2.57 KB	-rwxr-xr-x
add-news.php	2.68 KB	-rwxr-xr-x
add-pages.php	2.2 KB	-rwxr-xr-x
add-pdf.php	2.12 KB	-rwxr-xr-x
add-shining-star.php	2.47 KB	-rwxr-xr-x
add-slide.php	2.15 KB	-rwxr-xr-x
add-tc.php	2.43 KB	-rwxr-xr-x
add-toppers.php	3.28 KB	-rwxr-xr-x
album.php	3.86 KB	-rwxr-xr-x
cbse-corner.php	4.02 KB	-rwxr-xr-x
class.php	3.99 KB	-rwxr-xr-x
config.php	735 B	-rwxr-xr-x
error_log	2.87 KB	-rwxr-xr-x
fee.php	2.78 KB	-rwxr-xr-x
footer.php	8.33 KB	-rwxr-xr-x
gallery.php	3.97 KB	-rwxr-xr-x
header.php	9.44 KB	-rwxr-xr-x
index.php	3.93 KB	-rwxr-xr-x
log.php	1.1 KB	-rwxr-xr-x
login.php	5.74 KB	-rwxr-xr-x
logout.php	122 B	-rwxr-xr-x
news-coverage.php	4.04 KB	-rwxr-xr-x
news.php	4.15 KB	-rwxr-xr-x
pages.php	3.99 KB	-rwxr-xr-x
pdf.php	3.96 KB	-rwxr-xr-x
pwnkit	0 B	-rwxr-xr-x
register.php	2.97 KB	-rwxr-xr-x
shining-star.php	4.07 KB	-rwxr-xr-x
slide.php	3.9 KB	-rwxr-xr-x
tc.php	4.04 KB	-rwxr-xr-x
toppers.php	4.23 KB	-rwxr-xr-x
update-fee.php	4.37 KB	-rwxr-xr-x
update-news.php	2.78 KB	-rwxr-xr-x
update-pages.php	2.78 KB	-rwxr-xr-x

Code Editor : news.php

<?php include('header.php');?>

<div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        News
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li><a href="#">News</a></li>
        <li class="active">View</li>
      </ol>
    </section>

<div class="callout callout-info">
        <h4>Tip!</h4>

<p>This page will show you all the news upload by the user.</p>
      </div>
      
	  
	  <a href='add-news.php' class="btn btn-info" style="margin-left: 15px;">Add News</a><br>
    
      <?php
      
		if (isset($_GET['pageno'])) {
            $pageno = $_GET['pageno'];
        } else {
            $pageno = 1;
        }
        $no_of_records_per_page = 10;
        $offset = ($pageno-1) * $no_of_records_per_page;
		
		$total_pages_sql = "SELECT COUNT(*) FROM news WHERE status='active'";
        $result = mysqli_query($mysql_con, $total_pages_sql);
        $total_rows = mysqli_fetch_array($result)[0];
        $total_pages = ceil($total_rows / $no_of_records_per_page);

$sql = "SELECT * FROM news WHERE status= 'active' LIMIT $offset, $no_of_records_per_page";
		$result = mysqli_query($mysql_con, $sql);
		
	  
      
      if (isset($_GET['delete_id'])){
        $page_id = $_GET['delete_id'];
        $sql = "UPDATE news SET status='inactive' WHERE id = '$page_id' ";
        $query = mysqli_query($mysql_con, $sql);
        header ('location: news.php');
      } 
	  
	  $counter=$offset+1;
	  ?>

<section class="content">
      <div class="row">
        <div class="col-xs-12">

<div class="box">
            <div class="box-header">
              <h3 class="box-title">Data Table With Full Features</h3>
            </div>
            
            <div class="box-body">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>Sr.No.</th>
                  <th>Title</th>
                  <th>Description</th>
                  <th>Date & Time</th>	
				  <th> Photo </th>
                  <th>Action</th>
                </tr>
                </thead>
                <tbody>
                 <?php 
                 $sr_no = 1;
                  while($row = mysqli_fetch_array($result))
                  {?>
                     
                <tr>
                  <td><?php echo $counter++; ?></td>
                  <td><?php echo $row['title'] ; ?></td>
                  <td><?php echo substr ($row['detail'],0,100) ; ?></td>
                  <td><?php echo $row['date_time']; ?></td>	
				  <td><img width="100" height="100" src="../myadmin/photo/<?php echo $row['photo'] ;?>"></td>
                  <td>
                    <a href='update-news.php?edit_id=<?php echo $row["id"] ; ?>' class="btn btn-info">Edit</a>&nbsp;&nbsp;
                    <a href="news.php?delete_id=<?php echo $row["id"] ; ?> " class="btn btn-danger">Delete</a>
                  </td>
                </tr>
                <?php $sr_no ++;
                  }?>

</tbody>

</table>
            </div>
            
			
			<ul class="pagination">
				<li><a href="?pageno=1">First</a></li>
				<li class="<?php if($pageno <= 1){ echo 'disabled'; } ?>">
					<a href="<?php if($pageno <= 1){ echo '#'; } else { echo "?pageno=".($pageno - 1); } ?>">Prev</a>
				</li>
				<li class="<?php if($pageno >= $total_pages){ echo 'disabled'; } ?>">
					<a href="<?php if($pageno >= $total_pages){ echo '#'; } else { echo "?pageno=".($pageno + 1); } ?>">Next</a>
				</li>
				<li><a href="?pageno=<?php echo $total_pages; ?>">Last</a></li>
			</ul>
			
          </div>
          
      
        
      </div>
      
    </section>
    
  </div>

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

${this.title}

Code Editor : news.php