<?php
session_start();
include '../assets/constant/config.php';
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
?>
<?php include('include/sidebar.php'); ?>
<!-- Top Bar End -->
<?php include('include/header.php'); ?>
<div class="page-content-wrapper ">
<div class="container-fluid">
<div class="row">
<div class="col-sm-12">
<div class="page-title-box">
<div class="btn-group float-right">
<a href="add_gallery.php" class="btn btn-primary mb-3">Add New</a>
</div>
<h4 class="page-title">View Gallery</h4>
</div>
</div>
<div class="clearfix"></div>
</div>
<!-- end page title end breadcrumb -->
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<div class="table-responsive">
<table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;" enctype="multipart/form-data">
<thead>
<tr>
<th>Serial</th>
<th>Photo</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$stmt = $conn->prepare("SELECT * FROM `gallery` WHERE delete_status='0' ");
$stmt->execute();
$record = $stmt->fetchAll();
$i = 1;
foreach ($record as $key) { ?>
<tr>
<?php
// Read the image file and encode it to Base64
$imagePath = "../assets/images/" . $key['photo']; // Path to your image file
$imageData = file_get_contents($imagePath);
$base64Image = base64_encode($imageData);
?>
<td><?php echo $i; ?></td>
<td>
<img class="base64-image" src="data:image/jpeg;base64,<?php echo $base64Image; ?>" alt="" style="height:60px; width: 60px;">
</td>
<td>
<a href="#" onclick="editForm(event, <?php echo $key['id'] ?>, 'edit_gallery.php')" class="btn btn-primary waves-effect waves-light"><i class="fa fa-edit" aria-hidden="true"></i>
</a>
<a href="#" onclick="delForm(event, <?php echo $key['id'] ?>, 'app/gallery_crud.php')" class="btn btn-danger" onclick="return confirm('Are you sure you want to delete this item?');"><i class="fa fa-trash-alt" aria-hidden="true"></i></a>
</td>
</tr>
<?php $i++;
} ?>
</tbody>
</tbody>
</table>
</div><!--end /tableresponsive-->
</div><!--end card-body-->
</div><!--end card-->
</div><!--end col-->
</div><!--end row-->
</div> <!-- Page content Wrapper -->
</div> <!-- content -->
<?php include('include/footer.php'); ?>