0
<?php

//This checks to see if there is a page number. If not, it will set it to page 1 
if(isset($_GET['pagenum']))
{
	$pagenum = $_GET['pagenum'];
}
else
{
	$pagenum = 1;
}

$var1 = 'gene_name';

// When user click the submit button
if(isset($_POST['submit']))
{
	//if(isset($_GET['page']))
 	//{
  		if(preg_match("/^[a-zA-Z0-9]+$/", $_POST['keyword']))
  		{
   			$keyword=$_REQUEST['keyword'];
			
			// Connects to your Database 
			$conn = mysql_connect("localhost", "root", "root") or die(mysql_error());
			mysql_select_db("gano_gene", $conn) or die(mysql_error());
			$sql = "SELECT * FROM gano_gene WHERE $var1 LIKE '%" .stripslashes($keyword). "%'";
			$results = mysql_query($sql, $conn) or die(mysql_error());
			
			//Here we count the number of results 
			$rows = mysql_num_rows($results); 
			
			//This is the number of results displayed per page 
			$page_rows = 10; 
			
			//This tells us the page number of our last page 
			$last = ceil($rows/$page_rows); 
			
			//this makes sure the page number isn't below one, or more than our maximum pages 
			if ($pagenum < 1) 
			{ 
				$pagenum = 1; 
			}
			
			elseif ($pagenum > $last) 
			{ 
				$pagenum = $last; 
			}
			
			//This sets the range to display in our query 
			$max = 'LIMIT ' .($pagenum - 1) * $page_rows .',' .$page_rows; 
			
			//This is your query again, the same one... the only difference is we add $max into it
			$data_p = "SELECT * FROM gano_gene WHERE $var1 LIKE '%" .stripslashes($keyword). "%' $max";
			$results_p = mysql_query($data_p, $conn) or die(mysql_error());		
			
			//This is where you display your query results
			while($info = mysql_fetch_array( $results_p )) 
			{
				$GeneName = $info['gene_name'];
				echo "<td>$GeneName</td>";	
				echo "<br>";
			} 
			
			// This shows the user what page they are on, and the total number of pages
			echo " --Page $pagenum of $last-- <p>";
			
			// First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.
			if($pagenum < 1) 
			{
			}
			else
			{
				echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";
				echo " ";
				$previous = $pagenum-1;
				echo " <a href='{$_SERVER['PHP_SELF']}?keyword=$keyword&&pagenum=$previous'> <-Previous</a> ";
			} 
			
			//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
			if ($pagenum == $last)
			{
			}
			else
			{
				$next = $pagenum+1;
				echo " <a href='{$_SERVER['PHP_SELF']}?keyword=".$keyword."&&pagenum=".$next."'>Next -></a> ";
				echo " ";
				echo " <a href='{$_SERVER['PHP_SELF']}?keyword=".$keyword."&&pagenum=".$last."'>Last ->></a> ";
				
				
			}
		}
	}
?>

MY QUESTION IS: HOW DO I GET THE ROWS MOVE FROM DATA TO DATA BASED ON THE KEYWORD?

echo " <a href='{$_SERVER['PHP_SELF']}?keyword=".$keyword."&&pagenum=".$next."'>Next -></a> ";

Edited by Ezzaral: Added code tags. Please use them to format any code that you post.

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by diafol
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.