-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathshowProductSearch.php
140 lines (137 loc) · 4.73 KB
/
showProductSearch.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
133
134
135
136
137
138
139
140
<?php
include 'header.php';
echo '<div id="conteudo">';
echo '<div class="texto">';
$db = new PDO('sqlite:database/documents.db');
$InvoiceArray = array();
if(!empty($_GET['field']))
{
$result1 = $db->query('SELECT * FROM Product');
$data1 = $result1->fetchAll();
foreach($data1 as $row)
{
switch ($_GET['op'])
{
case 'equal':
case 'contains':
case 'min':
case 'max':
switch ($_GET['field'])
{
case 'ProductCode':
switch ($_GET['op'])
{
case 'equal':
if ($row['ProductCode'] == $_GET['value1'])
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
case 'min':
if ($row['ProductCode'] >= $_GET['value1'])
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
case 'max':
if ($row['ProductCode'] <= $_GET['value1'])
{
$$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
case 'contains':
if(strpos($row['ProductCode'],$_GET['value1']) !== false)
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
}
break;
case 'ProductDescription':
switch ($_GET['op'])
{
case 'equal':
if ( strtolower ($row['ProductDescription']) == strtolower ($_GET['value1']))
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
case 'min':
if ($row['ProductDescription'] >= $_GET['value1'])
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
case 'max':
if ($row['ProductDescription'] <= $_GET['value1'])
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
case 'contains':
if(strpos(strtolower ($row['ProductDescription']),strtolower ($_GET['value1'])) !== false)
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
}
break;
}
break;
case 'range':
switch ($_GET['field'])
{
case 'ProductCode':
if ( ($row['ProductCode'] >= $_GET['value1']) && ($row['ProductCode'] <= $_GET['value2']))
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
case 'ProductDescription':
if ( (strtolower ($row['ProductDescription']) >= strtolower ($_GET['value1'])) && (strtolower ($row['ProductDescription']) <= strtolower ($_GET['value2'])))
{
$InvoiceArray2 = array('ProductCode' => $row['ProductCode'], 'ProductDescription' => $row['ProductDescription'],
'UnitPrice' => $row['UnitPrice']);
array_push($InvoiceArray, $InvoiceArray2);
}
break;
}
break;
}
}
}
if(empty($InvoiceArray))
{
echo "There was no results.";
}
else
{
foreach($InvoiceArray as $row)
{
echo '<b class="btab">- Product Code </b>' . $row['ProductCode'] . '<br>';
echo '<b class="btab">- Product Description </b>' . $row['ProductDescription'] . '<br>';
echo '<b class="btab">- Unit Price </b>' . $row['UnitPrice'] . '<br>';
}
}
?>
</div>
</div>
</body>