Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <!-- <title>Membuat CRUD Dengan PHP Dan MySQL - Menampilkan data dari database</title> -->
- <link rel="stylesheet" type="text/css" href="style.css">
- </head>
- <body>
- <div class="judul">
- <!-- <h1>Membuat CRUD Dengan PHP Dan MySQL</h1>
- <h2>Menampilkan data dari database</h2>
- <h3>www.malasngoding.com</h3> -->
- </div>
- <br/>
- <?php
- if(isset($_GET['pesan'])){
- $pesan = $_GET['pesan'];
- if($pesan == "input"){
- echo "Data berhasil di input.";
- }else if($pesan == "update"){
- echo "Data berhasil di update.";
- }else if($pesan == "hapus"){
- echo "Data berhasil di hapus.";
- }
- }
- ?>
- <br/>
- <a class="tombol" href="input.php">+ Tambah Data Baru</a>
- <h3>Data user</h3>
- <table border="1" class="table">
- <tr>
- <th>No</th>
- <th>Nama Perusahaan</th>
- <th>Nama Pegawai Perusahaan</th>
- <th>Alamat Perusahaan</th>
- <th>Alamat Pegawai Perusahaan</th>
- <th>Nomor Handphone</th>
- <th>Email</th>
- <th>Jumlah Pinjaman</th>
- <th>Bunga</th>
- <th>Tenor</th>
- <th>Opsi</th>
- </tr>
- <?php
- include "koneksi.php";
- $sql = "SELECT * FROM daftar_piutang";
- $result = $conn->query($sql);
- $nomor = 1;
- $data = [];
- while($row = $result->fetch_assoc()){
- $data[] = $row;
- }
- foreach($data as $item) { ?>
- <tr>
- <td><?php echo $nomor++; ?></td>
- <td><?php echo $item['nama_perusahaan']; ?></td>
- <td><?php echo $item['nama_pegawai']; ?></td>
- <td><?php echo $item['alamat']; ?></td>
- <td><?php echo $item['no_telepon']; ?></td>
- <td><?php echo $item['email']; ?></td>
- <td><?php echo $item['jumlah_pinjaman']; ?></td>
- <td><?php echo $item['bunga']; ?></td>
- <td><?php echo $item['tenor']; ?></td>
- <td>
- <a class="edit" href="edit.php?id=<?php echo $item['id']; ?>">Edit</a> |
- <a class="hapus" href="hapus.php?id=<?php echo $item['id']; ?>">Hapus</a>
- </td>
- </tr>
- <?php } ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement