D0R4H4X0R SH3LL

Current File : D:/INETPUB/VHOSTS/lensai.com/httpdocs/admin/subscriber_list.php

<div>
      <!-- Content Wrapper. Contains page content -->
    <div>
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>Subscriber List</h1>
          <ol class="breadcrumb">
            <li><a href="index.php"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">Subscriber List</li>
          </ol>
        </section>
		<?php
		$Select="select * from subscriber";
		$run=mysqli_query($con,$Select);
		?>
        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-md-12">
              <div class="box box-primary">
                
                <div class="box-body no-padding">
                  <div class="mailbox-controls">
                    <!-- Check all button -->
					<?php
					$rec_limit = 1000;
					$tbl_name="subscriber";		//your table name
					// How many adjacent pages should be shown on each side?
					$adjacents = 100;
					
					/* 
					   First get total number of rows in data table. 
					   If you have a WHERE clause in your query, make sure you mirror it here.
					*/
					$query = "SELECT COUNT(*) as num FROM $tbl_name";
					$exe=mysqli_query($con,$query);
					$total_pages=mysqli_fetch_array($exe);
					$total_pages = $total_pages['num'];
					
					/* Setup vars for query. */
					$targetpage = "index.php?p=subscriber_list"; 	//your file name  (the name of this file)
					$limit = 15; 								//how many items to show per page
					$page = $_GET['page'];
					if($page) 
						$start = ($page - 1) * $limit; 			//first item to display on this page
					else
						$start = 0;								//if no page var is given, set start to 0
					
					/* Get data. */
					$sql = "SELECT * FROM $tbl_name LIMIT $start, $limit";
					$exe=mysqli_query($con,$sql);
					$result=mysqli_fetch_array($exe);
					
					/* Setup page vars for display. */
					if ($page == 0) $page = 1;					//if no page var is given, default to 1.
					$prev = $page - 1;							//previous page is page - 1
					$next = $page + 1;							//next page is page + 1
					$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
					$lpm1 = $lastpage - 1;						//last page minus 1
					
					
					
					?>

					
					<div class="box-tools pull-right">
						<ul class="pagination pagination-sm inline">
						  <?php
							$pagination = "";
							if($lastpage > 1)
							{	
								
								//previous button
								if ($page > 1) 
									$pagination.= "<a class=\"btn btn-default btn-sm\" href=\"$targetpage&page=$prev\"> &laquo;</a>&nbsp;";
								else
									$pagination.= "<span class=\"btn btn-default btn-sm\"> &laquo;</span>&nbsp;";	
								
								//pages	
								if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
								{	
									for ($counter = 1; $counter <= $lastpage; $counter++)
									{
										if ($counter == $page)
											$pagination.= "<span class=\"btn btn-primary btn-sm\">$counter</span>&nbsp;";
										else
											$pagination.= "<a class=\"btn btn-default btn-sm\" href=\"$targetpage&page=$counter\">$counter</a>&nbsp;";					
									}
								}
								
								//next button
								if ($page < $counter - 1) 
									$pagination.= "<a class=\"btn btn-default btn-sm\" href=\"$targetpage&page=$next\"> &raquo;</a>";
								else
									$pagination.= "<span class=\"btn btn-default btn-sm\"> &raquo;</span>";		
							}
						  ?>
						</ul>	
					</div>
                  </div>
                  
				  <div class="table-responsive mailbox-messages">
                    <table class="table table-hover table-striped">
							<tbody>
								<tr class="table_border">
									<td>Select</td>
									<td>Name</td>
									<!--<td>Second Img</td>-->
									<td>Email</td>
									<td>Date</td>
									
									<td>Action</td>
									
								</tr>
	
								<?php
								$sql = "SELECT * FROM $tbl_name LIMIT $start, $limit";
								$exe=mysqli_query($con,$sql);
								while($row=mysqli_fetch_array($exe)){?>
								<tr>  
									<td><input type="checkbox" /></td>
									<td><?php echo $row ['name']; ?></td>
									<td><?php echo $row ['email']; ?></td>
									<td class="mailbox-name"><?php  echo date('F-d-Y', strtotime($row['date'])); ?></td>
									<td>
									<a href="controller.php?subscriberid=<?php echo $row['id'];?>"><img src="images/delet.png" height="20px"/></a>
									</td>
								</tr>
								<?php } ?>
								<?=$pagination?>
							</tbody>
                    </table>
					<!-- /.table -->
                  </div>
				  <!-- /.mail-box-messages -->
				  
                </div><!-- /.box-body -->
              </div><!-- /. box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
    </div><!-- /.content-wrapper -->
	
	
	
      
            <!-- Add the sidebar's background. This div must be placed
           immediately after the control sidebar -->
      <div class='control-sidebar-bg'></div>
    </div><!-- ./wrapper -->

    <!-- jQuery 2.1.4 -->
    <script src="plugins/jQuery/jQuery-2.1.4.min.js"></script>
    <!-- Bootstrap 3.3.2 JS -->
    <script src="../../bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
    <!-- Slimscroll -->
    <script src="../../plugins/slimScroll/jquery.slimscroll.min.js" type="text/javascript"></script>
    <!-- FastClick -->
    <script src='../../plugins/fastclick/fastclick.min.js'></script>
    <!-- AdminLTE App -->
    <script src="../../dist/js/app.min.js" type="text/javascript"></script>    
    <!-- iCheck -->
    <script src="../../plugins/iCheck/icheck.min.js" type="text/javascript"></script>
    <!-- Page Script -->
    <script>
      $(function () {
        //Enable iCheck plugin for checkboxes
        //iCheck for checkbox and radio inputs
        $('.mailbox-messages input[type="checkbox"]').iCheck({
          checkboxClass: 'icheckbox_flat-blue',
          radioClass: 'iradio_flat-blue'
        });

        //Enable check and uncheck all functionality
        $(".checkbox-toggle").click(function () {
          var clicks = $(this).data('clicks');
          if (clicks) {
            //Uncheck all checkboxes
            $(".mailbox-messages input[type='checkbox']").iCheck("uncheck");
            $(".fa", this).removeClass("fa-check-square-o").addClass('fa-square-o');
          } else {
            //Check all checkboxes
            $(".mailbox-messages input[type='checkbox']").iCheck("check");
            $(".fa", this).removeClass("fa-square-o").addClass('fa-check-square-o');
          }          
          $(this).data("clicks", !clicks);
        });

        //Handle starring for glyphicon and font awesome
        $(".mailbox-star").click(function (e) {
          e.preventDefault();
          //detect type
          var $this = $(this).find("a > i");
          var glyph = $this.hasClass("glyphicon");
          var fa = $this.hasClass("fa");

          //Switch states
          if (glyph) {
            $this.toggleClass("glyphicon-star");
            $this.toggleClass("glyphicon-star-empty");
          }

          if (fa) {
            $this.toggleClass("fa-star");
            $this.toggleClass("fa-star-o");
          }
        });
      });
    </script>
    
    <!-- AdminLTE for demo purposes -->
    <script src="dist/js/demo.js" type="text/javascript"></script>