API tools faq
paste
Suwandiaminsangaji

Data_Pelajar

Suwandiaminsangaji
Aug 16th, 2022
37
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 10.26 KB | None | 0 0
raw download clone embed print report
  1.  <?php
  2.   session_start();
  3.   error_reporting(1);
  4.   include '../config/koneksi.php';
  5.   ob_start();
  6.   if (trim($_SESSION['leveluser'])=='')
  7.   {
  8.     echo "<script>document.location='../';</script>";
  9.   }
  10. ?>
  11. <!DOCTYPE html>
  12. <html>
  13. <head>
  14.   <meta charset="utf-8">
  15.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  16.   <?php $r=mysqli_fetch_array(mysqli_query($koneksi, "SELECT * FROM identitas WHERE id = '1'")); ?>
  17.   <link rel="shortcut icon" href="../img/<?php echo "$r[gambar]";?>">
  18.   <title style="text-transform: uppercase;"><?php echo "$r[title]";?></title>
  19. <!-- Tell the browser to be responsive to screen width -->
  20.   <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  21.   <!-- Bootstrap 3.3.6 -->
  22.   <link rel="stylesheet" href="../bootstrap/css/bootstrap.min.css">
  23.   <!-- Font Awesome -->
  24.   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">
  25.   <!-- Ionicons -->
  26.   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">
  27.   <!-- daterange picker -->
  28.   <link rel="stylesheet" href="../plugins/daterangepicker/daterangepicker.css">
  29.   <!-- bootstrap datepicker -->
  30.   <link rel="stylesheet" href="../plugins/datepicker/datepicker3.css">
  31.   <!-- iCheck for checkboxes and radio inputs -->
  32.   <link rel="stylesheet" href="../plugins/iCheck/all.css">
  33.   <!-- Bootstrap Color Picker -->
  34.   <link rel="stylesheet" href="../plugins/colorpicker/bootstrap-colorpicker.min.css">
  35.   <!-- Bootstrap time Picker -->
  36.   <link rel="stylesheet" href="../plugins/timepicker/bootstrap-timepicker.min.css">
  37.   <!-- Select2 -->
  38.   <link rel="stylesheet" href="../plugins/select2/select2.min.css">
  39.   <!-- Theme style -->
  40.   <link rel="stylesheet" href="../dist/css/AdminLTE.min.css">
  41.   <!-- AdminLTE Skins. Choose a skin from the css/skins
  42.        folder instead of downloading all of them to reduce the load. -->
  43.   <link rel="stylesheet" href="../dist/css/skins/_all-skins.min.css">
  44.   <!-- DataTables -->
  45.   <link rel="stylesheet" href="../plugins/datatables/dataTables.bootstrap.css">
  46.   <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  47.   <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  48.   <!--[if lt IE 9]>
  49.   <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  50.   <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  51.   <![endif]-->
  52. </head>
  53. <body class="hold-transition skin-blue " data-spy="scroll" data-target="#scrollspy">
  54. <div class="wrapper">
  55.   <!-- Star menu -->
  56.   <?php include "menu.php";?>
  57.   <!-- End menu -->
  58.  
  59.   <!-- Star content -->
  60.   <div class="content-wrapper">
  61.     <!-- Content Header (Page header) -->
  62.     <section class="content-header">
  63.       <h1>
  64.         Pengaturan
  65.         <small>Control panel</small>
  66.       </h1>
  67.       <ol class="breadcrumb">
  68.         <li><a href="home"><i class="fa fa-dashboard"></i> Home</a></li>
  69.         <li class="active">Tabel Data Pelajar</li>
  70.       </ol>
  71.     </section>
  72.  
  73.     <!-- Main content -->
  74.     <section class="content">
  75.       <!-- Small boxes (Stat box) -->
  76.       <div class="row">
  77.         <div class="col-md-12">
  78.           <div class="box box-info">
  79.             <div class="box-header">
  80.               <h3 class="box-title"><i class="fa fa-table"></i> Tabel Data Pelajar</h3>
  81.             </div>
  82.             <!-- /.box-header -->
  83.             <div class='table-responsive'>
  84.               <div class="box-body">
  85.                 <table id="example1" class="table table-bordered table-striped table-hover">
  86.                   <thead class="bg-aqua">
  87.                     <tr>
  88.                       <th width="10"><center>No.</center></th>
  89.                       <th>NIS</th>
  90.                       <th>NISN</th>
  91.                       <th>Nama Lengkap</th>
  92.                       <th>JK</th>
  93.                       <th>FOTO</th>
  94.                       <th>Aksi</th>
  95.                     </tr>
  96.                   </thead>
  97.                   <tbody>
  98.                     <?php
  99.                     $tampil = mysqli_query($koneksi, "SELECT * FROM users WHERE level='user' ORDER BY nis DESC");
  100.                     $no=1;
  101.                     while ($rr=mysqli_fetch_array($tampil))
  102.                     {
  103.                     ?>
  104.                     <tr>
  105.                       <td><center><?php echo "$no.";?></center></td>
  106.                       <td><?php echo $rr["nis"];?></td>
  107.                       <td><?php echo $rr["nisn"];?></td>
  108.                       <td><?php echo $rr["nama_lengkap"];?></td>
  109.                       <td><?php echo $rr["jk"];?></td>
  110.                       <td align="center"><img class="img-responsive img-circle img-thumbnail" alt="Responsive image" src="../img/<?php echo "$rr[gambar]";?>" width="50px"></td>
  111.                       <td><center>
  112.                         <a class='btn btn-primary btn-xs' data-toggle='tooltip' title='Ubah Data' href='updatepelajar?id=<?php echo $rr["id_session"];?>'><span class='glyphicon glyphicon-edit'></span></a>
  113.                         <a class='btn btn-danger btn-xs' data-toggle='tooltip' title='Hapus Data' href='deletepelajar?id=<?php echo $rr["id_session"];?>' onclick="return confirm('Apa anda yakin akan menghapus data ini?')"><span class='glyphicon glyphicon-remove'></span></a></center>
  114.                       </td>
  115.                     <?php  $no++; } ?>
  116.                     </tr>
  117.                   </tbody>
  118.                 </table>
  119.               </div>
  120.             </div>
  121.             <!-- /.box-body -->
  122.           </div>
  123.         </div>
  124.       </div>
  125.     </section>
  126.     <!-- /.content -->
  127.   </div>
  128. <!-- End content -->
  129.  
  130.  
  131.  
  132.   <!-- Start footer -->
  133.   <?php include "footer.php";?>
  134.   <!-- End footer -->
  135.   <!-- Add the sidebar's background. This div must be placed
  136.        immediately after the control sidebar -->
  137.   <div class="control-sidebar-bg"></div>
  138. </div>
  139. <!-- ./wrapper -->
  140.  
  141. <!-- jQuery 2.2.3 -->
  142. <script src="../plugins/jQuery/jquery-2.2.3.min.js"></script>
  143. <!-- Bootstrap 3.3.6 -->
  144. <script src="../bootstrap/js/bootstrap.min.js"></script>
  145. <script src="../bootstrap/js/docs.js"></script>
  146. <!-- Select2 -->
  147. <script src="../plugins/select2/select2.full.min.js"></script>
  148. <!-- InputMask -->
  149. <script src="../plugins/input-mask/jquery.inputmask.js"></script>
  150. <script src="../plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
  151. <script src="../plugins/input-mask/jquery.inputmask.extensions.js"></script>
  152. <!-- date-range-picker -->
  153. <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.11.2/moment.min.js"></script>
  154. <script src="../plugins/daterangepicker/daterangepicker.js"></script>
  155. <!-- bootstrap datepicker -->
  156. <script src="../plugins/datepicker/bootstrap-datepicker.js"></script>
  157. <!-- bootstrap color picker -->
  158. <script src="../plugins/colorpicker/bootstrap-colorpicker.min.js"></script>
  159. <!-- bootstrap time picker -->
  160. <script src="../plugins/timepicker/bootstrap-timepicker.min.js"></script>
  161. <!-- SlimScroll 1.3.0 -->
  162. <script src="../plugins/slimScroll/jquery.slimscroll.min.js"></script>
  163. <!-- iCheck 1.0.1 -->
  164. <script src="../plugins/iCheck/icheck.min.js"></script>
  165. <!-- FastClick -->
  166. <script src="../plugins/fastclick/fastclick.js"></script>
  167. <!-- AdminLTE App -->
  168. <script src="../dist/js/app.min.js"></script>
  169. <!-- AdminLTE for demo purposes -->
  170. <script src="../dist/js/demo.js"></script>
  171. <!-- DataTables -->
  172. <script src="../plugins/datatables/jquery.dataTables.min.js"></script>
  173. <script src="../plugins/datatables/dataTables.bootstrap.min.js"></script>
  174. <!-- Page script -->
  175. <script>
  176.   $(function () {
  177.     //Initialize Select2 Elements
  178.     $(".select2").select2();
  179.  
  180.     //Datemask dd/mm/yyyy
  181.     $("#datemask").inputmask("dd/mm/yyyy", {"placeholder": "dd/mm/yyyy"});
  182.     //Datemask2 mm/dd/yyyy
  183.     $("#datemask2").inputmask("mm/dd/yyyy", {"placeholder": "mm/dd/yyyy"});
  184.     $("#datemask2").inputmask("bb/hh/yyyy", {"placeholder": "bb/hh/yyyy"});
  185.     //Money Euro
  186.     $("[data-mask]").inputmask();
  187.  
  188.     //Date range picker
  189.     $('#reservation').daterangepicker();
  190.     //Date range picker with time picker
  191.     $('#reservationtime').daterangepicker({timePicker: true, timePickerIncrement: 30, format: 'MM/DD/YYYY h:mm A'});
  192.     //Date range as a button
  193.     $('#daterange-btn').daterangepicker(
  194.         {
  195.           ranges: {
  196.             'Today': [moment(), moment()],
  197.             'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
  198.             'Last 7 Days': [moment().subtract(6, 'days'), moment()],
  199.             'Last 30 Days': [moment().subtract(29, 'days'), moment()],
  200.             'This Month': [moment().startOf('month'), moment().endOf('month')],
  201.             'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
  202.           },
  203.           startDate: moment().subtract(29, 'days'),
  204.           endDate: moment()
  205.         },
  206.         function (start, end) {
  207.           $('#daterange-btn span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
  208.         }
  209.     );
  210.  
  211.     //Date picker
  212.     $('#datepicker').datepicker({
  213.       autoclose: true
  214.     });
  215.  
  216.     //iCheck for checkbox and radio inputs
  217.     $('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
  218.       checkboxClass: 'icheckbox_minimal-blue',
  219.       radioClass: 'iradio_minimal-blue'
  220.     });
  221.     //Red color scheme for iCheck
  222.     $('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
  223.       checkboxClass: 'icheckbox_minimal-red',
  224.       radioClass: 'iradio_minimal-red'
  225.     });
  226.     //Flat red color scheme for iCheck
  227.     $('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
  228.       checkboxClass: 'icheckbox_flat-green',
  229.       radioClass: 'iradio_flat-green'
  230.     });
  231.  
  232.     //Colorpicker
  233.     $(".my-colorpicker1").colorpicker();
  234.     //color picker with addon
  235.     $(".my-colorpicker2").colorpicker();
  236.  
  237.     //Timepicker
  238.     $(".timepicker").timepicker({
  239.       showInputs: false
  240.     });
  241.   });
  242. </script>
  243. <script>
  244.   $(function () {
  245.     $("#example1").DataTable();
  246.     $('#example2').DataTable({
  247.       "paging": true,
  248.       "lengthChange": false,
  249.       "searching": false,
  250.       "ordering": true,
  251.       "info": true,
  252.       "autoWidth": false
  253.     });
  254.   });
  255. </script>
  256. </body>
  257. </html>
  258.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!