Simple error

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
Vilash
Forum Commoner
Posts: 28
Joined: Tue Feb 07, 2012 1:24 am

Simple error

Post by Vilash »

Hi i am working on pagination....everything works bt if i click next button it doesnt go to next page....

here is the code

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

 <?php 

 // Connects to your Database 

 mysql_connect("localhost", "login", "login123") or die(mysql_error()); 

 mysql_select_db("test") or die(mysql_error()); 

 
 //This checks to see if there is a page number. If not, it will set it to page 1 

 if (!(isset($pagenum))) 

 { 

 $pagenum = 1; 

 } 

 

 //Here we count the number of results 

 //Edit $data to be your query 

 $data = mysql_query("SELECT * FROM classifieds  ") or die(mysql_error()); 

 $rows = mysql_num_rows($data); 

 

 //This is the number of results displayed per page 

 $page_rows = 3; 

 

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

 } 

 echo " --Page $pagenum of $last-- <p>";

 //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 = mysql_query("SELECT * FROM classifieds $max") or die(mysql_error()); 


 //This is where you display your query results

 
 while($row = mysql_fetch_array( $data_p )) 

 { 
?>
 <a href="classifieds/classifieds.php?Id=<?php echo $row['Id']; ?>"><?php echo  $row['AdTitle']; ?></a><br />
   <?php  echo $row['Description']; ?><br />

<strong> <?php echo  $row['Category']; ?><br /></strong>
     
	<?php echo  $row['Date']; ?><br />
    
	
	<?php     

 echo "<br>";

 } 

 echo "<p>";

 
 // 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']}?pagenum=$previous'> <-Previous</a> ";

 } 


 //just a spacer

 echo " ---- ";


 //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 " ";

 echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";

 } 

 ?> 

</body>
</html>
User avatar
social_experiment
DevNet Master
Posts: 2793
Joined: Sun Feb 15, 2009 11:08 am
Location: .za

Re: Simple error

Post by social_experiment »

Vilash wrote:...it doesnt go to next page....
The next page of records isn't displayed? The next page cannot be found?
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
Vilash
Forum Commoner
Posts: 28
Joined: Tue Feb 07, 2012 1:24 am

Re: Simple error

Post by Vilash »

ya it s showing page 1 of 3 bt it s nt going to page no 2 and 3,nt displaying records also
User avatar
social_experiment
DevNet Master
Posts: 2793
Joined: Sun Feb 15, 2009 11:08 am
Location: .za

Re: Simple error

Post by social_experiment »

“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
Post Reply