Navigation

[Manat]

Hi all,

I have a product search box on my extranet, and on that page your able to navigate through your search results by clicking on page numbers or clicking on the next button.

But now, I want to change the code so instead of the next button going to the next page, it shows the next 5 pages.

so links would be:
1 2 3 4 5 Next 5

then when u click on Next 5 you get:

6 7 8 [I9[/I] 10

Also next 5, and prev 5 only shows if there is that much more to show. and also, it should be Next $pagesLeft instead of a static number 5.

Here is what I currently have:

 if($page != 1){ 
    echo("<a href=\"./search.php?page=$pageprev&phrase=$phrase\"><span class=searchmainblue>Prev </span></a>&nbsp&nbsp;"); 
    }else{ 
        echo("&nbsp;"); 
    } 

    $numofpages = $totalrows / $limitt; 

for($i = 1; $i <= $numofpages; $i++){     

    if($i == $page){ 
	   echo("<span class=searchheadtextbold>".$i."</span>"); 
    }else{ 
        echo("<a href=\"$PHP_SELF?page=$i&phrase=$phrase&sortList=$sortBy\"><span class=numbers>$i</span></a>&nbsp"); 
    } 
} 

if(($totalrows % $limit) != 0){ 
    if($i == $page){ 
        echo("<span class=searchheadtextbold>".$i."</span>"); 
    }else{ 
        echo("<a href=\"$PHP_SELF?page=$i&phrase=$phrase&sortList=$sortBy\">$i</a>&nbsp&nbsp"); 
    } 
} 
echo "<span class=searchheadtext>  </span>";
    if(($totalrows - ($limit * $page)) > 0){ 
       echo("<a href=\"$PHP_SELF?page=$pagenext&phrase=$phrase&sortList=$sortBy\"><span class=searchmainblue>Next </span></a>"); 
    }else
	{ 
        echo("<span class=searchmainblue></span>"); 
    }

Does anyone know how I would do this?
Any code snippet would be much appreicated.

Thx
MK

[Manat]

Anyone?

I would greatly apreciate any help!

[pdaoust]

hmmm, it depends. I'd like to ask a few questions before I suggest anything:

First, let's say you're on page 3. When you press 'Next 5', should it take you exactly five pages forwards to page 8 (3 + 5 = 8), or should it just take you to the first page in the next grouping of five (which would be 6, because you're in pages 6 - 10)?

I'm assuming the current group of five should always be centred around the page you're on, right? What i mean is, if you're on page 21, it would look like this:

19 20 21 22 23

and if you click on page 23, it would look like this:

21 22 23 24 25

I think that'd be the most sensible behaviour. If that's the case, try out this snippet (I've left out style formatting and stuff):

$numofpages = $totalrows / $limit;

// $prevGroup takes you back five (or however many) pages
$prevGroup = $page - 5;
if ($prevGroup < 1) {
    $prevGroup = 1;
}
// $howManyLeft calculates the exact number of pages left to see, if less than 5
$howManyLeft = $page - 3;
if ($howManyLeft < 0) {
    $howManyLeft = 0;
} else if ($howManyLeft > 5) {
    $howManyLeft = 5;
}

if ($howManyLeft) {
    echo "<a href=\"$PHP_SELF?page=$prevGroup&amp;phrase=$phrase&amp;sortList=$sortBy\">Prev " . $howManyLeft . '</a>';
}

// this is a little complicated; we need to know where to start the iterator, because if we just said
//     foreach ($i = $page - 2...
// we might be starting from a negative number.
$startOfGroup = $page - 2;
if ($startOfGroup < 1) {
    $startOfGroup = 1;
}
// we also have to check so we don't go off the end either
$endOfGroup = $startOfGroup + 4;
if ($endOfGroup > $numofpages) {
    $endOfGroup = $numofpages;
}
// finally, now we iterate.
foreach ($i = $startOfGroup; $i =< $endOfGroup; $i ++) {
    if ($i == $page) {
        echo $i;
    } else {
        echo "<a href=\"$PHP_SELF?page=$i&phrase=$phrase&sortList=$sortBy\">$i</a>";
    }
}

// now we have to make the same check we did at the beginning -- how many pages should be specified in 'Next x'
// $nextGroup takes you forward five (or however many) pages
$nextGroup = $page + 5;
if ($nextGroup > $numofpages) {
    $nextGroup = $numofpages;
}
// $howManyLeft calculates the exact number of pages left to see, if less than 5
$howManyLeft = $numofpages - ($page + 2);
if ($howManyLeft < 0) {
    $howManyLeft = 0;
} else if ($howManyLeft > 5) {
    $howManyLeft = 5;
}

if ($howManyLeft) {
    echo "<a href=\"$PHP_SELF?page=$nextGroup&amp;phrase=$phrase&amp;sortList=$sortBy\">Next " . $howManyLeft . '</a>';
}

Haven't tested this out, but it should work. Sorry, there's a bit of magic in there in spots; if you have any questions, don't hesitate to ask them.

[Manat]

Hi,

I tried the code but for some reason I get a parse error on this line:

foreach ($i = $startOfGroup; $i =< $endOfGroup; $i++) {

These variables all exist and were declared, so I don't see where the parse error is!

Thankls
MK

[tsinka]

Replace it by

for ($i = $startOfGroup; $i =< $endOfGroup; $i++) {

Thomas

[Manat]

Hi,

Yes I just realized it was a for statement and not a foreach, I was going to edit my post but then saw yours.

I had made the change, but nevertheless, I still get a parse error on the same line:

for ($i = $startOfGroup; $i =< $endOfGroup; $i++) {

[tsinka]

not my day ... it's <= and not =< ...

for ($i = $startOfGroup; $i <= $endOfGroup; $i++) {

[pdaoust]

yeah, I caught the <= and =< problem too, after I looked at it. Soooooo... how is the script working, otherwise?

[Manat]

Hi,

I works now, but when it says I have 10 results, it only shows 5.

$get_entries = mysql_query("SELECT keywords.*, Product.*, Price_Range.* FROM keywords, Price_Range, Product WHERE keywords.keyword LIKE '$keyword%' AND keywords.sku = Product.SKU  AND Product.Price_Range_ID = Price_Range.Price_Range_ID AND Product.Is_Active=1 ORDER BY keywords.sku, pertinance DESC LIMIT $limitvalue, $limit") or die(mysql_error()); }

The problem is my LIKE, ever since I change it to a LIKE instead of where keyword=$keyword, the numfound is not equivalent to the number displayed.

Is my query wrong?

I tried doing a Group by instead, but all I got was parse errors.

[pdaoust]

hmmm, very good questions. First of all, what values do $limitvalue and $limit hold? Also, if you could post a snippet of the generated HTML code, I'd like to be able to visualise what's going on here.

Another note: I noticed that your LIKE is formatted like '$keyword%', which implies that you're looking for words which begin with your keyword. If you're looking for a good way to match root words (e.g., any variation of 'walk' -- 'walking', 'walks', etc -- will match with any other variation) you might want to check out the Porter Stemming Algorithm. I believe the algorithm is either public-domain or open-source, and someone's written a PHP version. You can grab a copy off my webserver if you want: http://cheesefish.net/stemming.inc.php.txt

[pdaoust]

gee whiz, I need a proofreader. I forgot to mention that what this class does is receive a word, find its 'stem' (or root word), and return the stem. It'll be your job to decide what to do with that stem -- what I've done is create a table of keywords like this:

+----+---------+------+-----------+
| id | keyword | stem | metaphone |
+----+---------+------+-----------+

That way, I can search by exact keyword, by root word, and 'sounds-like' matching (check out the metaphone() function in PHP).

Don't forget that, to use the stemming algorithm, you'd have to run each word through the stemmer when you're indexing the content, and run each search keyword through the stemmer when a person is searching, and then match up the 'stem' column instead of the 'keyword' column.

[Manat]

hi,

I think the Porter Stemming Algorithm is a little bit too complicated for this task.

Is there an easy way to do it with a Group By SQL statement?

To count results I do this:

$get_data = mysql_query("SELECT keywords.*, Product.*, Price_Range.* FROM keywords, Price_Range, Product WHERE keywords.keyword LIKE '$keyword%' AND keywords.sku = Product.SKU  AND Product.Price_Range_ID = Price_Range.Price_Range_ID AND Product.Is_Active=1") or die(mysql_error()); 
$sku_use=0;
$count=0;
while ($row=mysql_fetch_array($get_data)) 
    { 
	if ($row[sku] != $sku_use) 
        {$count++; }
}

In this same structure and SQL i output the results, if both queried are exactly alike, why would it return different results?

Count is not equal to what is displayed???
But what is displayed is correct, it's the count that is incorrect?

Can the count be corrected, do you see any easy way to correct it?

thanks
MK

[pdaoust]

just a shot in the dark, but why not add this to your SQL statement:

AND keywords.sku != $sku_use

And of course define $sku_use before the query, instead of after. This way, you'd be able to get rid of this check (because the SQL statement would've already taken care of it):

if ($row['sku'] != $sku_use)
    { $count ++; }

Maybe that would also make the number of rows match the value of $count? not quite sure what the rest of your program logic is like, but it might help.

[Manat]

No unfortunately that doesn't work either.

The problem seems to be my $limit and $numfound.

The number of results displayed on one page isn't always 10 and $limit ==1.

Also the number of results found is not equal to the number of results displayed.

I would really appreciate if anyone can solve this issue!!!

Thanks

MK

[tsinka]

Post the code you have so far (maybe as attachment).

Thomas

[TVBanks98]

To count results I do this:

$get_data = mysql_query("SELECT keywords.*, Product.*, Price_Range.* FROM keywords, Price_Range, Product WHERE keywords.keyword LIKE '$keyword%' AND keywords.sku = Product.SKU  AND Product.Price_Range_ID = Price_Range.Price_Range_ID AND Product.Is_Active=1") or die(mysql_error()); 
$sku_use=0;
$count=0;
while ($row=mysql_fetch_array($get_data)) 
    { 
	if ($row[sku] != $sku_use) 
        {$count++; }
}

In this same structure and SQL i output the results, if both queried are exactly alike, why would it return different results?

Count is not equal to what is displayed???
But what is displayed is correct, it's the count that is incorrect?

Could it be the join predicate ?? Can you post an example of the data in each table and the results you're getting as well as the code that was requested earlier ?

Also, why not use the COUNT(*) Column Function instead of programatically calculating it ?? The you could use the LIMIT and OFFSET clauses to extract only the rows you need for display on the current page. It means having to go back to the DB each time you page, but it seems you're doing that anyway now.

Thanks,
T

[tsinka]

Manat,

which MySQL version do you use ?

As of 4.0.0 there is another way to determine the number of rows:

Example:

SELECT SQL_CALC_FOUND_ROWS * FROM atable WHERE afield LIKE 'avalue%' LIMIT start,end

SELECT FOUND_ROWS()

The SQL_CALC_FOUND_ROWS tells MySQL to determine the number of rows that would've been returned without the limit.
The second query returns that number of rows.

If the first SELECT statement returns e.g. a limit of 10 rows and the select statement without LIMIT would return e.g. 100 rows then the second query returns 100.

Use mysql_num_rows() (or count(*) in the query) on queries without a limit.

Thomas