-
Notifications
You must be signed in to change notification settings - Fork 1
/
dashboard_db2.php
62 lines (42 loc) · 1.92 KB
/
dashboard_db2.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
<?php
include 'db-connect.php';
$uname=$_SESSION["username"];
$sql = 'SELECT aid, heading, street, city, state , zip, price, photo from apartment WHERE delete_marker = 0 AND AID IN (select AID from apply_apt where TID=1 and username="'.$_SESSION["username"].'")';
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo
'<div class="card"><div class="clearfix float-">
<img style="height:80px; width: 100px;" src = "'.$row["photo"].'">
<div>'.$row["heading"].'</div>
<div>'.$row["street"].', '.$row["city"].', '.$row["state"].', '.$row["zip"].'</div>
<div>Price: '.$row["price"].'</div>
</div>';
echo '<Strong>People who have applied:</strong>';
$sql1 = "SELECT username,aid,app_status from apply_apt where TID=0 and aid=".$row['aid'];
$result1 = $conn->query($sql1);
if ($result1->num_rows > 0) {
while($row1 = $result1->fetch_assoc()) {
$app_status = $row1["app_status"];
$aonclick = "clickFunction(1,".$row1["aid"].",'".$row1["username"]."')";
$donclick = "clickFunction(2,".$row1["aid"].",'".$row1["username"]."')";
echo '<br><a href = "profile.php?username='.$row1['username'].'"><strong>'.$row1['username'].':</strong></a> ';
if($app_status == 0){
echo '<div id="'.$row1['username'].$row1['aid'].'" >';
echo '<button class = "status" onclick ="'.$aonclick;
echo '">Approve<span>✓</span></button>';
echo '<button onclick ="'.$donclick;
echo '">Reject<span>✘</span></button></div>';
} else if ($app_status == 1){
echo "Approved";
} else if ($app_status == 2){
echo "Rejected";
}
}
}
//$row['street'];
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$conn->close();
?>