-
Notifications
You must be signed in to change notification settings - Fork 0
/
availableShowingRentals.php
67 lines (54 loc) · 1.29 KB
/
availableShowingRentals.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?php
//connect to database
require_once('database.php');
//get the available unit information
$available = 1;
$queryUnit = 'SELECT * FROM units
WHERE available = :available';
$statement1 = $db->prepare($queryUnit);
$statement1->bindValue(':available', $available);
$statement1->execute();
$unit = $statement1->fetch();
$address = $unit['address'];
$statement1->closeCursor();
//get all available units
$query = 'SELECT * FROM units
WHERE advertised = 1
ORDER BY rentAmount';
$statement2 = $db->prepare($query);
$statement2->execute();
$units = $statement2->fetchAll();
$statement2->closeCursor();
?>
<!doctype html>
<html>
<head>
<title>Title</title>
<link rel="stylesheet" type="text/css" href="css/main.css" />
</head>
<body>
<div class="wrapper">
<nav>
<?php include_once('navigation.php')?>
</nav>
<header>
<div class="hero">
</div>
</header>
<main>
<?php foreach ($units as $unit) : ?>
<div class="gallery">
<a href="showingList.php.?unitID=<?php echo $unit['unitID']; ?>">
<h3 class="pictureLabels">
<?php echo $unit['address']; ?>
</h3>
</a>
</div>
<?php endforeach; ?>
</main>
<footer>
<?php include_once('footer.php')?>
</footer>
</div>
</body>
</html>