Annotation of db/prgsrc/new/old_style.php, revision 1.1
1.1 ! roma7 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'])?>'> Все слова: <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>
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>