aibishal

✏️ Editing: popuplab.php

<?php
session_start();
$user = $_SESSION['username'];
$log = $_SESSION['admin'];
if ($log != "log"){
	header ("Location: login.php");
}
?>

<?php

include "sql.php";

$record_per_page = 40;
$page = '';
if(isset($_GET["page"]))
{
 $page = $_GET["page"];
}
else
{
 $page = 1;
}

$start_from = ($page-1)*$record_per_page;

//$query = "SELECT * FROM info WHERE groups = 'PHARMACEUTICAL SCIENCE' AND //position = 'Students' LIMIT $total_per_page OFFSET $offse";

//$$query = mysqli_query($con,"SELECT * FROM ");
 
 $result = mysqli_query($con,"SELECT * FROM info  WHERE position = 'Students'  ");
	
 
$counter = 1;
//$result = mysqli_query($con, $query);

<!DOCTYPE html>
<html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
     <title> Library</title>
     <link rel="stylesheet" type="text/css" href="css/style.css" />
   <style type="text/css" media="all"> 
    @import url("css/style.css");
  </style>
  <style>
  #page a {
   padding:8px 16px;
   border:1px solid #ccc;
   color:#333;
   font-weight:bold;
  }
  </style>
 </head>
 <body>
  
  <div id = "container">
  <?php
    include'header.php';
  ?>

<div id ="main_part">
<div class = "navbarr">
	   <ul>
	   <li><a href = "admin.php">Home</a></li>
	   <li></li>
	   <li><a href ="#">Options</a>
			      <ul>
				     <li><a href ="manage_user.php">Manage User</a></li>
					 <li><a href ="add_user.php">Add User</a></li>
					 <li><a href ="add_dep.php">Add Departments</a></li>
					 <li><a href ="view_dep.php">View Departments</a></li>
					 <li><a href ="uploaded_books_pharmacy_dep.php">Uploaded Books</a></li>
					 
				  </ul>
			   </li>
	   
	   <li><a href = "changepass.php"><img src = "images/my_account.png"
	   style="margin-right:3px;">Update password</img></a></li>
	   <li><a href = "index.php"><img  src = "images/logout.png"
	   style="margin-right:3px;">Logout</img></a></li>
	   </ul>
	</div>

<div id = "head">
<h2>BENEFICIARIES</h2>
</div>

<div style ="margin-top:2%; margin-left:2%; margin-bottom:2%; "> 
    <table align = "center"  width = "100%" cellpadding = "2" >
     <tr style = "background:blue;">
	 <th style = "color:white; font-size:14px;">Sno</th>
     <th align="center" style = "color:white; font-size:14px;"> Name</th>
	<th align="center" style = "color:white; font-size:14px;"> Registration Number</th>
	<th align="center" style = "color:white; font-size:14px;"> Date Of Birth</th>
	<th align="center" style = "color:white; font-size:14px;"> sex</th>
	<th align="center" style = "color:white; font-size:14px;"> Phone Number</th>
	<th align="center" style = "color:white; font-size:14px;">Output</th>	  
     </tr>
     <?php
$counter = 1;
while ($db_field = mysqli_fetch_array($result)) {
	$a = $db_field['username'];
	$c = $db_field['Registration No'];
	
	$d = $db_field['DOB'];
	$f = $db_field['sex'];
	$e = $db_field['phone No.'];
	$b = $db_field['groups'];
	print("<tr>");
	?>
	<tr style = 'background:#F6F4F0;'>
	<td align = "center" style = "font-size:14px;"> <?php echo $counter;?></td>
	<?php
	print("<td align = 'left' style = 'font-size:14px;'>$a</td>");
	print("<td align = 'left' style = 'font-size:14px;'>$c</td>");
	print("<td align = 'left' style = 'font-size:14px;'>$d</td>");
	print("<td align = 'left' style = 'font-size:14px;'>$f</td>");
	print("<td align = 'left' style = 'font-size:14px;'>$e</td>");
	print("<td align = 'left' style = 'font-size:14px;'>$b</td>");
	print("</tr>");
	$counter++;
}
?>
</tr>
</table>
    <div align="center">
    <br />
    <?php
    
   $page_query = mysqli_query($con,"SELECT * FROM info WHERE  position = 'Students' ");
    $total_records = mysqli_num_rows($page_query);
    
    ?>
	<div style ="  margin:1px;">
	   <p style ="text-align:left; margin-left:45px;color:black; font-size:16px;">
	   <?php echo $total_records;?>
	   <?php  echo 'Students Registered for this Course';?>
	   </p>
	</div>
	
	<?php
    
    $total_pages = ceil($total_records/$record_per_page);
    $start_loop = $page;
    $difference = $total_pages - $page;
    if($difference <= 5)
    {
     $start_loop = $total_pages - 5;
    }
	echo "<div id ='page'>";
    $end_loop = $start_loop + 4;
    if($page > 1)
    {
     echo "<a href='popuplab.php?page=1'>First</a>";
     echo "<a href='popuplab.php?page=".($page - 1)."'><<</a>";
    }
    for($i=$start_loop; $i<=$end_loop; $i++)
    {     
     echo "<a href='popuplab.php?page=".$i."'>".$i."</a>";
    }
    if($page <= $end_loop)
    {
     echo "<a href='popuplab.php?page=".($page + 1)."'>>></a>";
     echo "<a href='popuplab.php?page=".$total_pages."'>Last</a>";
    }
    echo "</div>";
    
    ?>
    </div>
    </div>
   </div>
   </div>
  <footer> 
    <P>&copy 2020 Danish Refugee Council - All Rights Reselved </p>
</footer>
  </div>
 </body>
</html>

Gifari Industries - BD Cyber Security Team