This is all that results from the included script on the 2nd display
page:
<div id="c-col">
<div align="center">
<h3>Articles by </h3>
<h4>(There are 0 articles in the database.)</h4>
</div>
<p></p>
<div align="center">
<a href='results_1.php?currentpage=2&author_name='><em>Next</em></
a> <a href='results_1.php?currentpage=0&author_name='>>></a> </div>
</div>
Given that the where clause in the original query is "WHERE
author_name = '$author_name' " I cannot see how passing the
author_name in the pagination url will help.
Should I somehow pass $author name which was originally picked up from
a form as
'$author_name = '$author_name = $_POST["author_name"];'
Clearly I am at a loss here. Could anyone suggest anything in the PHP
Manual, or any tutorial or anything at all on the web about sustaining
a result set through pagination links when the SELECT clause of the
query is modified by a WHERE clause containing a variable.
As it stands I am unable to construct a search engine query to cover
the matter.
Thanks
Joe.
On 23 Jan 2010, at 20:45, lists-php wrote:
You haven't actually indicated what's on the 2nd display page, but I
suspect that it's just the select statement, with the (url passed)
pagination substituted in. [one can pass the results in an array,
but it's unlikely that you're doing that, so your subsequent pages
simply re-issue the query] if you're doing that, then you'll also
have code that picks up the pagination parameters from the url.
you'll need to add coding to pick up the "author" too, otherwise the
2nd page won't pick it up and use it.
also, in our link example in an earlier message:
http://...results_1.php?currentpage=2&&author_name=Editorial
you show two ampersands before "author_name". there should only be
one. also, if your author's name includes a space, you'll need to
deal with that.
- Rick
------------ Original Message ------------
Date: Saturday, January 23, 2010 08:23:23 PM +0000
From: Joe Keenan <heresiarch@xxxxxxxxxxxxxxx>
To: Edward Brookhouse <ebroo@xxxxxxxxxxxxxxxxxxxxx>
Cc: php-db@xxxxxxxxxxxxx
Subject: Re: result set in php pagination
I have tested the script with echo() which shows that the correct
$numrows is returned and then
$totalpages = ceil($numrows / $rowsperpage);
Everything is correct on the first page of results. The pagination
links are displayed correctly but when clicked on the resulting
page is empty.
For some reason I do not understand the result set does not carry
through to the succeeding links in the pagination sequence.
Thanks,
Joe
On 23 Jan 2010, at 19:16, Edward Brookhouse wrote:
Isn't there a matching select later that sets up the number of
pages?
I start with:
$offset = ($pageNum - 1) * $rowsPerPage;
db_connect_ecelerity(DBUSER, DBUSERPW);
$query1 = "select * FROM `bouncelog` ORDER BY `insert_date` DESC
LIMIT $offset, $rowsPerPage";
$numresults=mysql_query($query1);
$numrows=mysql_num_rows($numresults);
$result = mysql_query($query1) or die('Error, lame query failed');
Then a bunch of display the data stuff but ending with:
$query = "SELECT COUNT(insert_date) AS numrows FROM bouncelog";
$result = mysql_query($query) or die('Error, query lamefailed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$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;
echo "</table>";
echo $first . $prev . " Showing page <strong>$pageNum</strong> of
<strong>$maxPage</strong> pages " . $next . $last; ?>
-----Original Message-----
From: Joe Keenan [mailto:heresiarch@xxxxxxxxxxxxxxx]
Sent: Saturday, January 23, 2010 1:16 PM
To: php-db@xxxxxxxxxxxxx
Subject: result set in php pagination
I am using php and mysql.
The problem which I am hoping someone can help me with concerns
pagination of the result set of a search of a single table.
I got the pagination script I am using from a Sitepoint tutorial
and it works just as it should for this query
"SELECT article_id, category_name, author_name, title,
article_caption, date_format(magazine_date, '%M, %Y') as newdate
FROM articles where article_id > 0 ORDER BY magazine_date DESC
LIMIT $offset, $rowsperpage"
The result set is return over many pages with no problem at all.
When it comes to this next query however it delivers the first
page of results and sets up the linked pages but those are empty.
"SELECT article_id, author_name, category_name, title,
article_caption, date_format(magazine_date, '%M, %Y') as newdate
FROM articles WHERE author_name = '$author_name' ORDER BY
magazine_date ASC LIMIT $offset, $rowsperpage"
I assume the problem must have to do with '$author_name' which is
passed to the search script as '$author_name =
$_POST["author_name"];' from a php form.
Is there something I should be doing to ensure that the result set
from the query persists though the change in pagination from the
first page of results to the second page.
In both cases the search scripts are includes in other php pages.
I think I need to understand how the result set is carried
through or reacquired in the pagination process.
Sorry if this is phrased very clumsily.
Thank you,
Joe Keenan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
------------ End Original Message ------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
