Gecko [ sachasauda.akalacademy.ac.in ]

Name	Size	Permission
.well-known	[ DIR ]	drwxr-xr-x
cgi-bin	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
files	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
htdocs	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
myadmin	[ DIR ]	drwxr-xr-x
scss	[ DIR ]	drwxr-xr-x
style	[ DIR ]	drwxr-xr-x
uploads	[ DIR ]	drwxr-xr-x
.htaccess	77.11 KB	-rw-r--r--
.mad-root	0 B	-rw-r--r--
about.php	13.46 KB	-rw-r--r--
academic.php	10.42 KB	-rw-r--r--
addmission.php	1.76 KB	-rw-r--r--
cbse-corner.php	3.5 KB	-rw-r--r--
config.php	626 B	-rw-r--r--
contact.php	1.8 KB	-rw-r--r--
error_log	74.71 MB	-rw-r--r--
favicon.ico	2.56 KB	-rw-r--r--
footer.php	6.16 KB	-rw-r--r--
gallery.php	1.53 KB	-rw-r--r--
google775f527949bffa5f.html	53 B	-rw-r--r--
header.php	11 KB	-rw-r--r--
index.php	17.7 KB	-rw-r--r--
news-coverage.php	1.63 KB	-rw-r--r--
pedagogy.php	1.25 KB	-rw-r--r--
pwnkit	0 B	-rwxr-xr-x
result.php	1.29 KB	-rw-r--r--
shining-star.php	8.56 KB	-rw-r--r--
tc.php	3.14 KB	-rw-r--r--
theschool.php	4.28 KB	-rw-r--r--
toppers.php	5.37 KB	-rw-r--r--

Code Editor : tc.php

<?php include('header.php'); ?>
    
    <div class="site-section ftco-subscribe-1 site-blocks-cover pb-4" style="background-image: url('images/bg_1.jpg')">
        <div class="container">
          <div class="row align-items-end">
            <div class="col-lg-6">
              <h2 class="mb-0">Transfer Certificate</h2>
            </div>
			<div class="col-lg-6 text-right">
				<a href="index.php">Home</a>
				<span class="mx-3 icon-keyboard_arrow_right"></span>
				<span class="current">Transfer Certificate</span>
			</div>
          </div>
        </div>
    </div>

<?php
	 
		if (isset($_GET['pageno'])) {
            $pageno = $_GET['pageno'];
        } else {
            $pageno = 1;
        }
        $no_of_records_per_page = 50;
        $offset = ($pageno-1) * $no_of_records_per_page;
		
		$total_pages_sql = "SELECT COUNT(*) FROM tc WHERE status='active'";
        $result = mysqli_query($con, $total_pages_sql);
        $total_rows = mysqli_fetch_array($result)[0];
        $total_pages = ceil($total_rows / $no_of_records_per_page);
		
		$sql = "SELECT * FROM tc WHERE status= 'active' LIMIT $offset, $no_of_records_per_page";
		$result = mysqli_query($con, $sql);
	  
		$counter=$offset+1; 
    ?> 
	
    <div class="site-section">
      <div class="container">
        <div class="row justify-content-center text-center">
          <div class="col-lg-8">
            <h2 class="section-title-underline mb-5">
              <span>School Leaving Certificate of Candidates</span>
            </h2>
          </div>
        </div>
        <div class="row">
			<div class="col-lg-12">
			<table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>Sr.No.</th>
                  <th>Name of Student</th>
                  <th>Adm. No.</th>
                  <th>PDF</th>
                </tr>
                </thead>
                <tbody>
                 <?php 
                 $sr_no = 1;
                  while($row = mysqli_fetch_array($result))
                  {?>
                <tr>
                  <td><?php echo $sr_no ; ?></td>
                  <td><b><?php echo $row['title'] ; ?></b></td>		
                  <td><b><?php echo $row['add_no'] ; ?></b></td>		
                  <td>
                  <a target="_blank" href="../myadmin/tc/<?php echo $row['file'] ;?>" class="btn btn-info">View</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>
    </div>
	
	
	
<?php include('footer.php'); ?>

${this.title}

Code Editor : tc.php