<?php 
include ('conn.php'); 
// how many rows to show per page 
$rowsPerPage = 10; 
// by default we show first page 
$pageNum = 1;
// if $_GET['page'] defined, use it as page number 
if(isset($_GET['page'])) 
{ 
$pageNum = $_GET['page']; 
} 
// counting the offset 
$offset = ($pageNum - 1) * $rowsPerPage;
//$searchresult = array(); 
$var = $_REQUEST['keyword'] ; 
$trimmed = trim($var); 
// rows to return 
 
 
// check for an empty string and display a message. 
if ($trimmed == "") 
{ 
echo "<p>Please enter a search...</p>"; 
exit; 
} 
 
// check for a search parameter 
if (!isset($var)) 
{ 
echo "<p>We dont seem to have a search parameter!</p>"; 
exit; 
} 
 
//$table ="results"; 
$query ="select count(*) from medlist where dispname like '%".$trimmed."%'"; 
$rsid = mysql_query($query); 
if(!$rsid){die(mysql_error());}
$resArr = mysql_fetch_row($rsid); 
$numrows = $resArr[0]; 
 
//$query ="select * from medlist where dispname like '%".$trimmed."%' limit $strpos, $rowsPerPage"; 
$query = "select * from medlist where dispname like '%".$trimmed."%' LIMIT ". $start .", ". 
$rowsPerPage ;
$result = mysql_query($query); 
if(!$result){die(mysql_error());}
//$query = "SELECT val FROM randoms LIMIT $offset, $rowsPerPage"; 
//$result = mysql_query($query) or die('Error, query failed'); 
 
while($val = mysql_fetch_row($result)) 
{ 
print_r($val); 
} 
 
echo '<br>'; 
 
 
$maxPage = ceil($numrows/$rowsPerPage); 
 
$self = $_SERVER['PHP_SELF']; 
if ($pageNum > 1) 
{ 
$page = $pageNum - 1; 
$prev = " <a href=\"$self?page=$page&keyword=$var\">[Prev]</a> "; 
 
$first = " <a href=\"$self?page=1&keyword=$var\">[First Page]</a> "; 
} 
else 
{ 
$prev = ' [Prev] '; // we're on page one, don't enable 'previous' link 
$first = ' [First Page] '; // nor 'first page' link 
} 
 
if ($pageNum < $maxPage) 
{ 
$page = $pageNum + 1; 
$next = " <a href=\"$self?page=$page&keyword=$var\">[Next]</a> "; 
$last = " <a href=\"$self?page=$maxPage&keyword=$var\">[Last Page]</a> "; 
} 
else 
{ 
$next = ' [Next] '; // we're on the last page, don't enable 'next' link 
$last = ' [Last Page] '; // nor 'last page' link 
} 
echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last; 
?>

<?php 
include ('conn.php');
 
// by default we show first page 
$page = 1; 
 
// if $_GET['page'] defined, use it as page number 
if(isset($_GET['page'])) 
{ 
$page = $_GET['page']; 
} 
// counting the offset 
$offset = ($page - 1) * $rowsPerPage; 
 
 
//$searchresult = array(); 
$var = $_POST['keyword'] ; 
$trimmed = trim($var); 
 
// rows to return 
$limit=10; 
 
$str = "select * from medlist where dispname like '%".$trimmed."%'"; 
echo $str.'<br>';
$res= mysql_query($str); 
if(!$res){die(mysql_error());}
$num_rows= mysql_num_rows($res); 
echo $num_rows.'<br>';
 
// how many rows to show per page 
$rowsPerPage =10; 
$maxPage = ceil($num_rows/$rowsPerPage);
//$page=(isset($_GET['page']))?$_GET['page']:1;
//$offset=($page-1)*$rowsPerPage;
 
$query = "select * from medlist where dispname like '%".$trimmed."%' limit $offset,$rowsPerPage";
$result = mysql_query($query);
//<a href=page.php?search=$string&offset=$offset>
if(!$result){die(mysql_error());}
while($data = mysql_fetch_array($result)) { 
 
    echo ' <tr> <td colspan="3" > <a href="'.$data['MedName'].'" >' . $data['dispname'].' </a> </td>'; 
    echo'</tr>'; 
}
echo "<tr><td align='left' colspan='2'>Result Pages:";
for($i=1;$i<=$maxPage;$i++)
 {
 
   echo "<a href=pagno.php?rowsPerPage=$rowsPerPage&page=$i>".$i."&nbsp;|&nbsp;";
 }   
echo "</td>
<td>Showing page <strong>".$page."</strong> of <strong>".$maxPage."</strong> pages </td>
</tr>";	
 
?>

// counting the offset 
$offset = ($page - 1) * $rowsPerPage;

// how many rows to show per page 
$rowsPerPage =10;

$showfromthisid = ceil($pagenumber*10) -10;
$maxshownmessages = 10;
 
$result = mysql_query("SELECT * FROM table ORDER BY id DESC LIMIT $showfromthisid,$maxshownmessages") or die(mysql_error());