Thread: PHP Pagination

I assume you are using a for loop.
Difine $counter=0
Run the loop once with

$counter = $counter+1;

Use counter to give total number of records that match the filter.

use a while loop to recall all results

use a IF statment to limit the results to 10 per page

IF(($whileCount>=$record1)&&($whileCount<=$record1 +10)){
Print(Your print statment);
}

I hope that this helps (it should work will need a bit of tinkering though)

cheers, will give it a tinker and see if I can make anything of it

*wakes up* no no no ive got that bit!

I need a bit to put it all on different pages, at the moment ive got:

// Opens CSV File
$row = 1;
$handle = fopen ($csvfile,"r");
while ($data = fgetcsv ($handle, 1000, ",")) {
$num = count ($data);
$row++;

// Checks price less than 10
if ($data[4] <= 10) {

print "tables with loads of stuff in";

// Close file
}
fclose ($handle);

What i need is some way of counting how many data[4]'s are returned under 10, and then splitting them up. But as I tought myself php, I missed this bit and well... am stuck
exit; }

Ok I THINK this might work, will probably need intergration.


(you may want to run your S cript once first without the print to count number of rows, divide by 10 to give total number of pages (round up) and print series of links to page.php?pageNo=1 ..etc)

I hope this helps, if it works I will let you buy me a beer.

s=c=r=i=p=t

$row = 1;

$handle = fopen ($csvfile,"r");
while ($data = fgetcsv ($handle, 1000, ",")) {



// Checks price less than 10

if ($data[4] <= 10) {
$row++;
if(($row>=($pageNo*10-9))&&($row>=($pageNo*10))){
print "tables with loads of stuff in";
}
// Close file
}
fclose ($handle);

e=n=d=s=c=r=i=p=t

After a tweak or two, it works! And the beers as good as yours, cheers. <img src=http://www.gamers-forums.com/smilies/contrib/ruinkai/biggthumpup.gif ALT=":thumb">