<?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;

$q = "show tables";
$r = mysql_query($q);
//$searchresult = array();
$var = $_POST['keyword'] ;
  $trimmed = trim($var);
  
  // rows to return
$limit=10; 

// 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;
  }
  
 while($data = mysql_fetch_array($r)) {
	$table = $data[0]; // get the tablename
	$query = "select * from ".$table." where dispname like '%".$trimmed."%'";
    $result = mysql_query($query);	
	 while($data = mysql_fetch_array($result)) {
	 	//	$searchresult[] = $rows['name'];
         //$var =$rows['dispname'];
		  
 echo '  <tr> <td> <a href="'.$data['MedName'].'" >' . $data['dispname'].' </a> </td>';
		 echo'</tr>'; 
         	
	}  
}
//$query  = "SELECT val FROM randoms LIMIT $offset, $rowsPerPage";
//$result = mysql_query($query) or die('Error, query failed');

while(list($val) = mysql_fetch_array($result))
{
	echo "$val <br>";
}

echo '<br>';


$query   = "select * from ".$table." where dispname like '%".$trimmed."%'";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

$maxPage = ceil($numrows/$rowsPerPage);

$self = $_SERVER['PHP_SELF'];




if ($pageNum > 1)
{
	$page = $pageNum - 1;
	$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";
	
	$first = " <a href=\"$self?page=1\">[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\">[Next]</a> ";
	$last = " <a href=\"$self?page=$maxPage\">[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'); 
// 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());