Изкарва ми само Не си избрал страница
Код:
<?php
echo ('
<div id="rightbar"><br />
<center>
Търсене на потребител:<br />
<form action="search.php" method="post">
<input type="text" name="search" size="35" />
<input type="submit" value="Търси" name="submit" />
</form>
</center>
<table width="97%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="border1" valign="top">');
//$ns - номер страница
//$br - брой страница
//$one - първа
//$sl - следваща
//$pl - последна
//$pr - предишна
$br = 15;
$pageNum = 1;
if(isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
if($_POST['search']) {
$search = htmlspecialchars(mysql_real_escape_string(addslashes($_POST['search'])));
$redove = ($pageNum - 1) * $br;
$query = "SELECT * FROM users WHERE username LIKE '%$search%' OR skype LIKE '%$search%' "." LIMIT $redove, $br";
$result = mysql_query($query) or die('Не си избрал страница!');
while($row = mysql_fetch_array($result)) {
echo ('
<table border="1" width="100%" style="border: 1px solid #c0c0c0;border-collapse:collapse;" align="center">
<tr><td align="center"><b>Потребител</b></td><td align="center"><b>E-mail</b></td><td align="center"><b>Скайп</b></td><td align="center"><b>PM</b></td></tr>
<tr>
<td>
<a href="profile.php?id='.$row['id'].'">'.$row['username'].'</a>
</td>
<td align="center"><a href="mailto:'.$row['email'].'"><img src="images/icon_email.gif" border="0"></a></td>
<td align="center"><a rel="nofollow" href="skype:'.$row['skype'].'?userinfo" ><img width=16 height=16 src="http://mystatus.skype.com/smallicon/'.$row['skype'].'" alt="Skype" title="Skype" border="0" /> '.$row['skype'].'</a></td>
<td align="center"><a href="sendpm.php?id='.$row['id'].'"><img src="images/icon_pm.gif" border="0"></a></td>
');
}}
echo ("</tr>
</table>
<br /><center>");
$query = "SELECT COUNT(id) AS numrows FROM users";
$result = mysql_query($query) or die('Не си избрал страница!');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$br);
$self = $_SERVER['PHP_SELF'];
$ns = '';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$ns .= " $page ";
}
else {
$ns .= " <a href=\"$self?page=$page\">$page</a> ";
}}
if ($pageNum > 1) {
$page = $pageNum - 1;
$pr = " <a href=\"$self?page=$page\"> [<] </a> ";
$one = " <a href=\"$self?page=1\">[първа]</a> ";
}
else {
$pr = ' ';
$one = ' ';
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sl = (" <a href=\"$self?page=$page\"> [>] </a> ");
$pl = (" <a href=\"$self?page=$maxPage\">[последна]</a> ");
}
else {
$sl = '';
$pl = '';
}
echo $one . $pr . $ns . $sl . $pl;
echo ('
</center></td>
</tr>
</table></div>
<div id="footer">
Copyright (c) <a href="http://web-tourist.net/forum/profile.php?mode=viewprofile&u=nom3r1"><b>nom3r1</b></a>
</div>
</div>
</center>
</body>
</html>');
?>