-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtrips.php
47 lines (34 loc) · 1.39 KB
/
trips.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
<html>
<head>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap-theme.min.css" integrity="sha384-fLW2N01lMqjakBkx3l/M9EahuwpSfeNvV63J5ezn3uZzapT0u7EYsXMjQV+0En5r" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" integrity="sha384-0mSbJDEHialfmuBBQP6A4Qrprq5OVfW37PRR3j5ELqxss1yVqOtnepnHVP9aJ7xS" crossorigin="anonymous"></script>
</head>
<body>
<?php
include_once("server.php");
include_once("functions.php");
$sql = "SELECT * from trips";
$result = mysql_query($sql);
while ($data = mysql_fetch_object($result)){
$posts[] = array( 'place_name' =>$data->place_name,
'place_expense' => $data->place_expense,
'id' => $data->id);
}
echo"<div class='container'>";
echo"<div class='jumbotron'>";
echo "<ul class='list-group'>";
foreach ($posts as $key => $value){
echo"<li class='list-group-item'>";
echo "<a href='tripdetail.php?id=$key'".">".$value['place_name']."</a>";
echo "</li>";
}
echo"</ul>";
echo"</div>";
echo"</div>";
?>
</body>
</html>