Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>CRUD</title>
  5. </head>
  6. <body>
  7. <?php
  8. include 'koneksi.php';
  9. $sql = "SELECT * FROM pesan";
  10. $query = mysqli_query($connect, $sql);
  11. ?>
  12.  
  13. <center><table border="1">
  14. <a href="tambah_data.php">Tambah Data</a>
  15. <tr>
  16. <th>Nama </th>
  17. <th>No Telp </th>
  18. <th>Pesan </th>
  19. <th>aksi </th>
  20. </tr>
  21. <?php
  22. while ($result = mysqli_fetch_array($query))
  23. {
  24. ?>
  25. <tr>
  26. <td><?php echo $result['nama']; ?></td>
  27. <td><?php echo $result['no_telp']; ?></td>
  28. <td><?php echo $result['pesan']; ?></td>
  29. <td><?php echo "<a href='edit.php?id=".$result['id']."'> Edit </a>" ?></td>
  30. <td><?php echo "<a href='hapus.php?id=".$result['id']."'> Hapus </a>" ?></td>
  31. </tr>
  32. <?php
  33. }
  34. ?>
  35. </table></center>
  36. </body>
  37. </html>