Велоси-поиск

<div class="box">
<blockquote>
<h2>Что ищем? а? </h2>
<?PHP
$words = mysql_real_escape_string($_GET['keywords']);
$result = mysql_query("SELECT * from `mir_users` WHERE `login` LIKE '%$words%'");
$scp = @mysql_numrows($result);
$result = mysql_query("SELECT * from `mir_blogs` WHERE `name` LIKE '%$words%'");
$scb = @mysql_numrows($result);
$result = mysql_query("SELECT * from `mir_historys` WHERE `name` LIKE '%$words%'");
$sch = @mysql_numrows($result);
$result = mysql_query("SELECT * from `mir_musics` WHERE `name` LIKE '%$words%'");
$scm = @mysql_numrows($result);
$result = mysql_query("SELECT * from `mir_clubs` WHERE `name` LIKE '%$words%'");
$scc = @mysql_numrows($result);

?>
<a href="?keywords=<?PHP echo $words; ?>&search=people"><font size="6">Люди&nbsp;(<?PHP echo $scp; ?>)</font></a>
&nbsp;→&nbsp;
<a href="?keywords=<?PHP echo $words; ?>&search=blog"><font size="5">Блоги&nbsp;(<?PHP echo $scb; ?>)</font></a>
&nbsp;→&nbsp;
<a href="?keywords=<?PHP echo $words; ?>&search=history"><font size="4">Истории&nbsp;(<?PHP echo $sch; ?>)</font></a>
&nbsp;→&nbsp;
<a href="?keywords=<?PHP echo $words; ?>&search=music"><font size="3">Музыка&nbsp;(<?PHP echo $scm; ?>)</font></a>
&nbsp;→&nbsp;
<a href="?keywords=<?PHP echo $words; ?>&search=club"><font size="2">Сообщества&nbsp;(<?PHP echo $scc; ?>)</font></a>
<br>
<?PHP
$search = mysql_real_escape_string($_GET['search']);
$sort = mysql_real_escape_string($_GET['sort']);
//Что ищем (где)
switch($search){
case "people" :
$sql = "SELECT * from `mir_users` WHERE `login` LIKE '%$words%%'";
$query = "SELECT COUNT(*) as num FROM `mir_users` WHERE `login` LIKE '%$words%'";
break;
case "blog" :
$sql = "SELECT * from `mir_blogs` WHERE `name` LIKE '%$words%%'";
$query = "SELECT COUNT(*) as num FROM `mir_blogs` WHERE `name` LIKE '%$words%'";
break;
case "history" :
$sql = "SELECT * from `mir_historys` WHERE `name` LIKE '%$words%%'";
$query = "SELECT COUNT(*) as num FROM `mir_historys` WHERE `name` LIKE '%$words%'";
break;
case "music" : $sql = "SELECT * from `mir_musics` WHERE `name` LIKE '%$words%'";
$query = "SELECT COUNT(*) as num FROM `mir_musics` WHERE `name` LIKE '%$words%'";
break;
case "club" : $sql = "SELECT * from `mir_clubs` WHERE `name` LIKE '%$words%'";
$query = "SELECT COUNT(*) as num FROM `mir_clubs` WHERE `name` LIKE '%$words%'";
break; //получается, что выводит все данные
}
//Как сортируем SQL
if($search == "people"){
switch($sort){
case "1" : $sort = " ORDER by `n` ASC"; break;
case "2" : $sort = " ORDER by `n` DESC"; break;
case "3" : $sort = " ORDER by `login` ASC"; break;
case "4" : $sort = " ORDER by `login` DESC"; break;
default : $sort = ""; //выведет все
}
}
if($search == "blog"){
switch($sort){
case "1" : $sort = " ORDER by `id` ASC"; break;
case "2" : $sort = " ORDER by `id` DESC"; break;
case "3" : $sort = " ORDER by `name` ASC"; break;
case "4" : $sort = " ORDER by `name` DESC"; break;
default : $sort = ""; //выведет все
}
}
if($search == "music"){
switch($sort){
case "1" : $sort = " ORDER by `id` ASC"; break;
case "2" : $sort = " ORDER by `id` DESC"; break;
case "3" : $sort = " ORDER by `name` ASC"; break;
case "4" : $sort = " ORDER by `name` DESC"; break;
default : $sort = ""; //выведет все
}
}
if($search == "history"){
switch($sort){
case "1" : $sort = " ORDER by `id` ASC"; break;
case "2" : $sort = " ORDER by `id` DESC"; break;
case "3" : $sort = " ORDER by `name` ASC"; break;
case "4" : $sort = " ORDER by `name` DESC"; break;
default : $sort = ""; //выведет все
}
}
echo ("Сортировать:&nbsp;");
//Выод линков HTML
if($search == "people"){
echo ("<a href='?keywords=".$words."&search=people&sort=1'>по номеру ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=people&sort=2'>по номеру ↓</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=people&sort=3'>по логину ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=people&sort=4'>по логину ↓</a>");
echo("&nbsp;");
}
if($search == "blog"){
echo ("<a href='?keywords=".$words."&search=blog&sort=1'>по номеру ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=blog&sort=2'>по номеру ↓</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=blog&sort=3'>по названию ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=blog&sort=4'>по названию ↓</a>");
echo("&nbsp;");
}
if($search == "music"){
echo ("<a href='?keywords=".$words."&search=music&sort=1'>по номеру ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=music&sort=2'>по номеру .</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=music&sort=3'>по названию ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=music&sort=4'>по названию ↓</a>");
echo("&nbsp;");
}
if($search == "history"){
echo ("<a href='?keywords=".$words."&search=history&sort=1'>по номеру ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=history&sort=2'>по номеру ↓</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=history&sort=3'>по названию ↑</a>");
echo("&nbsp;|&nbsp;");
echo ("<a href='?keywords=".$words."&search=history&sort=4'>по названию ↓</a>");
echo("&nbsp;");
}
if($search == ""){
echo ("Выберите категорию поиска ^");
}
?>
</blockquote>
<div class="boxContent">
<form action="<?PHP echo $_SERVER['PHP_SELF']; ?>" method="get">
<input type="text" name="keywords" value="<?PHP echo $words; ?>" size="65">
<input type="submit" class="button" value="Искать!">
</form>
<?PHP
//echo ("".$sql." ".$sort."");
$targetpage = $_SERVER['REQUEST_URI']; //Как вывести сюда GET?
$limit = 10;
$total_pages = @mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages["num"];
$stages = 3;
$page = mysql_escape_string($_GET['page']);
if(!is_numeric($page)){$page = 1;}
if($page){
$start = ($page - 1) * $limit;
}else{
$start = 0;
}
$query1 = "".$sql." ".$sort." LIMIT $start, $limit"; //общий
$query2 = mysql_query("".$sql." ".$sort."");
$allnum = @mysql_num_rows($query2);
$result = mysql_query($query1);
$num = @mysql_numrows($result);
if ($page == 0){$page = 1;}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage - 1;
$paginate = '';
if($lastpage > 1)
{
$paginate .= "<div class='paginate'>";
if ($page > 1){
$paginate.= "<a href='$targetpage&page=$prev' style='text-decoration:none;font-size:14px;font-size:14px;'>&nbsp;сюда ← &nbsp;&nbsp;</a>";
}else{
$paginate.= "<span class='disabled' style='text-decoration:none;font-size:14px;'>&nbsp;сюда ←&nbsp;&nbsp;</span>"; }
if ($lastpage < 7 + ($stages * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage&page=$counter'style='text-decoration:none;'><b>$counter</b></a>";}
}
}
elseif($lastpage > 5 + ($stages * 2))
{
if($page < 1 + ($stages * 2))
{
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage&page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage&page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage&page=$lastpage'>$lastpage</a>";
}
elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
{
$paginate.= "<a href='$targetpage&page=1'>1</a>";
$paginate.= "<a href='$targetpage&page=2'>2</a>";
$paginate.= "...";
for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage&page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage&page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage&page=$lastpage'>$lastpage</a>";
}
else
{
$paginate.= "<a href='$targetpage&page=1' style='text-decoration:none;'>1</a>";
$paginate.= "<a href='$targetpage&page=2' style='text-decoration:none;'>2</a>";
$paginate.= "...";
for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage&page=$counter' style='text-decoration:none;'>$counter</a>";}
}
}
}
if ($page < $counter - 1){
$paginate.= "<a href='$targetpage&page=$next' style='text-decoration:none;font-size:14px;'>&nbsp;&nbsp;→ туда&nbsp;</a>";
}else{
$paginate.= "<span class='disabled' style='text-decoration:none;font-size:14px;'>&nbsp;&nbsp;→ туда&nbsp;</span>";
}

$paginate.= "</div>";
}
if(!$allnum){ $allnum = 0; }
echo "<center>";
echo "<h3>Найдено: ".$allnum." элемента(ов)</h3><br>";
echo "</center>";

while($row = @mysql_fetch_array($result))
{
echo $row['name'];
echo ("<br>");
echo $row['login'];
}
if($allnum > 0){
echo $paginate;
}

?>
</div>