PHP search_parse_keywords Examples

Example #1

File: search.php Project: narasimhaeabyas/tataaiapro

                "' (".get_string('capacity', 'facetoface').": '", 'r.capacity', "')'");

        $search_info->sql = "
            FROM
                {facetoface_room} r
            WHERE
                {$searchsql}
                AND r.custom = 0
        ";

        $search_info->order = " ORDER BY r.name ASC";
        $search_info->params = $params;
        break;

    case 'this':
        $keywords = search_parse_keywords($query);
        $this->put_search_info($search_info, $formdata, $keywords);
        break;

    default:
        print_error('invalidsearchtable222', 'local_core');
}

// Generate forn markup
// Create form
$mform = new dialog_search_form(null, $formdata);

// Display form
$mform->display();

Example #2

File: editattendees.php Project: narasimhaeabyas/tataaiapro

    $requireapproval = (search_for_value($attendees, 'statuscode', SEARCH_OP_EQUAL, MDL_F2F_STATUS_REQUESTED)) ? 1 : 0;

}

// Main page
$attendeescount = count($attendees);

$where = "username <> 'guest' AND deleted = 0 AND suspended = 0 AND confirmed = 1";
$params = array();

// Apply search terms
$searchtext = trim($searchtext);
if ($searchtext !== '') {   // Search for a subset of remaining users
    $fullname  = $DB->sql_fullname();
    $fields = array($fullname, 'email', 'idnumber', 'username');
    $keywords = search_parse_keywords($searchtext);
    list($searchwhere, $searchparams) = search_get_keyword_where_clause($keywords, $fields);

    $where .= ' AND ' . $searchwhere;
    $params = array_merge($params, $searchparams);
}

if($designation !=='' && $designation !=='null'){
   
       $designations= implode("','",$designation);
   if($designations !=='null' && $designations !=='all'){ 
       $where .= " AND ud.designation IN('{$designations}')"; 
    }
   if($designations =='all'){
     $design=list_departments();
     $alldesignation= implode("','",$design);