-
Notifications
You must be signed in to change notification settings - Fork 0
/
searchuresult.php
132 lines (129 loc) · 5.92 KB
/
searchuresult.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
132
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no"/>
<title>iBH - Usages History</title>
<!-- CSS -->
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<link href="css/materialize.css" type="text/css" rel="stylesheet" media="screen,projection"/>
<link href="css/style.css" type="text/css" rel="stylesheet" media="screen,projection"/>
</head>
<body>
<!-- Dropdown Structure -->
<ul id="dropdown1" class="dropdown-content white-text">
<li><a href="uSID.html">Usages</a></li>
<li><a href="uhistory.php">History</a></li>
</ul>
<ul id="dropdown2" class="dropdown-content white-text">
<li><a href="SID.html">Start Your Booking</a></li>
<li><a href="bhistory.php">History</a></li>
</ul>
<nav class="amber darken-1" role="navigation">
<div class="nav-wrapper container">
<a id="logo-container" href="index.html" class="brand-logo white-text">iBH</a>
<ul class="right hide-on-med-and-down">
<li><a class="dropdown-button white-text" data-activates="dropdown2"><i class="material-icons left">dialpad</i><i class="material-icons right">arrow_drop_down</i>Booking Transactions</a></li>
<li><a class="dropdown-button white-text" data-activates="dropdown1"><i class="material-icons left">trending_up</i><i class="material-icons right">arrow_drop_down</i>Usages Transactions</a></li>
<li><a href="statistics.php" class="white-text"><i class="material-icons left">equalizer</i>Statistics</a></li>
<li><a href="about.html" class="white-text"><i class="material-icons left">supervisor_account</i>About</a></li>
</ul>
<ul id="nav-mobile" class="side-nav">
<li><a href="booking.html"><i class="material-icons left">dialpad</i>Booking Transactions</a>
<li><a href="usage.html"><i class="material-icons left">trending_up</i>Usage History</a>
<li><a href="statistics.php"><i class="material-icons left">equalizer</i>Statistics</a></li>
<li><a href="#!"><i class="material-icons left">supervisor_account</i>About</a></li>
</ul>
<a href="#" data-activates="nav-mobile" class="button-collapse"><i class="material-icons">menu</i></a>
</div>
</nav>
<div class ="container">
<div class="row">
<h2>Usages History</h2>
</div>
</div>
<div class="container">
<nav class = "amber darken-1">
<div class="nav-wrapper">
<form action="searchuresult.php" method="POST">
<div class="input-field">
<input id="search" name="search" type="search" required>
<label for="search"><i class="material-icons">search</i></label>
<!-- I've put "red-text" class to emphasize -->
<i class="material-icons white-text">close</i>
</div>
</form>
</div>
</nav>
</div>
<div class = "container">
<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "atk";
$connection = mysql_connect($servername, $username, $password) or die(mysql_error());
@mysql_select_db('atk') or die(mysql_error());
$search_query = $_POST["search"];
$query = "SELECT * FROM `t_user` NATURAL JOIN `t_pemakaian` NATURAL JOIN `t_atk` WHERE `SID` LIKE '%$search_query%' OR `Nama_User` LIKE '%$search_query%' OR `Jenis_ATK` LIKE '%$search_query%'";
$result = mysql_query($query);
$num = mysql_num_rows($result);
?>
<table class = "highlight centered">
<thead>
<tr>
<th>No</th>
<th>SID/SSN</th>
<th>User</th>
<th>Items</th>
<th>Qty</th>
<th>Usages Date</th>
</tr>
</thead>
<tbody>
<tr>
<?php
$i = 0;
while($i < $num) {
$usage_id = mysql_result($result, $i, "ID_Pemakaian");
$jumlah = mysql_result($result, $i, "Jumlah");
$date_usage = mysql_result($result, $i, "Tgl_Pemakaian");
$atk_id = mysql_result($result, $i, "ID_ATK");
/* nama atk */
$query_atk = "SELECT Jenis_ATK FROM `t_atk` WHERE (`ID_ATK` = '$atk_id')";
$result_atk = mysql_query($query_atk);
$atk_name = mysql_result($result_atk, 0);
$user_id = mysql_result($result, $i, "ID_User");
/* nama user */
$query_user = "SELECT Nama_User FROM `t_user` WHERE (`ID_User` = '$user_id')";
$result_user = mysql_query($query_user);
$user_name = mysql_result($result_user, 0);
$query_user = "SELECT SID FROM `t_user` WHERE (`ID_User` = '$user_id')";
$result_user = mysql_query($query_user);
$user_sid = mysql_result($result_user, 0);
?>
<td><?= $i+1 ?></td>
<td><?= $user_sid ?></td>
<td><?= $user_name ?></td>
<td><?= $atk_name ?></td>
<td><?= $jumlah ?></td>
<td><?= $date_usage ?></td>
</tr>
</tbody>
<?php $i++; } ?>
<?php mysql_close(); ?>
</table>
</div>
<br><br>
<div class="container">
<div class="row center">
<a class="btn waves-effect waves-light" href="uhistory.php">Clear
<i class="material-icons right">send</i>
</a>
</div>
</div>
</body>
<script src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
<script src="js/materialize.js"></script>
<script src="js/init.js"></script>
</html>