API tools faq
paste
kuchuz

Tugas 9 PWEB-D list-siswa.php

kuchuz
Dec 31st, 2021
1,230
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.16 KB | None | 0 0
raw download clone embed print report
  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/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">
  8.     <script src="https://cdn.jsdelivr.net/npm/[email protected]/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/[email protected]/dist/umd/popper.min.js" integrity="sha384-7+zCNj/IqJ95wo16oMtfsKbZ9ccEh31eOz1HGyDuCQ6wgnyJNSYdrPa03rtR1zdB" crossorigin="anonymous"></script>
  10.     <script src="https://cdn.jsdelivr.net/npm/[email protected]/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; ?>
Advertisement
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!