function SelectPersonDependents() { $where = "1=1"; $whereParam = array(); //................................. if (!empty($_REQUEST["from_StaffID"])) { $where .= " AND s.staff_id>=:fpid"; $whereParam[":fpid"] = $_REQUEST["from_StaffID"]; } if (!empty($_REQUEST["to_StaffID"])) { $where .= " AND s.staff_id<=:tpid"; $whereParam[":tpid"] = $_REQUEST["to_StaffID"]; } if (!empty($_REQUEST["pfname"])) { $where .= " AND p.pfname like :pfname"; $whereParam[":pfname"] = "%" . $_REQUEST["pfname"] . "%"; } if (!empty($_REQUEST["plname"])) { $where .= " AND p.plname like :plname"; $whereParam[":plname"] = "%" . $_REQUEST["plname"] . "%"; } $no = count(manage_person_dependency::GetAllDepSupports($where, $whereParam)); $temp = manage_person_dependency::GetAllDepSupports($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }