<script type="text/javascript">
$(document).ready(function() {
$('#sortBy').change(function() {
$.get('data.php', { sort: $(this).val() }, function(data) {
$('#response').html(data);
});
});
// Trigger the change event when the page loads
$('#sortBy').trigger('change');
});
</script>
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$dbh = new PDO("mysql:host=$localhost;dbname=$db_name", $db_users, $db_password);
$dbh->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
switch ($_GET['sort']):
case "1":
$sql = "SELECT * FROM packages ORDER BY Package_Price ASC";
break;
case "2":
$sql = "SELECT * FROM packages ORDER BY Package_Price DESC";
break;
default:
$sql = "SELECT * FROM packages ORDER BY Package_Price";
endswitch;
// Prepare the IMG query to be used later on
$imgQuery = $dbh->prepare("SELECT content FROM packages_image WHERE packageID = ? LIMIT 1");
// Execute the Packages query
$packages = $dbh->query($sql);
// Loop through the Package results
while ($package = $packages->fetch()): ?>
<?php
// Get the image data from the prepared query
$imgQuery->execute(array($package->package_id));
$imgData = $imgQuery->fetchColumn();
?>
<div class="col-lg-6 portfolio-item">
<div class="card h-100">
<a href="ViewDetails.php?id=<?php echo $package->package_id ?>">
<?php echo '<img src="data:image/jpeg;base64,'.base64_encode($imgData).'" width="100%" height="350px"/>'; ?>
</a>
<div class="card-body">
<h4 class="card-title">
<a href="ViewDetails.php?id=<?php echo $package->package_id ?>"><?php echo $package->package_name ?></a>
</h4>
<h3 class="breadcrumb" style="color:#C00; text-align:center"><?php echo $package->Package_Price ?> euro.</h3>
<p class="card-text"><?php echo substr($package->Detailed_Itinerary, 0, 150) ?></p>
<a href="ViewDetails.php?id=<?php echo $package->package_id ?>" class="btn btn-primary">More Details</a>
</div>
</div>
</div>
<?php endwhile; ?>
Open in new window