madeslimacek6

CURD (Read) Tabel Jalur Masuk

Jan 4th, 2019
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.20 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.  
  12.   <!-- Rubah HTML dan juga pemanggilan scriptnya pada echo-->
  13.  
  14.   <H3> MASTER DATA JALUR MASUK  </H3>
  15.   <a href="#" class="btn btn-default btn-xs">CREATE</a>
  16.   <table border="1" cellpadding="10" cellspacing="0" >
  17.   <tr>
  18.   <td>No</td>
  19.   <td>ID Jalur Masuk</td>
  20.   <td>Nama Jalur Masuk</td>
  21.   <td>Publish</td>
  22.   <td>Aksi</td>
  23.   </tr>
  24.   <?php
  25.   while($baris = mysqli_fetch_array($hasil))
  26.   {
  27.   ?>
  28.   <tr>
  29.   <td><?php echo $i; ?></td>
  30.   <td><?php echo $baris['idjalurmasuk']; ?></td>
  31.   <td><?php echo $baris['nmjalurmasuk']; ?></td>
  32.   <td><?php echo $baris['publish']; ?></td>
  33.   <td>
  34.     <a href="#" class="btn btn-default btn-xs">UPDATE</a>
  35.     <a href="#" class="btn btn-default btn-xs">DELETE</a>
  36.   </td>
  37.   </tr>
  38.   <?php
  39.    $i++;  
  40.   }
  41.   ?>
  42.   </table>  
  43.    <?php
  44.   mysqli_free_result($hasil);
  45. }
  46.  
  47. function koneksidatabase()
  48. {
  49.     include('../koneksi/koneksi.php');
  50.     return $kdb;
  51. }
  52.  
  53. //rubah pemilihan tabelnya
  54. function sql_select()
  55. {
  56.   global $kdb;
  57.   $sql = " select * from jalurmasuk ";
  58.   $hasil = mysqli_query($kdb, $sql) or die(mysql_error());
  59.   return $hasil;
  60. }
  61. ?>
Advertisement
Add Comment
Please, Sign In to add comment