[BACK]Return to old_style.php CVS log [TXT] [DIR] Up to [Local Repository] / db / prgsrc / new
File:  [Local Repository] / db / prgsrc / new / Attic / old_style.php
Revision 1.1: download - view: text, annotated - select for diffs - revision graph
Tue Dec 6 15:41:16 2005 UTC (18 years, 5 months ago) by roma7
Branches: MAIN
CVS tags: HEAD
Initial

<?
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;
?><html>
<head>
<title>Подстрочный поиск по базе вопросов</title>
<style>
A, A:link,  A:visited{
	text-decoration: none;
}
p,body,td {
	color : #000000;
	font-size : x-small;
	font-family : Tahoma,Verdana,Arial;
}

H1 {
	font-size: large;
}
</style>

</head>
<body bgcolor="#fff0e0" vlink="#800020">
<form>
<h1>Подстрочный поиск по базе вопросов</h1>
<p><a target="_blank" href='/'>Лёгкий поиск</a></p>

Введите поисковую строку: <input type='text' name='sstr' value='<?=stripslashes($_GET['sstr'])?>'>&nbsp;&nbsp;&nbsp;&nbsp;Все слова: <input name='all_words' type='checkbox' <?=$and?'checked':''?>>
<table border=1>
<td rowspan=2>Искать в полях:</td><td>Вопрос</td><td>Ответ</td><td>Зачёт</td><td>Автор</td><td>Комментарий</td><td>Источники</td></tr>
<td><input type='checkbox' <?=$searchin["Question"]?'checked':''?> name='searchin[Question]'></td>
<td><input type='checkbox' <?=$searchin["Answer"]?'checked':''?> name='searchin[Answer]'></td>
<td><input type='checkbox' <?=$searchin["PassCriteria"]?'checked':''?> name='searchin[PassCriteria]'></td>
<td><input type='checkbox' <?=$searchin["Authors"]?'checked':''?> name='searchin[Authors]'></td>
<td><input type='checkbox' <?=$searchin["Comments"]?'checked':''?> name='searchin[Comments]'></td>
<td><input type='checkbox' <?=$searchin["Sources"]?'checked':''?> name='searchin[Sources]'></td></tr>
</table>
<input type='submit'>
</form>
<?
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 {
?>
<hr><?}?>
<p><font size='-1'><i>Поиск производится по копии базы от <?include "date.txt"?> </i></font></p>
</body>
</html>
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>