API tools faq
paste
Advertisement
kuchuz

Tugas 10 PWEB-D list-siswa.php

kuchuz
Dec 31st, 2021
1,222
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.51 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">Foto</th>
  33.                 <th scope="col">Nama</th>
  34.                 <th scope="col">Alamat</th>
  35.                 <th scope="col">Jenis Kelamin</th>
  36.                 <th scope="col">Agama</th>
  37.                 <th scope="col">Sekolah Asal</th>
  38.                 <th scope="col">Tindakan</th>
  39.             </tr>
  40.         </thead>
  41.         <tbody>
  42.  
  43.             <?php
  44.             $sql = "SELECT * FROM calon_siswa";
  45.             $query = mysqli_query($db, $sql);
  46.  
  47.             while($siswa = mysqli_fetch_array($query)){
  48.                 echo "<tr>";
  49.                 $size = getimagesize('foto/'.$siswa['foto']);
  50.                 echo "<td>".$siswa['id']."</td>";
  51.                 echo "<td><img src='".((isset($size[0]) && $size[0]>1 && isset($size[1]) && $size[1]>1)?"foto/".$siswa['foto']:"https://image.shutterstock.com/image-illustration/photo-silhouette-male-profile-white-260nw-1018631086.jpg")."' height='100px'/></td>";
  52.                 echo "<td>".$siswa['nama']."</td>";
  53.                 echo "<td>".$siswa['alamat']."</td>";
  54.                 echo "<td>".$siswa['jenis_kelamin']."</td>";
  55.                 echo "<td>".$siswa['agama']."</td>";
  56.                 echo "<td>".$siswa['sekolah_asal']."</td>";
  57.  
  58.                 echo "<td>";
  59.                 echo "<a href='form-edit.php?id=".$siswa['id']."'>Edit</a> | ";
  60.                 echo "<a href='hapus.php?id=".$siswa['id']."'>Hapus</a>";
  61.                 echo "</td>";
  62.  
  63.                 echo "</tr>";
  64.             }
  65.             ?>
  66.  
  67.         </tbody>
  68.         </table>
  69.         <center><a href="index.php" class="btn btn-primary">Kembali</a></center>
  70.         <!-- <p>Total: <?php echo mysqli_num_rows($query) ?></p> -->
  71.     </div>
  72.     </body>
  73. </html>
  74.  
  75. <?php if(isset($_GET['status'])): ?>
  76.     <p>
  77.         <?php
  78.             if($_GET['status'] == 'sukses'){
  79.                 echo "Pendaftaran siswa baru berhasil!";
  80.             } else {
  81.                 echo "Pendaftaran gagal!";
  82.             }
  83.         ?>
  84.     </p>
  85. <?php endif; ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!