function selectMiscDoc() { $where = " PersonID = :PID "; $whereParam = array(); $whereParam[":PID"] = $_GET["Q0"]; $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "title": $where .= " AND title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "doc_no": $where .= " AND doc_no=:qry "; $whereParam[":qry"] = $_GET["query"]; break; case "row_no": $where .= " AND row_no=:qry "; $whereParam[":qry"] = $_GET["query"]; break; } } $no = manage_person_misc_doc::CountMiscDoc($where, $whereParam); $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $temp = manage_person_misc_doc::GetAllMiscDoc($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }