Results here: [LOCAL HOST!]";
else $resultHeader = " Results here:";
$doubleDIV = "
please check back again later.
"; else die($noSurfer); if($_GET){ $searchMode = $_GET['searchMode']; $regExps = $_GET['regExps']; $dq = '"'; //double quotes //set search specific variables for HU MySQL-server (replace apostrophe with backslash-apostrophe in search): if ($surfer == "hu") { $smj = str_replace("'","\'",$_GET['smj']); $smjExact = str_replace("'","\'",$_GET['smjExact']); $PoS = str_replace("'","\'",$_GET['PoS']); $nob = str_replace("'","\'",$_GET['nob']); $sve = str_replace("'","\'",$_GET['sve']); $eng = str_replace("'","\'",$_GET['eng']); if ($searchMode == "advanced"){ $root = str_replace("'","\'",$_GET['root']); $lemma = str_replace("'","\'",$_GET['lemma']); $conCenter = str_replace("'","\'",$_GET['conCenter']); $gradeChange = str_replace("'","\'",$_GET['gradeChange']); }; } //set search specific variables for me MySQL-server (NOT replace apostrophe with backslash-apostrophe in search): else { $smj = $_GET['smj']; $smjExact = $_GET['smjExact']; $PoS = $_GET['PoS']; $nob = $_GET['nob']; $sve = $_GET['sve']; $eng = $_GET['eng']; if ($searchMode == "advanced"){ $root = $_GET['root']; $lemma = $_GET['lemma']; $conCenter = $_GET['conCenter']; $gradeChange = $_GET['gradeChange']; }; }; //set emptyRequest variable for output of warning that all records are being shown if ($smj==""&&$PoS==""&&$nob==""&&$sve==""&&$eng==""&&$root==""&&$lemma==""&&$conCenter==""&&$gradeChange=="") $emptyRequest = 1; else $emptyRequest = 0; // connect to database if($connect){ if ($surfer=="hu") $toDB = mysql_select_db("updp",$connect); else if ($surfer=="me") $toDB = mysql_select_db("smjDATA",$connect); else die($noSurfer); if($toDB){ mysql_set_charset('utf8',$connect); // to include NULL data in the search, IF necessary as follows; smj search for EXACT hits also defined: if ($smj=="") $querySMJ = "(smj IS NULL OR smj LIKE '%')"; else if ($searchMode == "advanced" && $smjExact=="y") $querySMJ = "smj LIKE '" . $smj . "'"; else if ($regExps == "y") $querySMJ = "smj REGEXP '" . $smj . "'"; else $querySMJ = "smj LIKE '" . $smj . "%'"; if ($PoS!=""&&$regExps=="y") $querySMJPoS = "smj_pos REGEXP '".$PoS."'"; else if ($PoS!="") $querySMJPoS = "smj_pos LIKE '" . $PoS . "%'"; else $querySMJPoS = "(smj_pos IS NULL OR smj_pos LIKE '%')"; if ($PoS!=""&&$regExps=="y") $queryPoS = "pos REGEXP '".$PoS."'"; else if ($PoS!="") $queryPoS = "pos LIKE '" . $PoS . "%'"; else $queryPoS = "(pos IS NULL OR pos LIKE '%')"; if ($nob!=""&&$regExps=="y") $queryNOB = "nob1 REGEXP '".$nob."'"; else if ($nob!="") $queryNOB = "nob1 LIKE '" . $nob . "%'"; else $queryNOB = "(nob1 IS NULL OR nob1 LIKE '%')"; if ($sve!=""&&$regExps=="y") $querySVE = "sve1 REGEXP '".$sve."'"; else if ($sve!="") $querySVE = "sve1 LIKE '" . $sve . "%'"; else $querySVE = "(sve1 IS NULL OR sve1 LIKE '%')"; if ($eng!=""&&$regExps=="y") $queryENG = "eng1 REGEXP '".$eng."'"; else if ($eng!="") $queryENG = "eng1 LIKE '" . $eng . "%'"; else $queryENG = "(eng1 IS NULL OR eng1 LIKE '%')"; if ($searchMode == "advanced"){ if ($root!=""&&$regExps=="y") $queryRoot = "root REGEXP '".$root."'"; else if ($root!="") $queryRoot = "root LIKE '" . $root . "%'"; else $queryRoot = "(root IS NULL OR root LIKE '%')"; if ($lemma!=""&&$regExps=="y") $queryLemma = "lemma REGEXP '".$lemma."'"; else if ($lemma!="") $queryLemma = "lemma LIKE '" . $lemma . "%'"; else $queryLemma = "(lemma IS NULL OR lemma LIKE '%')"; if ($conCenter!=""&&$regExps=="y") $queryConCenter = "con_center REGEXP '".$conCenter."'"; else if ($conCenter!="") $queryConCenter = "con_center LIKE '" . $conCenter . "%'"; else $queryConCenter = "(con_center IS NULL OR con_center LIKE '%')"; if ($gradeChange!=""&&$regExps=="y") $queryGradeChange = "grade_change REGEXP '".$gradeChange."'"; else if ($gradeChange!="") $queryGradeChange = "grade_change LIKE '" . $gradeChange . "%'"; else $queryGradeChange = "(grade_change IS NULL OR grade_change LIKE '%')"; // the actual query here for ADVANCED search: $query = "SELECT * FROM smjTable WHERE " . $querySMJ . " AND " . $queryPoS . " AND " . $queryNOB . " AND " . $querySVE . " AND " . $queryENG . " AND " . $queryRoot . " AND " . $queryLemma . " AND " . $queryConCenter . " AND " . $queryGradeChange ;} //the actual query here for BASIC: else $query = "SELECT * FROM smjTable WHERE " . $querySMJ . " AND " . $queryPoS . " AND " . $queryNOB . " AND " . $querySVE . " AND " . $queryENG ; // set array of results from query: $results = mysql_query($query); $qtyHits = mysql_num_rows($results); // set headers for results after query, using dynamic width based on javascript variable resultsBreite set in page header: if ($emptyRequest==0) $doubleDIV = "MySQL search query:
" . $query."
".$windowSize."
"; else $showQuery = ""; // if no hits for search: if( $qtyHits == 0 ) echo $resultHeader."".$doubleDIV.$showQuery."Sorry, no hits.
" ; // warning for all records being shown: else { if ($emptyRequest==1) echo $resultHeader."".$doubleDIV.$clickHint; // actual output of search results: else if ($qtyHits==1) echo $resultHeader." (".$qtyHits." hit)".$clickHint."".$doubleDIV.$showQuery."".$doubleDIV.$showQuery."" ; } } echo "