CRUD 3 Membuat Halaman Utama

pada tanggal
CRUD 2 Membuat File config.php

Langkah ketiga kita akan membuat file index.php, code ini untuk menampilkan halaman utama proyek CRUD kita, dengan hasil render HTML

Membuat File index.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>Dashboard</title>
 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.js"></script>
 <style type="text/css">
  .wrapper{
   width: 650px;
   margin: 0 auto;
  }
  .page-header h2{
   margin-top: 0;
  }
  table tr td:last-child a{
   margin-right: 15px;
  }
 </style>
 <script type="text/javascript">
  $(document).ready(function(){
   $('[data-toggle="tooltip"]').tooltip();
  });
 </script>
</head>
<body>
 <div class="wrapper">
  <div class="container-fluid">
   <div class="row">
    <div class="col-md-12">
     <div class="page-header clearfix">
      <h2 class="pull-left">Informasi Pegawai</h2>
      <a href="create.php" class="btn btn-success pull-right">Tambah Baru</a>
     </div>
     <?php
     // Include config file
     require_once "config.php";

     // Attempt select query execution
     $sql = "SELECT * FROM employees";
     if($result = mysqli_query($link, $sql)){
      if(mysqli_num_rows($result) > 0){
       echo "<table class='table table-bordered table-striped'>";
        echo "<thead>";
         echo "<tr>";
          echo "<th>#</th>";
          echo "<th>Nama</th>";
          echo "<th>Alamat</th>";
          echo "<th>Salary</th>";
          echo "<th>Pengaturan</th>";
         echo "</tr>";
        echo "</thead>";
        echo "<tbody>";
        while($row = mysqli_fetch_array($result)){
         echo "<tr>";
          echo "<td>" . $row['id'] . "</td>";
          echo "<td>" . $row['nama'] . "</td>";
          echo "<td>" . $row['alamat'] . "</td>";
          echo "<td>" . $row['gaji'] . "</td>";
          echo "<td>";
           echo "<a href='read.php?id=". $row['id'] ."' title='View Record' data-toggle='tooltip'><span class='glyphicon glyphicon-eye-open'></span></a>";
           echo "<a href='update.php?id=". $row['id'] ."' title='Update Record' data-toggle='tooltip'><span class='glyphicon glyphicon-pencil'></span></a>";
           echo "<a href='delete.php?id=". $row['id'] ."' title='Delete Record' data-toggle='tooltip'><span class='glyphicon glyphicon-trash'></span></a>";
          echo "</td>";
         echo "</tr>";
        }
        echo "</tbody>";
       echo "</table>";
       // Free result set
       mysqli_free_result($result);
      } else{
       echo "<p class='lead'><em>No records were found.</em></p>";
      }
     } else{
      echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
     }

     // Close connection
     mysqli_close($link);
     ?>
    </div>
   </div>
  </div>
 </div>
</body>
</html>

Komentar

Posting Komentar