"; $bgcolor=" BGCOLOR=#EBEBF0"; if ( !isset($adv) ) { $adv=""; } if ( $adv=="yes" ) { // advanced search unset($year_ar); $year_ar[""]="все года"; $first_year=1995; $this_year=2004; $i=$this_year; while ( $i>$first_year ) { $year_ar[$i]=$i; $i--; } if ( !isset($year) ) { $year=""; } $a="no"; reset($year_ar); while( list($key,$val)=each($year_ar) ) { if ( $year==$key ) { $a=""; break; } } if ( $a ) { $year=""; } } else { $adv=""; $year=""; } if ( !isset($q) ) { $q=""; } $what=urldecode($q); $mes_error=""; unset($db_id); $Kolvo=0; $KolvoPage=0; $Vivod1=0; $Vivod2=0; $table0="rl_opis01"; require ($database_connection_file); if ( $dbh ) { $step=20; if ( !isset($fs) ) { $fs=0; } else { $fs=intval($fs); } unset($ar_where); // text search $MinTextValue=3; $MaxTextValue=32; $MaxWords=5; $what=chop(trim($what)); unset($ar); if ( strlen($what)>=$MinTextValue ) { $what=substr($what,0,$MaxTextValue); $q=urlencode($what); unset($ar_what); $what1=$what; $what1=str_replace("ё","е",$what1); $what1=str_replace("Ё","Е",$what1); $what1=ereg_replace("[^A-Za-zА-Яа-я0-9]"," ",$what1); $ar_what=explode(" ",$what1); $LastMaxWord=""; reset($ar_what); $i=0; while( list($key,$val)=each($ar_what) ) { $val0=chop(trim($val)); if ( strlen($val0)<$MinTextValue or $i>=$MaxWords ) { unset($ar_what[$key]); } else { $ar[]="(CONCAT(ptex1,' ',ptex2,' ',ptex3,' ',name1,' ',description) LIKE '%".$val0."%')"; $i++; if ( $i>=$MaxWords ) { $LastMaxWord=$val0; } } } if ( isset($ar) ) { $a=implode($ar," AND "); $ar_where[]=$a; } } if ( !isset($ar) ) { $mes_error="Для поиска необходимо ввести не менее $MinTextValue символов"; } // text search $ar_where[]="rz='$rz'"; if ( $adv=="yes" ) { if ( $year ) { $ar_where[]="pint1='$year'"; } } $where=implode(" AND ",$ar_where); $where="WHERE ".$where; $SQL="SELECT count(*) AS Kolvo FROM $table0 $where"; // print $SQL; $result=mysql_query($SQL); if ($result) { $Kolvo=mysql_result($result,0,"Kolvo"); mysql_free_result($result); $tord="ORDER BY datad DESC"; $SQL="SELECT * FROM $table0 $where $tord LIMIT $fs,$step"; $result=mysql_query($SQL); if ( $result ) { unset($row); while( $row=mysql_fetch_array($result) ) { $a=$row["id"]; $db_id[$a]=$a; $db_name[$a]=$row["ptex1"]; $db_author[$a]=$row["ptex2"]; $db_ser[$a]=$row["ptex3"]; $db_isbn[$a]=$row["name1"]; $db_year[$a]=$row["pint1"]; $db_desc[$a]=$row["description"]; $db_imgs[$a]=$row["pchr1"]; } mysql_free_result($result); if ( isset($db_id) ) { $KolvoPage=count($db_id); if ( $KolvoPage ) { $Vivod1=$fs+1; if ( $KolvoPage>1 ) { $Vivod2=$fs+$KolvoPage; } if ( $what ) { if ( !$mes_error ) { $Meta_Title=$what." ".$Meta_Title; $Meta_Description=$what." ".$Meta_Description; $Meta_Keywords=$what." ".$Meta_Keywords; } } } } } } } require ("$path_docs_t/include/top.php"); ?>
Warning: Undefined variable $bgcolor in /home/stroylocman/www/htdocs/books.html on line 171
> $t"; } else { print "$t"; } ?>

Warning: Undefined variable $bgcolor in /home/stroylocman/www/htdocs/books.html on line 193
>

Warning: Undefined variable $adv in /home/stroylocman/www/htdocs/books.html on line 198
 

Warning: Undefined variable $adv in /home/stroylocman/www/htdocs/books.html on line 214

Warning: Undefined variable $PHP_SELF in /home/stroylocman/www/htdocs/books.html on line 218
расширенный поиск +

"$what"
"; if ( $mes_error ) { print "$mes_error
"; } } if ( $adv=="yes" ) { if ( $year ) { print "Год выпуска: $year
"; } } ?>

Warning: Undefined variable $bgcolor in /home/stroylocman/www/htdocs/books.html on line 252
> $Kolvo"; if ( $Vivod1 ) { print "   Вывод: $Vivod1"; if ( $Vivod2>$Vivod1 ) { print " - $Vivod2"; } print "
"; } ?>

Сервер базы данных не доступен.
Попробуйте еще раз или попозже.

"; } else { if ( isset($db_id) ) { reset($db_id); print ""; while( list($key,$val)=each($db_id) ) { print ""; } print "
"; if ( $db_imgs[$key] ) { $a=str_replace('"',"",$db_name[$val]); print "\"$a\""; } print "".$db_name[$val]."
"; unset($ar); if ( $db_author[$val] ) { $ar[]=$db_author[$val]; } if ( $db_year[$val] ) { $ar[]="(".$db_year[$val].")"; } if ( isset($ar) ) { $a=implode(" ",$ar); print "$a
"; } if ( $db_desc[$val] ) { $a=substr($db_desc[$val],0,160); print $a." ...
"; } print "
"; print "Подробнее >>

"; print "
"; if ( $Kolvo>$step ) { ?> Warning: Undefined variable $bgcolor in /home/stroylocman/www/htdocs/books.html on line 312
> 0) { $i=(10*$idown-1)*$step+1; $j=-1; } else { $i=1; $j=0; } $Kolvo1=$Kolvo+1; while ( $i<$Kolvo1 ) { $i0=$i-1; if ($i0==$fs) { print "$i"; } else { $query="q=$q&fs=$i0&adv=$adv&year=$year"; $queryDef="&0&&"; $query=MS_Search_Query($query,$queryDef); print ""; if ($j==10) { print "След.>>"; } else { if ($j==-1) { print "<<Пред."; } else { print $i; } } print ""; } print " "; $i=$i+$step; if ( $j==10 ) { break; } $j++; } ?>