Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Library.php
- <?php
- /**
- * library.php
- * connection, show, add, edit, delete!
- */
- class library{
- public function __construct()
- {
- $this->db = new PDO('mysql:host=localhost;dbname=crudbuku', 'root', '');
- }
- public function addBuku($judul, $penerbit)
- {
- $sql = "INSERT INTO buku(judul, penerbit) VALUES('$judul', '$penerbit')";
- $query = $this->db->query($sql);
- if (!$query) {
- return "failed!";
- }else{
- return "Success!";
- }
- }
- public function showBuku()
- {
- $sql = "SELECT * FROM crudbuku";
- $query = $this->db->query($sql);
- return $query;
- }
- public function editBuku($id)
- {
- $sql = "SELECT * FROM crudbuku WHERE id = '$id'";
- $query = $this->db->query($sql);
- return $query;
- }
- public function updateBuku($id, $judul, $penerbit)
- {
- $sql = "UPDATE crudbuku SET judu = '$judul', penerbit = '$penerbit' WHERE id = '$id'";
- $query = $this->db->query($sql);
- if (!$query) {
- return "failed!";
- }else{
- return "success!";
- }
- }
- public function deleteBuku()
- {
- $sql = "DELETE FROM crudbuku WHERE id = '$id'";
- $query = $this->db->query($sql);
- }
- }
- #index.php
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Daftar buku tersedia</title>
- <link rel="stylesheet" href="css/style.css">
- </head>
- <body>
- <div class="row">
- <div class="grid">
- <div class="col-12">
- <div class="col">
- <table>
- <tr>
- <th>Judul buku</th>
- <th>Penerbit</th>
- </tr>
- <?php
- include_once('library.php');
- $buku = new library();
- $show = $buku->showBuku();
- while ($data = $show->fetch (PDO::FETCH_OBJ)) {
- ?>
- <tr>
- <td><?php echo $data->$judul ?></td>
- <td>Griffin</td>
- </tr>
- <tr>
- <td>Lois</td>
- <td>Griffin</td>
- </tr>
- <tr>
- <td>Lois</td>
- <td>Griffin</td>
- </tr>
- <?php } ?>
- </table>
- </div>
- </div>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement