<?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 \n\t\t\tWHERE (firstName LIKE '" . strtoupper($_GET['name_startsWith']) . "%'\n\t\t\tOR lastName LIKE'" . strtoupper($_GET['name_startsWith']) . "%'\n\t\t\tOR CONCAT(firstName, ' ', lastName) LIKE'" . strtoupper($_GET['name_startsWith']) . "%'\n\t\t\tOR idNo LIKE '" . strtoupper($_GET['name_startsWith']) . "%') \n\t\t\tAND 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); } } }