-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathautoSuggest.php
54 lines (47 loc) · 1.07 KB
/
autoSuggest.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
<?php
session_start();
require 'admin/header.php';
require 'admin/sql.php';
if(empty($_SESSION['user']) || empty($_SESSION['mail']))
{
header('location:login.php');
}
else
{
$checkSql="SELECT `bookingplace` FROM `bookingtable` WHERE `bookedby` ='".$_SESSION['mail']."'";
$result=$conn->query($checkSql);
$column = array();
while($row = $result->fetch_assoc())
{
array_push($column, $row["bookingplace"]);
}
}
$sql="select `plcaeName` from `placetable`";
$result2=$conn->query($sql);
$conn->close();
?>
<body>
<div class="container">
<a href="index.php" class="btn btn-danger btn-lg"> ← Home</a><br>
<div class="row">
<div class="col-md-4">
</div>
<div class="col-md-4">
<h2 >Places you did not visit</h2>
<ol>
<?php
while($allData=$result2->fetch_assoc())
{
if (!in_array($allData["plcaeName"], $column))
{
echo '<li><a href=details.php?place='.$allData["plcaeName"].'>'.$allData["plcaeName"].'</a></li>';
}
}
?>
</ol>
</div>
<div class="col-md-4">
</div>
</div>
</div>
</body>