<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
</head>
<body>
<?php
include("db.php");

$sql = "SELECT * FROM books";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
?>
<div class="container mt-3">
  <h2>66301280043 ธัญพิสิษฐ์ ประจำการ</h2>
  <p>ชื่อหนังสือ ข้อมูลหนังสือ</p> 
  <a href="add.php" class="btn btn-success">เพิ่มข้อมูลหนังสือ</a>          
  <table class="table table-hover">
    <thead>
      <tr>
        <th>ลำดับ</th>
        <th>ชื่อหนังสือ</th>
        <th>คำอธิบาย</th>
        <th>สำนักพิมพ์</th>
        <th>ชื่อผู้แต่ง</th>
        <th>ดำเนินการ</th>
      </tr>
    </thead>
    <tbody>

<?php
  // output data of each row
  while($row = $result->fetch_assoc()) {
    $id=$row['book_id'];
    $name=$row['book_name'];
    $description=$row['description'];
    $publisher=$row['publisher'];
    $author=$row['author'];
    //echo"$id $name $surname $email $tel<br>";
  ?>
    <tr>
        <td><?=$id?></td>
        <td><?=$name?></td>
        <td><?=$description?></td>
        <td><?=$publisher?></td>
        <td><?=$author?></td>
        <td>
          <a href="edit.php?id=<?=$id?>" class="btn btn-primary">แก้ไข</a>
          <a href="del.php?id=<?=$id?>" class="btn btn-danger">ลบ</a>
      
        </td>
      </tr> 
  
  <?php
  }
} else {
  echo "0 results";
}
$conn->close();

?>

    
    </tbody>
  </table>
</div>

</body>
</html>