document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <?php include("config.php"); ?>
  2.  
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6.     <title>Pendaftaran Siswa Baru | SMK Coding</title>
  7.     <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">
  8.     <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p" crossorigin="anonymous"></script>
  9.     <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.10.2/dist/umd/popper.min.js" integrity="sha384-7+zCNj/IqJ95wo16oMtfsKbZ9ccEh31eOz1HGyDuCQ6wgnyJNSYdrPa03rtR1zdB" crossorigin="anonymous"></script>
  10.     <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.min.js" integrity="sha384-QJHtvGhmr9XOIpI6YVutG+2QOK9T+ZnN4kzFN1RtK3zEFEIsxhlmWl5/YESvpZ13" crossorigin="anonymous"></script>
  11.     <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  12. </head>
  13.  
  14. <body>
  15.     <div class="container">
  16.         <header>
  17.             <center>
  18.             <h3>Siswa yang sudah mendaftar</h3>
  19.             </center>
  20.         </header>
  21.  
  22.         <nav>
  23.             <a href="form-daftar.php" class="btn btn-secondary"><i class="fa fa-plus"></i> Tambah Data Baru</a>
  24.         </nav>
  25.  
  26.         <br>
  27.  
  28.         <table class="table">
  29.         <thead class="thead-dark">
  30.             <tr>
  31.                 <th scope="col">No</th>
  32.                 <th scope="col">Nama</th>
  33.                 <th scope="col">Alamat</th>
  34.                 <th scope="col">Jenis Kelamin</th>
  35.                 <th scope="col">Agama</th>
  36.                 <th scope="col">Sekolah Asal</th>
  37.                 <th scope="col">Tindakan</th>
  38.             </tr>
  39.         </thead>
  40.         <tbody>
  41.  
  42.             <?php
  43.             $sql = "SELECT * FROM calon_siswa";
  44.             $query = mysqli_query($db, $sql);
  45.  
  46.             while($siswa = mysqli_fetch_array($query)){
  47.                 echo "<tr>";
  48.  
  49.                 echo "<td>".$siswa[\'id\']."</td>";
  50.                 echo "<td>".$siswa[\'nama\']."</td>";
  51.                 echo "<td>".$siswa[\'alamat\']."</td>";
  52.                 echo "<td>".$siswa[\'jenis_kelamin\']."</td>";
  53.                 echo "<td>".$siswa[\'agama\']."</td>";
  54.                 echo "<td>".$siswa[\'sekolah_asal\']."</td>";
  55.  
  56.                 echo "<td>";
  57.                 echo "<a href=\'form-edit.php?id=".$siswa[\'id\']."\'>Edit</a> | ";
  58.                 echo "<a href=\'hapus.php?id=".$siswa[\'id\']."\'>Hapus</a>";
  59.                 echo "</td>";
  60.  
  61.                 echo "</tr>";
  62.             }
  63.             ?>
  64.  
  65.         </tbody>
  66.         </table>
  67.         <center><a href="index.php" class="btn btn-primary">Kembali</a></center>
  68.         <!-- <p>Total: <?php echo mysqli_num_rows($query) ?></p> -->
  69.     </div>
  70.     </body>
  71. </html>
  72.  
  73. <?php if(isset($_GET[\'status\'])): ?>
  74.     <p>
  75.         <?php
  76.             if($_GET[\'status\'] == \'sukses\'){
  77.                 echo "Pendaftaran siswa baru berhasil!";
  78.             } else {
  79.                 echo "Pendaftaran gagal!";
  80.             }
  81.         ?>
  82.     </p>
  83. <?php endif; ?>
');