rendered paste body// Request mode: qsearch (side panel search)
if ($_REQUEST['mode'] == 'qsearch') {
if ($_POST) {
// Build query string based on user's input
if (isset($_POST['lastname'])) {
$lastname = $_POST['lastname'];
$lastnameSQL = "AND last_name LIKE '%$lastname%'";
} else { $lastnameSQL = ""; }
if (isset($_POST['ext'])) {
$ext = $_POST['ext'];
$extSQL = "AND ext LIKE '%$ext%'";
} else { $extSQL = ""; }
if (isset($_POST['section'])) {
$dept = $_POST['section'];
$deptSQL = "AND dept LIKE '%$dept%'";
} else { $deptSQL = ""; }
$query = "SELECT * FROM staff WHERE 1=1 $lastnameSQL $extSQL $deptSQL";
$result = $db->query($query);
}
}