I need some help regarding pagination. whenever i searched for a record, the pagination doesnt work but it still show the results. here are my codes


		<title>Paginating Your Data with AJAX and Awesome PHP Pagination Class</title>
<form action="index.php" method="post" name="searchdb" id="searchdb">
<input type="text" name="searchdb" id="searchdb" size="25" />&nbsp;
<input type="submit" name="submit" id="submit" value="Go!" /></td>


<div id='retrieved-data'>
	this is where data will be  shown
    <img src="images/ajax-loader.gif" />

<script type = "text/javascript" src = "js/jquery-1.4.js"></script>
<script type = "text/javascript">
$(function() {
	//call the function onload
	getdata( 1 );

function getdata( pageno ){

	var targetURL = 'search_results.php?page=' + pageno;   

	$('#retrieved-data').html('<p><img src="images/ajax-loader.gif" /></p>');        
	$('#retrieved-data').load( targetURL ).hide().fadeIn('slow');



<!-- include style -->
<link rel="stylesheet" type="text/css" href="styles/style.css" />
//open database
include 'config_open_db.php';
//include our awesome pagination
//class (library)
include 'libs/ps_pagination.php';

//query all data anyway you want

$searchdb = $_POST['searchdb'];

// make the query

$sql = "SELECT * from employer
WHERE username LIKE '%$searchdb%' order by user_id";
//$result = @mysql_query($query); // run query

//if ($searchdb) {

//$sql = "select * from employer ORDER BY username DESC";

//execute query and get and

$rs = mysql_query( $sql ) or die('Database Error: ' . mysql_error() . ' ' . $sql );

//now, where gonna use our pagination class
//this is a significant part of our pagination
//i will explain the PS_Pagination parameters
//$conn is a variable from our config_open_db.php
//$sql is our sql statement above
//3 is the number of records retrieved per page
//4 is the number of page numbers rendered below
//null - i used null since in dont have any other
//parameters to pass (i.e. param1=valu1&param2=value2)
//you can use this if you're gonna use this class for search
//results since you will have to pass search keywords
$pager = new PS_Pagination( $conn, $sql, 3, 4, null );

//our pagination class will render new
//recordset (search results now are limited
//for pagination)
$rs = $pager->paginate(); 

//get retrieved rows to check if
//there are retrieved data
$num = mysql_num_rows( $rs );

if($num >= 1 ){     
	//creating our table header
	echo "<table id='my-tbl'>";
	echo "<tr>";
		echo "<th>UsernameFirstname</th>";
		echo "<th>Lastname</th>";
		echo "<th>Firstname</th>";
	echo "</tr>";
	//looping through the records retrieved
	while($row = mysql_fetch_array( $rs )){
		echo "<tr class='data-tr' align='center'>";
		echo "<td>{$row['username']}</td>";
		echo "<td>{$row['lastname']}</td>";
		echo "<td>{$row['firstname']}</td>";
		echo "</tr>";
	echo "</table>";
	//if no records found
	echo "No records found!";
//page-nav class to control
//the appearance of our page 
//number navigation
echo "<div class='page-nav'>";
	//display our page number navigation
	echo $pager->renderFullNav();
echo "</div>";


But i don't understand what pagination has to do with database design. That should be handled at application level.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.