<?php
session_start();
if($_SESSION['username'])
{
echo '
<center><a href="messages.php">Private Message </a><br>
<a href="changepassword.php">EditProfile </a><a
href="logout.php">Logout</a><br></center><center>
<br><form method="post" action="members.php">
<input type="text" name="search" size="20" maxlength="20">
<input type="Submit" name="Submit" value="Search">
</form>';
include "connect.php";
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("unable to connect to the database");
mysql_select_db("$db", $db_conn) or die("unable to select the database");
$search = $_POST["search"];
$result = mysql_query("SELECT * FROM users where username LIKE '$search'");
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$name=$r["name"];
$username=$r["username"];
$email=$r["email"];
$web=$r["web"];
$аvatar=$r["avatar"];
echo "<center>Results:<br><table border=1>
<tr><td>$id</td><td>$name</td><td>$username</td><td>$email</td><td>$web</td></
tr>";
}
$broinastranica = 20;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = " SELECT id,name,username,email,web FROM users " .
" LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<center><table
border=1><tr><td>id</td><td>name</td><td>username</td><td>email</td><td>web</t
d></tr><tr>";
while($row = mysql_fetch_array($result))
{
echo
'<td>'.$row['id'].'</td><td>'.$row['name'].'</td><td>'.$row['username'].'</td>
<td>'.$row['email'].'</td><td>'.$row['web'].'</td> <td>'.$row['avatar']'</td></tr>';
}
echo"</table></center>";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\"> [<<] </a> ";
$parva = " <a href=\"$self?page=1\">[First]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\"> [>>] </a> ";
$posledna = " <a href=\"$self?page=$maxPage\">[latter]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
}
else
{
echo "Access Denied Please <a href='login.html'>Login</a>";
}
?>
