<?php  
$page_title = 'Gallery List';
include 'header.php';
?>
<div class="content-wrapper">
	<section class="content mt-4">
		<div class="container-fluid">
			<div class="row">
				<div class="col-md-12">
					<?php include('alert-msg.php'); ?>
					<div class="card card-primary">
						<div class="card-header">
							<h3 class="card-title"><?php echo $page_title; ?></h3>
						</div>
						<!-- /.card-header -->
						<div class="card-body">
							<table class="table table-bordered table-striped main_datatables">
								<thead>
									<tr>
										<th>Sr. No.</th>
										<th>Category</th>
										<th>Title</th>
										<th>Section</th>
										<th>Gallery File</th>
										<th>Action</th>
									</tr>
								</thead>
								<tbody>
									<?php
									$sel_gallery=mysqli_query($con,'select * from gallery order by id desc');
									$i=1;
									while($row_gallery=mysqli_fetch_array($sel_gallery))
									{

										?>
										<tr>
											<td><?php echo $i; ?></td>
											<td><?php echo $row_gallery['category']; ?></td>
											<td><?php echo $row_gallery['title']; ?></td>
											<td><?php echo $row_gallery['section']; ?></td>
											<td align="center">
												<?php
												if($row_gallery['section']=='PDF')
												{
													?>
													<a href="<?php echo $row_gallery['photo']; ?>"  target="_blank"><i class="fas fa-file-pdf fa-2x"></i></a>
													<?php
												}
												else if($row_gallery['section']=='Video')
												{
													?>
													<a href="<?php echo $row_gallery['photo']; ?>" target="_blank"><i class="fas fa-video fa-2x"></i></a>
													<?php 
												}
												else
												{
													?>
													<img src="<?php echo $row_gallery['photo']; ?>" style="width:100px;" />
													<?php 	
												}
												?>
											</td>
											<td>
												<?php
												if($row_gallery['is_active']==1)
												{
													?>
													<a href="gallery-status.php?id=<?php echo $row_gallery['id']; ?>&status=0" class="btn btn-sm btn-primary"><i class="fas fa-times"></i></a>
													<?php
												}
												else
												{
													?>
													<a href="gallery-status.php?id=<?php echo $row_gallery['id']; ?>&status=1" class="btn btn-sm btn-primary"><i class="fas fa-check"></i></a>
													<?php
												}
												?>
												<a href="gallery-edit.php?id=<?php echo $row_gallery['id']; ?>" class="btn btn-sm btn-primary"><i class="fas fa-edit"></i></a>
												<a href="gallery-delete.php?id=<?php echo $row_gallery['id']; ?>" onclick="return confirm('Are you sure you want to delete ?');" class="btn btn-sm btn-danger"><i class="fas fa-trash"></i></a>
											</td>
										</tr>
										<?php
										$i=$i+1;
									}
									?>
								</tbody>
							</table>
						</div>
						<!-- /.card-body -->
					</div>
				</div>
			</div>
		</div>
	</section>
</div>
<?php include 'footer.php'; ?>