/
searchResults.php
102 lines (66 loc) · 2.24 KB
/
searchResults.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
<?php
session_start();
if ( !isset($_SESSION['username']) ) {
header("location:index.php");
}
include_once "searchFunction.php";
define("TABLENAME", "customers");
if (!empty($_POST['bNameInput']) ) {
$searchCategory = "business_name";
$searchValue = $_POST['bNameInput'];
echo "Results for Business Name " . $searchValue . ":<br>";
$results = searchDatabase(TABLENAME, $searchCategory, $searchValue);
if ($results->num_rows == 0)
echo "No Results found. <br>";
else {
while ( $row = mysqli_fetch_object($results) ) {
echo "<a href='/Manager/results.php?bNum=" . $row->cust_num . "'>" . $row->business_name . "</a><br />";
}
}
}
if (!empty($_POST['bPhoneInput'])) {
$searchCategory = "phone";
$searchValue = $_POST['bPhoneInput'];
echo "Results for Phone Number " . $searchValue . ":<br>";
$results = searchDatabase(TABLENAME, $searchCategory, $searchValue);
if ($results->num_rows == 0)
echo "No Results found. <br>";
else {
while ( $row = mysqli_fetch_object($results) ) {
echo "<a href='/Manager/results.php?bNum=" . $row->cust_num . "'>" . $row->business_name . "</a><br />";
}
}
}
if (!empty($_POST['bAddressInput'] )) {
$searchCategory = "address";
$searchValue = $_POST['bAddressInput'];
echo "Results for Address " . $searchValue . ":<br>";
$results = searchDatabase(TABLENAME, $searchCategory, $searchValue);
if ($results->num_rows == 0)
echo "No Results found. <br>";
else {
while ( $row = mysqli_fetch_object($results) ) {
echo "<a href='/Manager/results.php?bNum=" . $row->cust_num . "'>" . $row->business_name . "</a><br />";
}
}
}
if ( !empty($_POST['custNumInput'])) {
$searchCategory = "cust_num";
$searchValue = $_POST['custNumInput'];
echo "Results for Customer Number " . $searchValue . ":<br>";
$results = searchDatabase(TABLENAME, $searchCategory, $searchValue);
if ($results->num_rows == 0)
echo "No Results found. <br>";
else {
while ( $row = mysqli_fetch_object($results) ) {
echo "<a href='/Manager/results.php?bNum=" . $row->cust_num . "'>" . $row->business_name . "</a><br />";
}
}
}
if (empty($searchCategory)) {
echo "Error: No Search Input.";
exit;
}
echo "<a href='/Manager/home.php'>New Search</a>";
// $count = mysql_num_rows($result);
?>