changing foreach loop (limit results)

xenia

I have a foreach loop for an array that holds a variable amount of information. For example...

foreach ($pas as $pa_id=>$pa) { //display $pa info}

If there are 25 results, the foreach displays all 25. I want to display the results by 10. What is the best way to change my foreach loop? I have a count of the amount of items in the array, but how do you get page 1 to display 1-10, page 2 to display 11-20, etc?

Thanks in advance for the help.

bodzan

$newArray = array_slice($array, 0[start point], 10[end point]);

and then foreach fo $newArray...

Of cousre loose the []'s...

xenia

That array slice seems to work, but I lose my id numbers. Now, instead of the real number, I get numbers 0 -9 like the start and end points. ??? Here's the code again. All the array information is the correct one, but the pack_id is lost once I slice the array. Any suggestions.

Also, I have a variable amount of results. For example, 25. Should the next page be start point 11, end point 20. Should that work??

$newArray = array_slice($packs, 0, 10);

foreach ($newArray as $pack_id=>$pack) {
<?print $pack_id; ?>
strong><? print $pack[0]; ?> 
<? print $pack[1]; ?>
$ <? print $pack[4]; ?></td>
}

Thanks again!

bodzan

I believe the array_chunk is what you need...

http://www.php.net/manual/en/function.array-chunk.php

xenia

How exactly would you implement that function with the foreach I have? I placed the function and the print for it, but I'm a little confused how to implement to utilize the foreach to display all the variables of the array.

Thanks again.

bodzan

$newArray = array_chunk($packs, 0, 10);

foreach ($newArray as $pack_id=>$pack) {
<?print $pack_id; ?>
strong><? print $pack[0]; ?> 
<? print $pack[1]; ?>
$ <? print $pack[4]; ?></td>
}

And it'll be it... Then on the next page do
$newArray = array_chunk($packs, 11, 20);

and so on...

If you need this to be made on one page just pass one variable say $howMany in url and for the first page do
if(!$GET['howMany']){
$GET['howMany'] = "0"
}

$newArray = array_chunk($packs, $GET['howMany'], ($GET['howMany']+10));

and for the next page do the link where youpass the value of $howMany as a $_GET['howMany']+11 and so on...

xenia

I had to use the function from your link for the array_chunk function, I guess the php version is less than 4.2. I also put it in the code as you mentioned, but all I get is 10 null fields for all of my fields I'm displaying. ???

Is there any way I can reference the key or id number of the items I'm displaying? It either does all null or all there except the id numbers change to 0-10.

bodzan

If that's the case the solution is much simpler than anything I've mentioned...

xenia

The array is built with a simple sql statement -- select * from table where category = someidnumber.

bodzan

...like I said there is a simpler way...

Add these lines tou your sql statement:

if(!$GET['lim']){
$GET['lim']=10;//if there is no limit requested put it to be 10
}

$sql .= " LIMIT ";
$sql .= $GET['lim']-10;
$sql .= ",";
$sql .= $GET['lim'];

The line would be the code for the next page...
echo "<a href=\"page.php?lim=".($_GET['lim']+10)."\">next page>>></a>

Basically, what are you doing here is to put limit on SQL query so it would limit your results comming from the db... Thus you would have a foreach with no limitations on every page because you would have a limited array in question...

You should have mentioned that araay was from the db... I've would have helped you with my first post which would be like this one...
But, hey, hope this solves your problems...

xenia

The addition to the sql statement didn't seem to work, but with some if statements for the ranges (by 10) and the following function found on the Internet, the function worked with keeping keys intact. (Just renamed the function so it would reference correctly)

Thanks for the input.