Is this possible?

[UVL]

Is it possible to send a query to check if 10 records are availble, display only 1 through 5 and a link to records 6 through 10 (upon clicking on the link checking to see if 10 more records are availble).
And do this repeatedly until 10 more records aren't availble then the link would change, or simply disappear, and the last results being displayed are the final records in the database. This is kind of a confusing description, hope it explains what I'm after.

[LordShryku]

Sounds like you just want pagination. Search the forums for it...

[UVL]

Um...Duh.

[UVL]

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10274619

I'm trying to paginate the code display in that link. it paginates fine. My problem is getting the "next" and "previous" links to only appear when there are actual results to display. I don't want them showing up when there aren't any results, and I don't want them showing up when there won't be more results to show. I just want a simple way to paginate my database queries so that if 27 items show up, and there is 10 items per page, only 3 pages are used to display that information, and the links work and do what their supposed to.

this is the code I'm trying to work with to make it do that:

<? 
//now this is the forward link.. 

if ($total_results>0\25){ 
echo '<a href="testie.php?startrow='.($startrow+5).'&search='.$search.'">Next</a>';

} elseif ($total_results<=4){
print "done";
}
?>

<? 
//now this is the backward link.. 

if ($total_results<=25){ 
echo '<a href="testie.php?startrow='.($startrow-5).'&search='.$search.'">Back</a>';  

} 
?>

I'm not really experienced at this, and I'm just trying to see how someone with experience would use this code to get the results I'm after. What they could add to it, or take away, etc.

I've been working on this for hours, so I apoligize if I sound frustrated. Some people have led me in the right direction, but no one has actually just told me what to do...and at this point, I'm pretty confused.

[mtimdog]

Originally posted by LordShryku
Sounds like you just want pagination. Search the forums for it...

😃 😃

[UVL]

this forum sucks, thank you all so much for your rudeness

[mtimdog]

After searching the forum for 'pagination', I came up with 261 results. Went down to a title I liked

and found Batman's code for pagination

// limit value for number of records to be shown per page 
// query database to find total number of records to display 
$limit = 5;  

$query_count = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%')";  

$result_count = mysql_query($query_count);  

$totalrows = mysql_num_rows($result_count);  

if(empty($page))  

$page = 1;  

$limitvalue = $page * $limit - ($limit);  

$query = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%') LIMIT $limitvalue, $limit ";  

$result = mysql_query($query) or die("Error: " . mysql_error());  

$count_result = mysql_num_rows($result);  

// Display links at the top to indicate current page and number of pages displayed 
$numofpages = ceil($totalrows / $limit); 
echo"<br><p><b>$totalrows</b> result(s) for: \"$search\"</p>"; 
$from=$limit*$page-$limit+1; 
$to=$from + $count_result-1; 

// start 123 next>> table 
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> 
            <tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\"><b>Go to page:</b> ";}  

// display previous link if page is not 1 
if($page != 1){  

$pageprev = $page - 1;  

echo("<a href=\"$PHP_SELF?page=$pageprev&search=$search\"><< PREV</a>&nbsp;");  

}  

// display page nos if not 1 
for($i = 1; $i <= $numofpages; $i++){  

if($numofpages>1){ 
if($i == $page)  

echo("&nbsp;".$i."&nbsp;");  

else 
echo("&nbsp;<a href=\"$PHP_SELF?page=$i&search=$search\">$i</a>&nbsp;");  

}} 

// display next page link if there is more than one 
if(($totalrows - ($limit * $page)) > 0){  

$pagenext = $page + 1;  

echo("<a href=\"$PHP_SELF?page=$pagenext&search=$search\">NEXT >></a>");  

} 
// end 123 next>> table 
echo"</td></tr></table><br>";

It's not exactly what you're looking for, but it shows the concepts. You need to pass the page# or starting record number between pages. query for the number of results (check to make sure start number/page number are valid). Display previous if page# or start# > 1. Display next if results > (page# * resultsperpage(which can also be passed between pages) or results > (startingrecordnumber + resultsperpage).

