korsygfhrfggfhfgfffgffg6655665dtggggggzangaiide
Elehhjhjjkjkfpf6df56fd65ffff
/
home2
/
sunpublicschools
/
public_html
/
SunShine_AdMin
/
Upload FileeE
HOME
<?php include 'header.php'; include 'config.php';?> <div class="content-wrapper"> <div class="card dashboard"> <div class="row"> <div class="col-md-12"> <div class="add_tittle"> <h4> <i class="fa fa-edit"></i> List of Addmission Form</h4> </div> </div> </div> <br> <div class="row"> <div class="col-md-12"> <div class="table-responsive show_product"> <table class="table table-striped table-bordered table-hover scrollTable" id="dataTables-example"> <tbody> <tr> <th>S.No.</th> <th>Student Name</th> <th>Gender</th> <th>Date of Birth</th> <th>Grade</th> <th>Father Name</th> <th>Mobile Number</th> <th>Email Id </th> <th>Branch </th> <th>View</th> <th>Delete</th> </tr> <?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 leads WHERE reg_type='homemaker' ";*/ $total_pages_sql = "SELECT COUNT(*) FROM addmission_form "; $result3 = mysqli_query($connect,$total_pages_sql); $row3 = mysqli_fetch_array($result3)[0]; $total_pages = ceil($row3 / $no_of_records_per_page); $query = "SELECT * from addmission_form ORDER BY id DESC LIMIT $offset, $no_of_records_per_page"; $res_data = mysqli_query($connect,$query); if(mysqli_num_rows($res_data) > 0 ){ $num= $offset+1; while($row= mysqli_fetch_array($res_data)) { $id = $row['id']; ?> <tr> <td> <?php echo $num; ?> </td> <td><?php echo $row['c_name'];?></td> <td><?php echo $row['c_birth'];?></td> <td><?php echo $row['gender'];?></td> <td><?php echo $row['grade'];?></td> <td><?php echo $row['p_name'];?></td> <td><?php echo $row['p_mobile'];?></td> <td><?php echo $row['p_email'];?></td> <td><?php echo $row['branch'];?></td> <td> <a href="edit_addmis_form.php?id=<?php echo $row['id'];?>"><button data-toggle="tooltip" title="Edit" class="btn btn-green btn-xs"><i class="fa fa-edit"></i></button></a> </td> <td> <a href="delete_addmis_form.php?id=<?php echo $row['id'];?>"><button data-toggle="tooltip" title="Delete" Onclick="return ConfirmDelete()" class="btn btn-danger btn-xs"><i class="fa fa-trash"></i></button></a> </td> </tr> <?php $num++; }} else{ ?> <tr><td align="center" colspan="6"><?php echo "No Data Available" ?></td></tr> <?php }?> </tbody> </table> </div> <?php if($num >10){ ?> <ul class="pagination pull-right"> <li class="active"><a href="?pageno=1">First<span class="sr-only">(current)</span></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 class="<?php if($pageno <= 1){ echo 'disabled'; } ?>"> <a href="<?php if($pageno <= 1){ echo '#'; } else { echo "?pageno=".$total_pages; } ?>">Last</a> <!-- <a href="?pageno=<?php echo $total_pages; ?>">Last</a> --> </li> </ul> <?php } ?> </div> </div> </div> </div> </div> <!-- Javascripts--> <script src="js/jquery-2.1.4.min.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/plugins/pace.min.js"></script> <script src="js/main.js"></script> <script> function ConfirmDelete() { return confirm("Are you Sure want to Move to Trash...?"); } </script>