Advertisement
Guest User

Untitled

a guest
Mar 31st, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1.  
  2.  
  3.  
  4. <!-- <?php
  5. //membuat koneksi ke database
  6. $host = 'localhost';
  7. $user = 'root';
  8. $password = '';
  9. $database = 'attendance_system';
  10.  
  11. $konek_db = mysqli_connect($host, $user, $password);
  12. $find_db = mysqli_select_db($database) ;
  13. ?>-->
  14. <div class="table-responsive">
  15. <table class="table table-striped table-bordered table-condensed">
  16. <caption><em>Tabel Daftar Mahasiswa</em></caption>
  17. <thead>
  18. <tr> <th>NIM</th> <th>Nama</th> <th>Jenis Kelamin</th> <th>Fakultas</th> <th> Program Studi</th> </tr>
  19. </thead>
  20. <tbody>
  21. <?php
  22. // Perintah untuk menampilkan data
  23. $queri="SELECT NIM, Nama, jenis_kelamin, nama_fakultas, nama_jurusan FROM mahasiswa, fakultas, jurusan WHERE mahasiswa.id_fakultas = fakultas.id_fakultas and mahasiswa.id_jurusan = jurusan.id_jurusan " ; //menampikan SEMUA data dari tabel siswa
  24.  
  25. $hasil=MySQLi_query ($queri);
  26. MySQLi_query ($queri); //fungsi untuk SQL
  27.  
  28. // perintah untuk membaca dan mengambil data dalam bentuk array
  29. while ($data = mysqli_fetch_array ($hasil)){
  30. //$id = $data['id'];
  31. echo "
  32. <tr>
  33. <td>".$data['NIM']."</td>
  34. <td>".$data['Nama']."</td>
  35. <td>".$data['jenis_kelamin']."</td>
  36. <td>".$data['nama_fakultas']."</td>
  37. <td>".$data['nama_jurusan']."</td>
  38. </tr>
  39. ";
  40.  
  41. }
  42.  
  43. ?>
  44. </tbody>
  45. </table>
  46. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement