PHP Classes

some error

Recommend this page to a friend!

      CSS Pagination  >  All threads  >  some error  >  (Un) Subscribe thread alerts  
Subject:some error
Summary:limit in mysql_query + max item limited to #256
Messages:7
Author:Delepiere
Date:2008-10-20 12:47:01
Update:2008-10-21 08:53:30
 

  1. some error   Reply   Report abuse  
Picture of Delepiere Delepiere - 2008-10-20 12:47:01
some errors:

1- in instruction.txt limit instruction is still missing...

2- the number of item of the database that can be listed is limited to #256
this is probably due to the ceil () calcul in the php class module

private function getLastPage()
{
return ceil($this->totalrows / $this->rowsperpage);
}
this function should return an integer > 256

3 - when clicked from low pages numbers (<20) directly to last page (24 with 10 items per page) the list returned is empty...
it is not empty when next or 23 is clicked from page 23 in the pagination system.

I am using database with more then 10.000 items in php4

Marc



  2. Re: some error   Reply   Report abuse  
Picture of Dodit Suprianto Dodit Suprianto - 2008-10-20 14:47:47 - In reply to message 1 from Delepiere
if you don't mine, could you send me your web script where the csspagination is placed to [email protected]. Maybe i can analyze the main problem.

thanks

  3. Re: some error   Reply   Report abuse  
Picture of pg pg - 2008-10-20 23:34:09 - In reply to message 2 from Dodit Suprianto
Hi Dodit Suprianto,

I try to use your code but I always get "query failed!"

I print the query and test it on Myphpadmin and it works fine!

Any ideai of what is going on?

  4. Re: some error   Reply   Report abuse  
Picture of Dodit Suprianto Dodit Suprianto - 2008-10-21 00:29:57 - In reply to message 3 from pg
maybe you can download an instruction.txt once more, i have fix that bugs. Because i forgot to put the "LIMIT" statement in the second query.

  5. Re: some error   Reply   Report abuse  
Picture of Dodit Suprianto Dodit Suprianto - 2008-10-21 00:32:43 - In reply to message 3 from pg
Dear All.

Please download once more!
I have fix for several bugs emphasis on an instruction.txt and a CSSPagination.class.php.

thanks

  6. Re: some error   Reply   Report abuse  
Picture of Dodit Suprianto Dodit Suprianto - 2008-10-21 00:35:58 - In reply to message 1 from Delepiere
i agree with your statement on point 3 but not all. when i clicked page number 1-5 and jump to the last page, i found wrong page, i will fix it soon. thanks

  7. Re: some error   Reply   Report abuse  
Picture of Dodit Suprianto Dodit Suprianto - 2008-10-21 08:53:30 - In reply to message 1 from Delepiere
i already uploaded the final release. That is no bugs anymore.
I try to read from 20.000 records and splitting to be 15 records per page. its fine and running well, no bugs.

enjoy