Give a man a fish he eats for a day, teach a man to search and he knows where to go to get the fish.

[UVL]

thanks, appreciate it. I had already searched for paginate before I posted the very first time. My problem is I'm fairly new to PHP and when I go through the code other people have written it's confusing when I try to apply it to the code I've written. That's why i posted the code I wrote so someone could help me with my code that I wrote. But thanks for posting Batman's paginate code. Maybe I'll get it figured out.

[mtimdog]

I hope my explanation below the code helps as well.

[UVL]

kind of. My biggest problem is fitting this into the code I've written. This is the code I have I wanted to paginate:

<? $hostname = "localhost"; // The DB server. 
$username = "************"; // The username you created for this database. 
$password = "*********"; // The password you created for the username. 
$usertable = "**********"; // The name of the table you made. 
$dbName = "*********"; // This is the name of the database you made. 
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Database Connection Unavailable");
@mysql_select_db( "$dbName") or die( "Unable to select database"); 

//error message (not found message)begins 
$XX = No results found, please try your search again. Try limiting your search to specific keywords.; 

//check if this is the first page 
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) { 
//we give the value of the first row to 0 
$startrow = 0; 
//otherwise we take the value from the URL 
} else { 
$startrow = (int)$_GET['startrow']; 
} 

//query details table begins
if (isset($_GET['search'])) {

 $search = $_GET['search'];

} else {

 $search = $_POST['search'];

}
$query = mysql_query("SELECT * FROM ******** WHERE keywords LIKE '%$search%' LIMIT $startrow, 25");
while ($row = @mysql_fetch_array($query)) 
{ 
$variable1=$row["********"];
$variable2=$row["**********"]; 
$variable3=$row["************"]; 
$variable4=$row["**********"];
$variable5=$row["*********"];
$variable6=$row["******"];
$variable7=$row["***********"];
$variable8=$row["***********"];
$variable9=$row["*********"];
$variable10=$row["***********"];
$variable11=$row["*******"];

//below is the table layout for results 
?>

<div id="Layer1" style="position:absolute; width:200px; height:8px; z-index:16; left: 2px; top: 63px;">
  <table width="740" border="0" cellspacing="0" cellpadding="0">
    <tr align="center" valign="middle">
      <td width="100"><div align="center"><u>************</u></div></td>
      <td width="70"><div align="center"><u>************</u></div></td>
      <td width="150"><div align="center"><u>***********</u></div></td>
      <td width="65"><div align="center"><u>************</u></div></td>
      <td width="100"><div align="center"><u>***********</u></div></td>
      <td width="255"><div align="center"><u>***********</u></div></td>
    </tr>
  </table>
</div>
<table width="740" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
  <tr>
    <td width="100" valign="top"><div align="center"><span class="style7"><strong><? print "$variable1" ?></strong></span></div></td>
    <td width="70" align="left" valign="middle"><div align="left"></div>
        <div align="center"><? print "$variable5" ?></div></td>
    <td width="150"><div align="center"><? print ("$variable4"); ?></div></td>
    <td width="65" align="right" valign="middle"><div align="left"></div>
        <div align="center"></div>
        <div align="center"><? print "$variable8" ?></div></td>
    <td width="100"><div align="center"><? print "$variable7" ?></div></td>
    <td width="255" height="18" align="left" valign="middle"><div align="center"><strong><? print "$variable3" ?></strong></div></td>
 </tr>
</table>

<?
print ("<tr>");
print ("</tr>"); 
}
//below this is the function for no record!!
if (!$variable1)
{ 
print ("$XX");
} 
//end 
?>

<?
//now this is the link..
echo '<a href="*****.php?startrow='.($startrow+25).'&search='.$search.'">Next</a>'; 
?>

Now, I understand the concept behind paginating, and I'm slowly figuring out how others make it work...but I'm starting to think I have to redo all of my code to get it to work.