include "db.php";
include "common.php";
$searchin=@$_GET['searchin'] or
$searchin=array('Question'=>1,'Answer'=>1,'PassCriteria'=>1);
$and=@$_GET['all_words'] or $and=false;
?>
Подстрочный поиск по базе вопросов
if (@$_GET['sstr']) {
include "db.php";
$sstr=stripslashes($_GET['sstr']);
$sstr=trim($sstr);
$swords=preg_split('/\s+/',$sstr);
$g=addslashes($sstr);
foreach (array_keys($searchin) as $k=>$v) {
$fields[]="IFNULL($v,'')";
}
$fields=implode(',',$fields);
foreach ($swords as $v) {
$where_array[]="CONCAT($fields) LIKE '%".addslashes($v)."%'";
}
$where=implode(($and?' AND ':' OR '),$where_array);
$sql="SELECT t.FileName as tFileName, t1.FileName as t1FileName, q.*, t.Id as tid,t1.id as ttid, t.Title as ttitle,t1.title as tttitle FROM Questions q LEFT JOIN Tournaments t
ON (q.ParentId=t.Id) LEFT JOIN Tournaments t1 ON (t.ParentId=t1.Id)
WHERE $where LIMIT 500";
print_questions_sql($sql,true);
} else {
?>
}?>
Поиск производится по копии базы от