This script handles fulltext-search. More...
Go to the source code of this file.
Functions | |
generateWhereClause ($columns, $searchterm, $findSimilar=SEARCH_NORMAL) | |
searchDatabase ($searchColumns, $searchTerm, $findSimilar=SEARCH_NORMAL, $logicMode=LOGIC_NONE) | |
Variables | |
const | SEARCH_EXTENDED 1 |
Marker for extended search on the database. More... | |
const | SEARCH_NORMAL 2 |
Marker for normal search on the database. More... | |
const | SEARCH_STRICT 3 |
Marker for normal search on the database. More... | |
const | LOGIC_AND (-1) |
Marker for linking results with AND. More... | |
const | LOGIC_OR 1 |
Marker for linking results with OR. More... | |
const | LOGIC_NONE 0 |
Marker for nor splitting the result in linkable partzs. More... | |
const | HIGHLIGHT_ON 1 |
Marker to indicate that the user wants to use highlighting. More... | |
const | HIGHLIGHT_OFF 0 |
Marker to indicate that the user doesn't want to use highlighting. More... | |
This script handles fulltext-search.
This script handles fulltext search. It's capable of searching the database for one or more searchterms, storing the results in and perform additional tasks as sorting or preparation for export on these stored results. Currently it's not capable to perform highlighting tasks on its results.
This file depends on inc/common.php and inc/templates/sponsors_search.tpl
Definition in file sponsors_search.php.
generateWhereClause | ( | $columns, | |
$searchterm, | |||
$findSimilar = SEARCH_NORMAL |
|||
) |
Generates a where clause according to the given information
array | $columns | the names of the columns |
string | $searchterm | the actual search term |
integer | $findSimilar |
|
Definition at line 247 of file sponsors_search.php.
References $mysqli, SEARCH_EXTENDED, and SEARCH_STRICT.
Referenced by searchDatabase().
searchDatabase | ( | $searchColumns, | |
$searchTerm, | |||
$findSimilar = SEARCH_NORMAL , |
|||
$logicMode = LOGIC_NONE |
|||
) |
Search the sponsoring database
array | $searchColumns | the names of the colums that should be used for the search |
string | $searchTerm | the keywords to search for |
integer | $findSimilar | [optional]
|
integer | $logicMode | [optional]
|
Definition at line 289 of file sponsors_search.php.
References $db, $mysqli, fetchSponsorLatestEditData(), generateWhereClause(), LOGIC_AND, and LOGIC_OR.
const HIGHLIGHT_OFF 0 |
Marker to indicate that the user doesn't want to use highlighting.
Definition at line 39 of file sponsors_search.php.
const HIGHLIGHT_ON 1 |
Marker to indicate that the user wants to use highlighting.
Definition at line 37 of file sponsors_search.php.
const LOGIC_AND (-1) |
Marker for linking results with AND.
Definition at line 30 of file sponsors_search.php.
Referenced by searchDatabase().
const LOGIC_NONE 0 |
Marker for nor splitting the result in linkable partzs.
Definition at line 34 of file sponsors_search.php.
const LOGIC_OR 1 |
Marker for linking results with OR.
Definition at line 32 of file sponsors_search.php.
Referenced by searchDatabase().
const SEARCH_EXTENDED 1 |
Marker for extended search on the database.
Definition at line 23 of file sponsors_search.php.
Referenced by generateWhereClause().
const SEARCH_NORMAL 2 |
Marker for normal search on the database.
Definition at line 25 of file sponsors_search.php.
const SEARCH_STRICT 3 |
Marker for normal search on the database.
Definition at line 27 of file sponsors_search.php.
Referenced by generateWhereClause().