xuexue 15 Junior Poster

this is the code for search button

if ($go == 'Go')
{
	if ($searchText == '')
	{
		$buttonPress = 2;
		echo "<script>alert('Please complete the information!')</script>";
	}	
	else if ($searchText != '')
	{
		$result2 = mysql_query("SELECT * FROM sec_ph WHERE phType LIKE '%$searchText%' OR phCustomer LIKE '%$searchText%'   ") or die(mysql_error());  
		$resultRow2 = mysql_num_rows($result2);
	
		if ($resultRow2 == '0')
		{
			$buttonPress = 2;
			echo "<script>alert('No Matches Found!')</script>";
		}
		else if ($resultRow2 != '0')
		{
			$buttonPress = 1;
			
			echo "<center><form action = 'http://10.237.102.158/Problem_History/' method = 'post'>";	
			echo "Search: <input type = 'text' name = 'searchText' size = 30>&nbsp;&nbsp;&nbsp;&nbsp;";
			echo "<input type = 'submit' name = 'go' value = 'Go'></form></center>";	

			$result3 = mysql_query("SELECT * FROM sec_ph WHERE phType LIKE '%$searchText%' OR phCustomer LIKE '%$searchText%' ORDER BY phStatus") 
				or die(mysql_error());  
			echo "<center>";

			$pagenumSearch = $_GET["pagenumSearch"];

			//This checks to see if there is a page number. If not, it will set it to page 1 
			if (!(isset($pagenumSearch))) 
			{ 
				$pagenumSearch = 1; 	
			} 

			$rows = mysql_num_rows($result3);				//Here we count the number of results 
			$page_rows = 5; 						//This is the number of results displayed per page 
			$last = ceil($rows/$page_rows); 				//This tells us the page number of our last page 

			if ($pagenumSearch < 1) 						//this makes sure the page number isn't below one, or more than our maximum pages 
			{ 
				$pagenumSearch = 1; 		
			} 
			elseif ($pagenumSearch > $last) 
			{ 
				$pagenumSearch = $last; 
			} 
			
			//**********************************************TOTAL RECORD COUNT
			$resultCount = mysql_query("SELECT COUNT(*) FROM sec_ph") or die(mysql_error());  
			$count = mysql_result($resultCount,0,0);
			echo "<b></center>Total Record Count: </b> $count record(s)<br><br><center>";

			//***********************************************SEARCH RESULTS
			echo "<u><center><b>Search Results: " . $resultRow2 . " Match(es) Found</b><br><br></u>";

			$max = 'LIMIT ' .($pagenumSearch - 1) * $page_rows .',' .$page_rows;					//This sets the range to display in our query 			
			$result4= mysql_query("SELECT * FROM sec_ph WHERE phType LIKE '%$searchText%' OR phCustomer LIKE '%$searchText%'  ORDER BY phStatus $max") 
				or die(mysql_error());  

			echo "<table border = 1 bordercolor='#996633' cellpadding = 4><tr  bgcolor = #FFFFCC><th><font size = 2>Type</th><th><font size = 2>Customer</th></tr>";

			while($row = mysql_fetch_array($result4))
			{
				echo "<tr><td><font size = 2>"; 		
				echo $row['phType'];		
         				echo "</td><td><font size = 2>"; 		
				echo $row['phCustomer'];		
         				echo "</td></tr>"; 
			}
			echo "</table>";

			echo "<br><br><center>Page<b> $pagenumSearch </b>of<b> $last</b><br><br>";			// This shows the user what page they are on, and the total number of pages

			// 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 ($pagenumSearch == 1) 
			{
			} 
			else 
			{
				echo " <a href='{$_SERVER['PHP_SELF']}?pagenumSearch=1'>First</a> ";
				echo "&nbsp;&nbsp;&nbsp;&nbsp;";
				$previous = $pagenumSearch-1;
				echo " <a href='{$_SERVER['PHP_SELF']}?pagenumSearch=$previous'>Previous</a> ";
				echo "&nbsp;&nbsp;&nbsp;&nbsp;";
			} 		

			//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
			if ($pagenumSearch == $last) 
			{
			} 
			else 
			{
				$next = $pagenumSearch+1;
				echo " <a href='{$_SERVER['PHP_SELF']}?pagenumSearch=$next'>Next</a> ";
				echo "&nbsp;&nbsp;&nbsp;&nbsp;";
				echo " <a href='{$_SERVER['PHP_SELF']}?pagenumSearch=$last'>Last</a> ";
			} 

			echo "</font></center>";
		}
	}
}

this is the code for the index page viewing the database contents

switch ($buttonPress)
{
	case 1:		" ";
			break;
	case 2:		echo "<center><form action = 'http://10.237.102.158/Problem_History/' method = 'post'>";	
			echo "Search: <input type = 'text' name = 'searchText' size = 30>&nbsp;&nbsp;&nbsp;&nbsp;";
			echo "<input type = 'submit' name = 'go' value = 'Go'></form></center>";

			$result = mysql_query("SELECT * FROM sec_ph ORDER BY phStatus") or die(mysql_error()); 
			echo "<center>";

			$pagenum = $_GET["pagenum"];

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

			$rows = mysql_num_rows($result);				//Here we count the number of results 
			$page_rows = 5; 						//This is the number of results displayed per page 
			$last = ceil($rows/$page_rows); 				//This tells us the page number of our last page 

			if ($pagenum < 1) 						//this makes sure the page number isn't below one, or more than our maximum pages 
			{ 
				$pagenum = 1; 		
			} 
			elseif ($pagenum > $last) 
			{ 
				$pagenum = $last; 
			} 

			$resultCount = mysql_query("SELECT COUNT(*) FROM sec_ph") or die(mysql_error());  
			$count = mysql_result($resultCount,0,0);
			echo "<b></center>Total Record Count: </b> $count record(s)<br><br><center>";		
				
			$max = 'LIMIT ' .($pagenum - 1) * $page_rows .',' .$page_rows;					//This sets the range to display in our query 			
			$result2 = mysql_query("SELECT * FROM sec_ph ORDER BY phStatus $max") or die(mysql_error()); 

			echo "<table border = 1 bordercolor='#996633' cellpadding = 4><tr  bgcolor = #FFFFCC><th><font size = 2>Type</th><th><font size = 2>Customer</th></tr>";

			while($row = mysql_fetch_array($result2))
			{
				echo "<tr><td><font size = 2>"; 		
				echo $row['phType'];		
         				echo "</td><td><font size = 2>"; 		
				echo $row['phCustomer'];		
         				echo "</td></tr>"; 
			}
			echo "</table>";

			echo "<br><br><center>Page<b> $pagenum </b>of<b> $last</b><br><br>";			// This shows the user what page they are on, and the total number of pages

			// 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 "&nbsp;&nbsp;&nbsp;&nbsp;";
				$previous = $pagenum-1;
				echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'>Previous</a> ";
				echo "&nbsp;&nbsp;&nbsp;&nbsp;";
			} 		

			//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']}?pagenum=$next'>Next</a> ";
				echo "&nbsp;&nbsp;&nbsp;&nbsp;";
				echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last</a> ";
			} 

			echo "</font></center>";
			break;
	default:		break;
}

of course, at the start of the code, $buttonPress = 2, to enable it.

*****now, the problem is that, whenever i access the next/first/last/previous links when i click the go button of the search engine, it goes back to the default page, i mean it runs the $buttonPress =2;, now, what i did was that, i change the variable $pagenum to $pagenumSearch, for some sort of distinction, however, it does not work, what should i do?????


please, really need bad help!
tnx...

Be a part of the DaniWeb community

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