-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathLogBook.php
91 lines (73 loc) · 2.91 KB
/
LogBook.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
<?php
session_start();
if (!isset($_SESSION["loggedin"]))
{
header("location: login.php");
}
?>
<!DOCTYPE >
<html >
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
<title>BirdLogger | Bird database</title>
</head>
<body>
<div id="container">
<div id="mainpic">
<h1>BirdLogger</h1>
<h2>The best bird database</h2>
<p> </p>
<?php if (isset($_SESSION["loggedin"])) : ?>
<h3> <b><?php echo htmlspecialchars($_SESSION["username"]); ?></b></h3>
<?php endif ?>
</div>
<div id="menu">
<ul>
<li class="menuitem"><a href="Home.php">Home</a></li>
<li class="menuitem"><a href="BirdTool.php">Search</a></li>
<li class="menuitem"><a href="LogBook.php">LogBook</a></li>
<li class="menuitem"><a href="Contact.php">Contact</a></li>
<?php if (!isset($_SESSION["loggedin"])) : ?>
<li class="menuitem"><a href="login.php">Login</a></li>
<?php endif ?>
<?php if (isset($_SESSION["loggedin"])) : ?>
<li class="menuitem"> <a href="logout.php">Logout</a> </li>
<?php endif ?>
</ul>
</div>
<div id="content">
<div id="logbook">
<?php
$UserID = $_SESSION["id"];
$conn = mysqli_connect("localhost", "phpmyadmin", "Depaul123","phpmyadmin");
// Check connection
if (!$conn){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "SELECT * FROM Logbook WHERE UserID ='$UserID'";
$result = mysqli_query($conn, $sql);
echo '<h1> Logbook </h1><ul>';
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
echo '
<li>
<span class="log"><a href="birdpage.php?bird='.$row['BirdID'].'">'.$row['BirdName'].'</a></span>
sightings: '.$row['CountSeen'].'
<span class="log"></span><a href="addBird.php?birdID='.$row['BirdID'].'&bird='.$row['BirdName'].'">Add</a>
<a href="deleteBird.php?birdID='.$row['BirdID'].'&bird='.$row['BirdName'].'">Remove</a>
</li>';
}
}
else{
echo "0 results";
}
echo '</ul>';
// Close connection
mysqli_close($conn);
?>
</div>
</div>
</div>
</body>
</html>