madeslimacek6

CURD (Read) Tabel TAHUN

Jan 4th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.18 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 judul dan tabelnya -->
  13.  
  14.   <H3> MASTER DATA TAHUN  </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 Tahun</td>
  20.   <td>Tahun</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.   <!--Rubah pemanggilannya-->
  30.   <td><?php echo $i; ?></td>
  31.   <td><?php echo $baris['idtahun']; ?></td>
  32.   <td><?php echo $baris['tahun']; ?></td>
  33.   <td><?php echo $baris['publish']; ?></td>
  34.   <td>
  35.     <a href="#" class="btn btn-default btn-xs">UPDATE</a>
  36.     <a href="#" class="btn btn-default btn-xs">DELETE</a>
  37.   </td>
  38.   </tr>
  39.   <?php
  40.    $i++;  
  41.   }
  42.   ?>
  43.   </table>  
  44.    <?php
  45.   mysqli_free_result($hasil);
  46. }
  47.  
  48. function koneksidatabase()
  49. {
  50.     include('../koneksi/koneksi.php');
  51.     return $kdb;
  52. }
  53.  
  54. //rubah fungsi untuk select ke tabel tahun
  55. function sql_select()
  56. {
  57.   global $kdb;
  58.   $sql = " select * from tahun ";
  59.   $hasil = mysqli_query($kdb, $sql) or die(mysql_error());
  60.   return $hasil;
  61. }
  62. ?>
Advertisement
Add Comment
Please, Sign In to add comment