madeslimacek6

CURD (Read) Tabel USER

Jan 4th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.19 KB | None | 0 0
  1. <?php
  2. $kdb = koneksidatabase();
  3. curd_read();
  4.  
  5. function curd_read()
  6. {
  7.  
  8.   $hasil = sql_select();
  9.   $i=1;
  10.   ?>
  11. <!--Rubah HTML Menampilkan datanya serta pemanggilan fungsi php nya-->
  12.   <H3> MASTER DATA USER AKUN  </H3>
  13.   <a href="#" class="btn btn-default btn-xs">CREATE</a>
  14.   <table border="1" cellpadding="10" cellspacing="0" >
  15.   <tr>
  16.   <td>No</td>
  17.   <td>ID</td>
  18.   <td>Username</td>
  19.   <td>Publish</td>
  20.   <td>Aksi</td>
  21.   </tr>
  22.   <?php
  23.   while($baris = mysqli_fetch_array($hasil))
  24.   {
  25.   ?>
  26.   <tr>
  27.   <td><?php echo $i; ?></td>
  28.   <td><?php echo $baris['iduser']; ?></td>
  29.   <td><?php echo $baris['nmuser']; ?></td>
  30.   <td><?php echo $baris['publish']; ?></td>
  31.   <td>
  32.     <a href="#" class="btn btn-default btn-xs">UPDATE</a>
  33.     <a href="#" class="btn btn-default btn-xs">DELETE</a>
  34.   </td>
  35.   </tr>
  36.   <?php
  37.    $i++;  
  38.   }
  39.   ?>
  40.   </table>  
  41.    <?php
  42.   mysqli_free_result($hasil);
  43. }
  44.  
  45. function koneksidatabase()
  46. {
  47.     include('../koneksi/koneksi.php');
  48.     return $kdb;
  49. }
  50.  
  51. //Rubah fungsi untuk memamanggil ke tabel user
  52. function sql_select()
  53. {
  54.   global $kdb;
  55.   $sql = " select * from user ";
  56.   $hasil = mysqli_query($kdb, $sql) or die(mysql_error());
  57.   return $hasil;
  58. }
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment