Next/Previous - URL... - PHPBuilder Forums

Next/Previous - URL...

brigatti

Further to the PHPBuilder.com article relating to building a Next/Previous page system for a PHP/MySQL site; what I would like to ask you is how would one amend it so that if a "multiple" selection box is used; this would also work with the URL part of the code, i.e.

I say this because I currently have implemented a search option whereby a "multiple" section of one particular element can be chosen and searched; in my particular case being able to search under more than one qualification (e.g. BSc and MSc) in one search. I've got the initial results screen sorted, but I can't seem to get the above URL link to show say the next page of results.

Let me know whether you have a suggestion? If you prefer to receive the code, I will be more than happy to submit to you via e-mail....again, pls do let me know! :-)

Your help is much appreciateed,

Thanks in advance,

Regards,

Aaron

🙂

leatherback

Hopefully not the answer you are are looking for, but eh.. You do pass the variable-settings to the links, right?

I have a similar thing on my website. I pasted the working code below. I hopeit may help you to figure ouyt what is wrong in your code. If not: Post your question again, and with an example code from your page, which will give us a better idea of what might be wrong!?

In the query you add a part:

$sql_query .= " limit $offset, $limit ";

Here is the code (This is the code I used to generate prev / next links on www.bio-vision.nl/ecards):

// more stuff before and after, of course....

if ($offset>0) // bypass PREV link if offset is 0
{
$prevoffset=$offset-$limit;
$prev="<a href=\"ecard.php?id=$id&offset=$prevoffset&Them=$Them&Count=$Count&expanded=$expanded&id=$id\">< < PREVIOUS</a> \n";
}

// calculate number of pages needing links

$pages = intval($numrows/$limit);

if ($numrows%$limit)
{
$pages = $pages + 1;
}

$thispage = $offset/$limit+1;

$pageindex="page $thispage of $pages";

// check to see if last page
if ($pages>1)
{
if (!(($offset/$limit)==($pages-1)) && $pages!=1) {

// not last page so give NEXT link

$newoffset=$offset+$limit;
$next= "<a href=\"ecard.php?offset=$newoffset&&id=$id&Them=$Them&Count=$Count&expanded=$expanded&id=$id\"><ul id='index'>NEXT > ></ul></a>\n";
}
}

brigatti

Yeah everything was working fine, until the user requirements changed slightly and I had to change the search option so that instead of only searching under ONE qualification, I had to provide the option to search under MANY qualifications.

As an example of the URL link in question, here's what the code that I use states:

<a href=\"$PHP_SELF?majordis_exp=$majordis_exp&subspeciality_exp=$subspeciality_exp&country_exp=$country_exp&qualification_exp=$qualification_exp&language_exp=$language_exp&regions_exp=$regions_exp&page=$back_page&limit=$limit&col=$col&order=$order\" title=\"Previous Page\" onMouseOver=\"self.status='Previous Page';return true\" onMouseOut=\"self.status='';return true\"><< Prev</a> \n");

Obviously, a lot of this in simply parsed data, but the most critical aspect is being able to "parse" multiple entries; in this particular case being the "$qualification_exp" field (and it will only be the case for the qualification - everything else is SINGLE data selection!). This currently has been set up as follows on the initial PHP/HTML search form:

<select accessKey="q" name="qualification_exp[]" multiple size="5" onMouseOver="self.status='Please select a qualification';return true" onMouseOut="self.status='';return true" title="Please select a qualification">
<option value="" selected>[Select a qualification]</option>
<?php
while (list($id, $qualname) = mysql_fetch_row($resultqualificationexp)) {
    echo "<option value=$id>$qualname</option>";
}
mysql_free_result($resultqualificationexp);
?>

With the results summary page code as follows:

    if ( ($majordis_exp || $subspeciality_exp || $country_exp || $language_exp || $qualification_exp) && ($regions_exp) ) {
        $query="select distinct id, title, first_name, middle_name, surname, perm_address, perm_country, approved, sentdeclined, qualification, regions_id from cv
        inner join major_disc_exp on cv.id=major_disc_exp.member_id and major_disc_exp.exp_id like '%$majordis_exp'
        inner join subspeciality_exp on cv.id=subspeciality_exp.member_id and subspeciality_exp.sp_id like '%$subspeciality_exp'
        inner join country_exp on cv.id=country_exp.member_id and country_exp.country_id like '%$country_exp'
        inner join language_exp on cv.id=language_exp.member_id and language like '%$language_exp'
        left join regions_exp on cv.id=regions_exp.member_id and regions_exp.regions_id like '$regions_exp'

";
for ($i=0;$i<sizeOf($qualification_exp);$i++)
{
if ($i==0)
{
$q_cond=" where";
}
else
{
$q_cond=" or";
}
$query.="$q_cond qualification LIKE '%$qualification_exp[$i]' ";
}
$query.="and ( regions_exp.regions_id like '$regions_exp') ";

Is this any clearer? 🙂

As I said, it's the parsing of "multiple" selection data/fields into the URL? Is it possible? I've tried things like putting commas, i.e.

http://localhost/consultancy/adminsearchresults.php?majordis_exp=%&subspeciality_exp=%&country_exp=%&qualification_exp=1,3&language_exp=%&regions_exp=%&page=0&limit=10&col=surname&order=ASC

but this doesn't seem to work 🙁

Anyway, any suggestions? Or is it NOT possible?

Thanx for your help.

Regards,

Aaron

brigatti

Opps the URL posted in my last msg was shortened; it should be as follows:

http://localhost/consultancy/adminsearchresults.php?majordis_exp=%&subspeciality_exp=%&country_exp=%&qualification_exp=1,3&language_exp=%&regions_exp=%&page=0&limit=10&col=surname&order=ASC

But only qualification_exp = 1 search results are displayed, what I wanted was search results for qualification_exp = 1 and qualification_exp = 3 on the SAME screen. i.e. if you click next page or change the order of the list, the same search results will still occur!

Regards,

Aaron