forked from arjaylc/PLDT
/
search.php
27 lines (26 loc) · 1.34 KB
/
search.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
<?php
include ("includes/database_master.inc.php");
session_start();
if($_GET['type'] == 'cabinetNo'&&!empty($_GET['name_startsWith'])){
$database_master = new DatabaseMaster();
$query = "SELECT cabinetNo FROM cabinet WHERE cabinetNo LIKE '".strtoupper($_GET['name_startsWith'])."%' LIMIT 10";
$data = $database_master->querySearch($query, 'cabinetNo');
echo json_encode($data);
}
else if($_GET['type'] == 'employee'&&!empty($_GET['name_startsWith'])){
$database_master = new DatabaseMaster();
$query = "SELECT CONCAT(firstName, ' ', lastName, '(', idNo, ')') as employee FROM users
WHERE (firstName LIKE '".strtoupper($_GET['name_startsWith'])."%'
OR lastName LIKE'".strtoupper($_GET['name_startsWith'])."%'
OR CONCAT(firstName, ' ', lastName) LIKE'".strtoupper($_GET['name_startsWith'])."%'
OR idNo LIKE '".strtoupper($_GET['name_startsWith'])."%')
AND NOT idNo=".$_SESSION['idNo']." LIMIT 10";
$data = $database_master->querySearch($query, 'employee');
echo json_encode($data);
} else if($_GET['type'] == 'nodeName'&&!empty($_GET['name_startsWith'])){
$database_master = new DatabaseMaster();
$query = "SELECT nodeName FROM node WHERE nodeName LIKE '".strtoupper($_GET['name_startsWith'])."%' LIMIT 10";
$data = $database_master->querySearch($query, 'nodeName');
echo json_encode($data);
}
?>