-
Notifications
You must be signed in to change notification settings - Fork 0
/
public_list.php
126 lines (110 loc) · 3.37 KB
/
public_list.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
<?php
$con = mysqli_connect("localhost", "root", "", "wadah4db") or die ($con);
function executeQuery($query)
{
$con = mysqli_connect("localhost", "root", "", "wadah4db");
$output = mysqli_query($con, $query);
return $output;
}
if (isset($_POST['ASC']))
{
$asc_query = "SELECT * FROM public ORDER BY public_name ASC";
$output = executeQuery($asc_query);
}
elseif (isset($_POST ['DESC']))
{
$desc_query = "SELECT * FROM public ORDER BY public_name DESC";
$output = executeQuery($desc_query);
}
else
{
$default_query = "SELECT * FROM public";
$output = executeQuery($default_query);
}
$search = mysqli_real_escape_string($con, $_REQUEST['search']);
$sql = "SELECT * FROM public WHERE public_name LIKE '".$search."'";
$r_query = mysqli_query($con, $sql);
?>
<html>
<head>
<title> DATA SEARCH </title>
<style>
table, tr, th, td
{
border: 1px solid black;
}
</style>
</head>
<body>
<table width="558" border="1" align="center">
<tr>
<td height="90" colspan="2"><img src="3.png" width="1140" height="300" /></td>
</tr>
<tr>
<td width="59" height="192"><?php include 'activity_menu.php' ?>
</td>
<td width="400"><div align="center"></div>
<div align = "center">
<br>
<h1> List of Public Participants </h1>
<table border =2 cellpadding =2 cellspacing =2>
<form action="public_list.php" method="post">
<input type="text" name="search" placeholder="Search name"/>
<input type="submit" value="Submit"/>
<br>
<br>
<?php echo 'Sort: ' ?>
<button type = "submit" name ="ASC" style="padding: 0; border; none;"><img src="asc.png" width = "32" height = "32" /></button>
<?php echo ' ' ?>
<button type = "submit" name ="DESC" style="padding: 0; border; none;"><img src="des.png" width = "32" height = "32" /></button>
<br><br>
<br>
<br>
<tr>
<th> NRIC</th>
<th> Full Name</th>
<th> Address </th>
<th> Contact Number </th>
<th colspan ="2"> Action </th>
</tr>
<?php if (!empty($_REQUEST['search']))
{
while ($row = mysqli_fetch_assoc($r_query))
{
echo "<tr>";
echo "<td>".$row['public_ic']."</td>";
echo "<td>".$row['public_name']."</td>";
echo "<td>".$row['public_add']."</td>";
echo "<td>".$row['public_tel']."</td>";
echo "<td><a href = public_edit.php?public_ic=".$row['public_ic']."><img src='edit.png' width='32' height='32'></a></td>";
echo "<td><a href = public_delete.php?public_ic=".$row['public_ic']."><img src='del.png' width='32' height='32'></a></td>";
echo "</tr>";
}
}
else
{
while ($row = mysqli_fetch_assoc($output))
{
echo "<tr>";
echo "<td>".$row['public_ic']."</td>";
echo "<td>".$row['public_name']."</td>";
echo "<td>".$row['public_add']."</td>";
echo "<td>".$row['public_tel']."</td>";
echo "<td><a href = public_edit.php?public_ic=".$row['public_ic']."><img src='edit.png' width='32' height='32'></a></td>";
echo "<td><a href = public_delete.php?public_ic=".$row['public_ic']."><img src='del.png' width='32' height='32'></a></td>";
echo "</tr>";
}
}
?>
</form>
</table>
<br>
<br>
<a href = "public_print.php"><img src="print.png" width="48" height="48" align="center"/><a>
</div>
</td>
</tr>
</table>
<?php include 'footer.php' ?>
</body>
</html>