ImadJomaa

ImadJomaa supports this item

Supported

70 comments found.

Hi there,

Thanks for a great script. I have used your script without problems, but i have a project that makes use of MySQLi and not PDO. Do you also have a guide for MySQLi? I am not a PHP genius therefore I find it a bit difficult converting PDO to MySqli to get the script working on my other projects.

Thanx!

Hi jmgrafixx,

Thanks you for your support. Are you looking for an example file that walks through the MySQLi extension? Shoot me an email through my CodeCanyon profile, and I can send you the example file. =)

All the best, Imad Jomaa.

Hi Imad. Thanks! Yes, and example for the MySQLi extension would be great. I can then follow the script to make the pagination work with MySQLi as well! I appreciate your assistance!

Perfect, just shoot me an email from the form on the right here http://codecanyon.net/user/imadjomaa so I can send you the file. =)

All the best, Imad Jomaa.

I can’t make this work. $dsn = ‘mysql:dbname=test;host=127.0.0.1;port=3306’; or this $dsn = ‘mysql:dbname=test;host=127.0.0.1’; Is there some simple connection to MySQL database?

Hi predragstevanovic,

What error are you getting? If you’re not using the PDO extension to connect to the database, then you should use the respective mysqli functions. If you’d like an example file for those functions instead, shoot me an email through the form here http://codecanyon.net/user/imadjomaa and I’ll send it your way.

All the best, Imad Jomaa.

I can customize with my CSS?

Yes, absolutely. =)

Already solved, thanks

Hello,

I would like to get this script but I have a table with 6.8 million records.

Can this script handle it? I would the MySQLi version please.

Thank You

Regards,

Erjon Galanxhi

Hi Erjon,

I have not tested this on table with over 1 million records. However, it is worth noting that, in its default form, the script leverages the SQL limit statement, as you paginate and get to a relatively high page number, the query will slow down. There are tricks to maintain speed, albeit, this type of pagination is not recommended for that amount of records.

All the best, Imad.

Hi Imad, Thank you for your reply and all the best.

Hi Jooma,

I purchase your script, very nice btw :)

But Im facing a little problem that I hope you can help me solve, I hace a search engine that generates the pagination with you code, I make it work correctly only for the first page, then on second page all the “searched terms” are gone and the pagination script shows all the data from the table (the $limit works correctly)

thanks for your help

Hi kiketorres3,

It’s hard to see what’s going on without seeing how you implemented it. Can you email me some more details via my profile here: https://codecanyon.net/user/imadjomaa

Thanks, Imad.

Hi Imad,

I am hoping you can help with an issue i have with the pagination on my site, you helped me a couple of years ago

Hi John!

I’ve shot you an email. =)

Cheers, Imad.

lear

lear Purchased

how can i use multiple instances of this on the same page without having to duplicate class and template files (and renaming class and function names in the duplicated class file)? can i use this on more than one table on the same page quickly and easily? how do i do that?

Hi Lear,

You don’t need to duplicate the template file or class files to make the changes you wish to make. When instantiating the pagination class, just make sure they share two different variable names thereby having two different instances. As for the anchors, yes, just set that up in the url parameter of the paginator.

Cheers, Imad.

lear

lear Purchased

don’t know what you mean. what does that look like in php code?

Hi Lear,

Can you shoot me an email via my profile? I’ll send you an example file.

Cheers, Imad.

Hi Can your code use in search mysql database and show with pagination?

Hi winmintun, the pagination class can be used for any select query, so your search query should work just fine. =)

realeman

realeman Purchased

Hi, I am trying to add an anchor to the end of URL string and not sure how to do this with the page number being added dynamically at the end of the string. Thanks!

realeman

realeman Purchased

Hi, I am trying to add an anchor to the end of URL string and not sure how to do this with the page number being added dynamically at the end of the string. Thanks!

Hi realeman,

I’ll be pushing an update to this to accommodate anchors. If you’d like it sooner, feel free to send me an email from my profile and I’ll send you the updated files.

Thanks for your support. =)

Cheers, Imad.

by
by
by
by
by
by