FPSBD/email-search.php at master · anggunw/FPSBD · GitHub

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
<?php

if(isset($_POST['search'])){
	$valueToSearch = $_POST['valueToSearch'];
	$query = "SELECT book_number, book_date, pickup_time, package_name, destination FROM booking_details, package WHERE booking_details.email_fk = '$valueToSearch' AND booking_details.package_id_fk = package.package_id";
	$search_result = filterTable($query);

} else{
	$query = "SELECT * FROM booking_details WHERE email_fk = ''";
	$search_result = filterTable($query);
}
function filterTable($query){
	$connect = mysqli_connect("localhost", "root", "", "bonvoyage");

	if(mysqli_connect_errno()){
		die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
	}
	$filter_Result = mysqli_query($connect, $query) or die(mysqli_error($connect));
	return $filter_Result;
}
?>

<!DOCTYPE html>
<html>
<head>
	<title>Bon Voyage Booking Search</title>
	<link rel="icon" type="image/png" href="images/icons/favicon.ico"/>
	<style>
		table, tr, th, td
		{
			border: 1px solid black;
		}
	</style>
</head>
<body>
	<form action="email-search.php" method="post">
		<input type="text" name="valueToSearch" placeholder="Search book by email"><br><br>
		<input type="submit" name="search" value="Search"><br><br>
		<table>
			<tr>
				<th>book number</th>
				<th>book made</th>
				<th>pick up time</th>
				<th>package name</th>
				<th>destination</th>
			</tr>
			<?php while($row = mysqli_fetch_array($search_result)):?>
			<tr>
				<td><?php echo $row['book_number'];?></td>
				<td><?php echo $row['book_date'];?></td>
				<td><?php echo  $row['pickup_time'];?></td>
				<td><?php echo $row['package_name'];?></td>
				<td><?php
						echo $row['destination'] === 'S'? 'Surabaya' : 'Malang' ?>
				</td>
 			</tr>
 		<?php endwhile;?>
		</table>
	</form>

	<div class="container-login100-form-btn">
    	<button class="login100-form-btn">
      		<a href="home.php" class="login100-form-btn">Home</a>
    	</button>
  	</div>

</body>
</html>