-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhousemanagement.php
131 lines (129 loc) · 4.07 KB
/
housemanagement.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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<link rel="stylesheet" href="index.css">
<title>house management</title>
</head>
<body>
<?php
if($_SESSION['account'] == null)
{
echo "<script> alert('You didnt log in yet!!');location.href='http://people.cs.nctu.edu.tw/~chymau/webhw2/index.html'; </script>";
exit;
}
?>
<form method="post" action = "delete2.php" id="delete"></form>
<h1>My Houses</h1>
<form style = "width: 15%;" action = "newhouse.html" id="new"><!-- -->
</form>
<form style = "width: 15%;" action = "edit.php" id="edit">
</form>
<form style = "width: 15%;" action = "logout.php" id="logout">
</form>
<form style = "width: 15%;" action = "homepage.php" id="main"><!-- -->
</form>
<table width="100%">
<tr>
<td>
<button style="width:200px" class="submit" type="submit" class="submit" form="new">New</button>
</td>
<td>
<button style="width:200px" class="submit" type="submit" class="submit" form="edit">Edit</button>
</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>
<button style="width:200px" class="submit" type="submit" class="submit" form="main">Home Page</button>
</td>
<td>
<button style="width:200px" class="submit" type="submit" class="submit" form="logout">Logout</button>
</td>
</tr>
</table>
<?php
$db_host = "dbhome.cs.nctu.edu.tw";
$db_name = "chymau_cs_a_firstdatabase";
$db_user = "chymau_cs";
$db_password = "12345678";
$dsn = "mysql:host=$db_host;dbname=$db_name";
$db = new PDO($dsn, $db_user, $db_password);
$house_sql = "SELECT house.id, house.name, house.price, house.location, house.time, people.name as owner FROM house JOIN people where house.owner_id = people.id";
$house_rs = $db->query($house_sql);
?>
<table width="100%">
<thead>
<tr>
<td>ID</td>
<td>Name</td>
<td>Price</td>
<td>Location</td>
<td>Time</td>
<td>Owner</td>
<td>Information</td>
<td>Option</td>
</tr>
</thead>
<tbody>
<?php
$numofhouses = 0;
while($house = $house_rs->fetchObject())
{
if($house->owner == $_SESSION["name"])
{
$numofhouses = $numofhouses + 1;
$tag = $house->id;
?>
<tr>
<td><?php echo $house->id; ?></td>
<td><?php echo $house->name; ?></td>
<td><?php echo $house->price; ?></td>
<td><?php echo $house->location; ?></td>
<td><?php echo $house->time; ?></td>
<td><?php echo $house->owner; ?></td>
<td><?php
$info_sql = "SELECT information.information FROM information where '$house->id' = information.house_id";
$info_rs = $db->query($info_sql);
$info = $info_rs->fetchObject();
if($info)
{
echo $info->information;
while($info = $info_rs->fetchObject())
{
echo " - ";
echo $info->information;
}
}
?>
</td>
<td>
<button style="width:200px" form="delete" class="submit" type="submit" value="<?php echo $tag; ?>" name="Delete">Delete</button>
</td>
</tr>
<?php
}
}
if ( $numofhouses == 0)
{
?>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td><p>You Have No Houses!</p></td>
<td></td>
<td></td>
<td></td>
</tr>
<?php
}
?>
</tbody>
</table>
</body>
</html>