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
pdf	[ DIR ]	drwxr-xr-x
photo	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
slider	[ DIR ]	drwxr-xr-x
sym	[ DIR ]	drwxr-xr-x
video	[ DIR ]	drwxr-xr-x
.htaccess	197 B	-r--r--r--
Gruntfile.js	6.85 KB	-rwxr-xr-x
add-album.php	1.75 KB	-rw-r--r--
add-cbse-corner.php	2.18 KB	-rw-r--r--
add-fee.php	3.9 KB	-rw-r--r--
add-gallery.php	3.1 KB	-rw-r--r--
add-news.php	2.68 KB	-rw-r--r--
add-pages.php	2.17 KB	-rw-r--r--
add-pdf.php	2.19 KB	-rw-r--r--
add-slide.php	2.22 KB	-rw-r--r--
album.php	3.98 KB	-rw-r--r--
cbse-corner.php	4.03 KB	-rw-r--r--
config.php	732 B	-rw-r--r--
error_log	13.24 KB	-rw-r--r--
fee.php	2.98 KB	-rw-r--r--
footer.php	8.81 KB	-rw-r--r--
gallery.php	4.1 KB	-rw-r--r--
header.php	9.42 KB	-rw-r--r--
index.php	3.93 KB	-rw-r--r--
log.php	1.15 KB	-rw-r--r--
login.php	5.74 KB	-rw-r--r--
logout.php	132 B	-rw-r--r--
news.php	4.29 KB	-rw-r--r--
pages.php	3.99 KB	-rw-r--r--
pdf.php	4.09 KB	-rw-r--r--
register.php	3.09 KB	-rw-r--r--
slide.php	4.03 KB	-rw-r--r--
update-fee.php	4.51 KB	-rw-r--r--
update-news.php	2.96 KB	-rw-r--r--
update-pages.php	2.78 KB	-rw-r--r--

Code Editor : pages.php

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

<div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        Pages
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li><a href="#">Pages</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 pages data upload by the user.</p>
      </div>
      
    
	 <a href='add-pages.php' class="btn btn-info" style="margin-left: 15px;">Add Page</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 pages 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 pages 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 pages SET status='inactive' WHERE id = '$page_id' ";
        $query = mysqli_query($mysql_con, $sql);
        header ('location: pages.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>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  strip_tags(substr($row['description'],0,150)); ?>..</td>
                  <td>
                    <a href="update-pages.php?edit_id=<?php echo $row["id"] ; ?> " class="btn btn-info">Edit</a>&nbsp;&nbsp;
                    <a href="pages.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 : pages.php