invisio v2.0

<?php
	include('innerpageheader.php');
	
	include('config.php');
	
	
	$enqstat = 'Invoiced';
	//$enqstat1 = '';
	$result = $js->prepare('SELECT * FROM `websitehotels` ');
		$result->execute();
?>

<div class="col">
							<div class="heading-messages">
								<h3>Hotels</h3>
							</div>
						</div>
						<div class="col-md-4">
							<div class="breadcrumb">
								<div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Listing</a>
								</div>
								<div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>All
								</div>
							</div>
						</div>
					</div>

<div class="box">
						<div class="row no-gutters">
							<div class="col-auto me-auto text-start pe-0">
								<div class="add-new">
									<a href="selecthoteltowebsite.php">Add New Hotels<i class="fas fa-plus"></i></a>
								</div>
							</div>
							<div class="col text-end">
								<div class="tools-btns">
									<a href="#"><i class="fas fa-print" data-bs-toggle="tooltip" data-html="true" title="Print"></i></a>
									<a href="#"><i class="fas fa-file-pdf" data-bs-toggle="tooltip" data-html="true" title="Pdf"></i></a>
									<a href="#"><i class="fas fa-file-excel" data-bs-toggle="tooltip" data-html="true"
											title="Excel"></i></a>
								</div>
							</div>

</div>
						<div class="row no-gutters">
							<div class="col-12 table-responsive">
								<table id="example" class="table table-hover responsive listing">
									<thead>
										<tr style="background-color:#00BDA5; color:#fff; text-transform:uppercase;">
											<th style="color:#fff;">#</th>
                                            <th style="color:#fff;">Hotel Name</th>
                                            <th style="color:#fff;">Upload Brief Image</th>
                                            <th style="color:#fff;">Upload Hotels Images</th>
                                            <th>Status to Website</th>
                                            <th>Add to Website</th>
                                            <th>Remove from Website</th>
                                            <th style="color:#fff;">Edit</th>
                                            <th style="color:#fff;">Delete</th>
										</tr>
									</thead>
									<tbody>
                                    
                                    <?php
										$i =1;
										$x=1;
										
										while($row = $result->fetch(PDO::FETCH_ASSOC)) 
										{
											
											$id = $row['id'];
											$hstat = $row['hotelstatus'];
											
											
											$hot = $row['hotel'];
											
											
											$resulth = $js->prepare('SELECT * FROM `hotelvendor` WHERE id = :hot' );
										 	$resulth->execute(array(':hot' => $hot));
											while($rowh = $resulth->fetch(PDO::FETCH_ASSOC)) 
											{

$hotelname = $rowh['hotelname'];
											}
											
											
											echo "<tr>";
												echo "<td>$i</td>";
												echo "<td>$hotelname</td>";
												echo "<td><a href='upload_hotelbrimages.php?hotel=$id'><i class='fa fa-upload'  style='size:15px;color:#E8514D;'></i></a></td>";
												
												echo "<td><a href='upload_hotelimages.php?hotel=$id'><i class='fa fa-upload'  style='size:15px;color:green;'></i></a></td>";
												echo "<td align='center'>$hstat</td>";
												echo "<td align='center'><a href='sethotel.php?hotel=$id'><i class='fas fa-thumbs-up' style='color:#EA4335;'></i></td>";
												echo "<td align='center'><a href='unsethotel.php?hotel=$id'><i class='fas fa-thumbs-down' style='size:15px;color:orange;'></i></td>";
												echo "<td><a href='#'><i class='fas fa-edit' style='size:15px;color:orange;'></i></a>";
												echo "<td><a href='#'><i class='fa fa-times-circle' style='color:red'></i></a>
												</td>";
													
												echo "</tr>";
												$i++;
											
										}
								?>

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

</div>

<?php
	include('footer.php');
?>

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>