include('connection.php'); //include of db config file include ('paginate.php'); //include of paginat page extract($_POST); if(isset($save)) { //check user already exists or not $q=mysql_query("select email from users where email='$e'"); $r=mysql_num_rows($q); if($r){ echo "$e already exists"; } else{
$per_page = 5; // number of results to show per page
$result = mysql_query("SELECT * FROM users");
$total_results = mysql_num_rows($result);
$total_pages = ceil($total_results / $per_page);//total pages we going to have
//-------------if page is setcheck------------------//
if (isset($_GET['tpages']))
{
$show_page = $_GET['tpages']; //it will telles the current page
if ($show_page > 0 && $show_page <= $total_pages) {
$start = ($show_page - 1) * $per_page;
$end = $start + $per_page;
} else {
// error - show first set of results
$start = 0;
$end = $per_page;
}
} else {
// if page isn't set, show first set of results
$start = 0;
$end = $per_page;
}
// display pagination
$page = intval($_GET['tpages']);
$tpages=$total_pages;
if ($page <= 0)
$page = 1;
//$query=mysql_query("select * from users"); for ($i = $start; $i < $end; $i++) { if ($i == $total_results) { break; } ?> " width="40px" />