Advertisement
rizkydwisaputro

Untitled

Mar 30th, 2020
380
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. <?php
  2. // koneksi ke database
  3. $conn = mysqli_connect("localhost", "root", "", "siswamusaba");
  4.  
  5. // ambil data dari tabel msiswamusaba / query data siswamusaba
  6.  
  7. $result = mysqli_query($conn, "SELECT * FROM  data siswa musaba");
  8. var_dump($result);
  9.  
  10. // ambil data siswamusaba (fetch) dari object result
  11. // mysqli_fetch_row()
  12. // mysqli_fetch_assoc()
  13. // mysqli_fetch_array()
  14. // mysqli_fetch_object()
  15.  
  16.  
  17. ?>
  18.  
  19. <!DOCTYPE html>
  20. <html>
  21. <head>
  22.     <title>Halaman Admin</title>
  23. </head>
  24. <body>
  25.  
  26. <h1>Daftar Siswa MUSABA</h1>
  27.  
  28. <table border="1" cellpadding="9" cellspacing="0">
  29.  
  30.     <tr>
  31.         <th>No.</th>
  32.         <th>ID</th>
  33.         <th>Gambar</th>
  34.         <th>Nama</th>
  35.         <th>Jurusan</th>
  36.         <th>Email</th>
  37.     </tr>
  38.  
  39.     <tr>
  40.         <td>1</td>
  41.         <td>2257</td>
  42.         <td><img src="img/boboiboy.jpg" width="100"></td>
  43.         <td>Muhammad Rizky Dwi Saputro</td>
  44.         <td>RPL</td>
  45.         <td>rizkydwi603@gmail.com</td>
  46.     </tr>
  47.    
  48. </table>
  49.  
  50. </body>
  51. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement