Pagination with jQuery, MySQL and PHP.

Why in page 6 there are no messages? I think line:

$start = ($page-1)*10;

Should be changed to

$start = ($page-1)*$per_page;

looks good, nice tutorial

Great job!

There is one mistake in this tutorial:

this:
var pageNum = $ ( this ) . id;

should be:
var pageNum = this.id;


Thanks alot!

Oh one more thing, is it possible to display new page with fadeIn effect?

Please provide correct "Download Script" as in "Live Preview".

Tutorial as shown above isn't matching with "Download Script(pagination.zip)"

Thanks

Very good stuff. Thanks a lot.

Thanks!!... just what I needed ...
Greetings from Perú

i like that good job man !

very useful script. I am translate your tutorial for my blog in Russian
http://w3forme.ru/всплывающие-со…ния-об-ошибках/
added link in your blog

oops)
http://w3forme.ru/разбиениенумерация-страниц/

When i run it i doesn't work. I recieve a mysql_fetch_array(): supplied argument is not a valid error

i want to do pagin with jsp, is it possible.

could you share yout idea or any materials with me

regards
areef

Nice, i like it, i managed to include this into codeigniter project using the query string feature ON with $_GET variables and on a search form. For example you have form with one input text and one select box, you type in something, select feature from the select box, click search and you get the first 10 results with your pagination and i put the $_POST variables within hidden inputs, so when i make ajax calls to the server i am using the hidden variables to pass to ajax and it came out really good. Thank you very much for your idea though!

How could I add preview and next links?

Thanks for this great script.

Is there any way preview and next links can be added with disabled links as well? Or is it too hard to implement?

yeah.. first page, next page or last page button.. is there any solution..

how about with large data and lots page..

Hello, I have a little hack for this.
Replace the for loop with your own links.

For the 1st page link just add '1',
for the last add the var $pages.
Now for Prev and Next you have to add 2 hidden inputs, one for currentPage and one for lastPage.

The next link will be currentPage+1 and the prev currentPage-1.
Then write a code to disable the next and the last links in the last page, the same for the first page and then you are ready!

I hope this helps you out!

@de4th:
example code will greatfull for the beginner..

I can't post code to comments.
I pasted it to pastebin here:
http://pastebin.com/f44dce6d

Better to be an addition to this tutorial.

When I find some free time I'll create a blog for that stuff...

I got following error


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/filmsadd/public_html/pagination_data.php on line 17

Thanks .. is a great job....

just i've a question..

How can i do a list like:

First Previous 1 2 3 4 5 ..... Next Last

.. The list show all registers of db.


Thanks for help.!

Any solution for mysql_fetch_array(): supplied argument is not a valid MySQL result resource in??

Really great tutorials dude, they have helped me massively :)

So as asked before any ideas how we could add "First Previous 1 2 3 4 5 ..... Next Last" to this already great little web app?

Cheers Jamie

Actually i am calling a php file through ajax in a div when i click on link.I want to use paging in particular div with First Previous 1 2 3 4 5 ..... Next Last.
Is this possible from this script.

Actually i am new in php.Please help me its very urgent.

Thanks in advance

what is the paging.js file for? I do not see it referenced for this tutorial?

Replace:

//Calculating no of pages
$sql = "select * from messages";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
$pages = ceil($count/$per_page);

with:

//Calculating no of pages
$sql = "select count(*) from messages";
$result = mysql_query($sql);
$count = mysql_fetch_row($result);
$pages = ceil($count[0]/$per_page);

because:
Letting MySQL do the counting is SIGNIFICANTLY faster, as it only counts the entries rather than parsing all data, AND only returns a very small block of data :)

$per_page=1;
its not show 1 id show only other

Great tutorial. Thank you.
I need one more thing. Can you tell me how can we use next prev buttons instead of page numbers.

Hi,

There is a bug. Whenever i refresh the page. The page back to page 1.

Plz check this.

Regards,

Umar

How to replace

1 2 3 4 5

With

1 2 .. 5

Please tell me

I'm using this solution (though quite modified) on one of my sites. In regards to a previous question, I am paging through 55,000+ records (2,000+ pages) and not having any issues. So long as the data PER PAGE is small enough to not eat all of PHP's memory, you'll be fine.

Does anyone have any suggestions on how to make this degrade gracefully (i.e., still work to some degree when javascript is disabled)?

tarek
technotarek.com

Thank you for nice tutorial.

Mate must say thank to you the way you have explain the post. I am going to use this jquery example and then use in my office project

Hello Srinivas Tamada:
Thanks for the script! As mentioned earlier this is a very good tool. As also mentioned earlier it would be of great value if you could add or show us how to add the NEXT and PREVIOUS prompts.
Nothing fancy, just the ability to advance or retreat. I was able to write a successful PREVIOUS routine for this but I can’t find a way to find the maximum number of pages to implement a trap for the NEXT routine.
Thanks in advance for support.

Code doesn't pass w3 validation. You are starting an "id" attribute with a number.

Good tutorial,

Never use digits starting and id like id="1" in html,

you have to add a prefix, like id="page1"

nice tutorial but when i executed only the page number is displaying and when i hover the numbers i ddont see any link in the browser

Great tutorial!

But there is an error that blocks the results.

Simply replace this code:
limit $start, $per_page";

For this code:
limit $per_page, $start";

Can someone give an example of how we can handle multiple results in pagination. like in example, what if we have 100 pages. how can i only show the first 10 results and the last, and when i click on page 10 seeing the next 10 and the last and so on.

How can I have that same system using only the links "next" and "previous" in this style ( ), ie, no numbers, and the navigation function in the same way the tutorial?

question translated by google translator, excuse any gramatial errors , hehe.

Thanks but.... There would be alot of numbers if i manage thousands of pages can You make a TUTORIAL on how to make pagination like:

[1] 2 3 4 5 ... 82

PLEASE!!!!
using php and css.... PLEASE Srinivas Tamada, you are a great programmer. thanks in advance (:

Hi,

Thanks!
I just made a small modification in De4th's code: http://pastebin.com/9RFv0ye7

Regards,
Tuub

Thanks, saved me a few minutes with this one :)

Upper case for SQL statements ffs!

Lucifix, you're a moron

Can any one please give me idia how to create User interface with this query.

I am trying to use tomahawk t:dataScroller for pagination on my jsf page. Data is rendered properly for the first page but whenever I try to click any button to go to next page, java script error is thrown as below

form is undefined
var oldTarget = form.target;

Any solution to this will be quite helpful.

I am using tomahawk12-1.1.9 lib with JSF2.0

It's working. Thanks !

Nice website :)

Please provide correct "Download Script" as in "Live Preview".

Tutorial as shown above isn't matching with "Download Script(pagination.zip)"

Thanks

very nice script, with all, so use PDO for PHP and use bind of variables style JAVA prepared statements.
Thank you so match from Perú.

For animation, you can use jCarousel :-)

Awesome stuff

thank you again for your hard work. appreciate.

Thanks for publishing this article. You helped me to open up my eyes. Thanks for publishing and I'm looking forward to your new posts.

Nice tutorial Thanks.............................

this coding really helps me a lots...
please update more and new posts

very useful tutorial...
awesome thanks for sharing this post...

There are no js files in download.

Very nice tutorial. Keep posting Sir.

:D

Thanks for Awesome tutorial. i hope this will really help so many people to learn something new..

Cool Code , tutorial and thank .

http://www.kasanee.com

My little web

kassy :) :)

This is great and I appreciate it that you got shared so handy and useful post.

jQuery, MySQL and PHP.
I was doing research on this topic. was super.

One of the BEST Tutorial I've ever seen..


Thank's a lot!

thanx a lot

thnkk you very much....^^

Hi ,
I have tried to use that code but it shows an empty page with 1,2 but no data are showing..why !!

Also do I need to create CSS file for the last code part !!

Thanks

Hi,

Great Tutorial!

Note:Please change the Table name in Query on line16(i.e message to messages) in "pagination_data.php".


Thanks!

Hi,

Nice Article!

Please change Table name(i.e message to messages)on line 16 in pagination_data.php

Thanks!

actually sincerely speaking this is the best php tutorials i've ever stumbled upon i like it.
9lessons.info the best!

Gracias Gracias :)

Good plugin!
But how can I use it with difference anchor markup (better in SEO). Can you show me?
Thanks in advance!

Hi! I am using qTip to view image preview in the list. It works on first page of results, but on page 2 and beyond the tooltip is no longer applying.

Any ideas about this?

Good effort.. Great Article. Have some more pagination at http://websmine.com/web-development/jquery/jpaginate-a-fantasy-jquery-pagination-plugin/
Thanks for sharing...!!!

guys i am really stuck in this tried couples of ways but didnt get it right please help.My pagiantion is working fine and great untill i specfies WHERE CLAUSE in it.I am trying to have a text field so that if a user enter the interger for class search e.g 8.Pagination search records WHERE class is 8 BUT it show me record only on the first page but when i turn to second page it show a empty page.Please Help me

AWESUM DUDE..HATS OFF

Thanks..........

for a reason i cant download this...and it does not work wen i copy and paste script.

Multiple pagination?

1 2 3 4 5 6 7

and

1 2 3 4

etc

Well this is so very helpful and i really needed guidance on this. Thank you .

Hey this is good.....but i want to take data from 2 tables.............is this code is suitable to take data from two database tables ?

thanks....

It is highly informative for the page nation using PHP

the reload gif ..how to make it display at the center of the tables?

Undefined index: page
and
Warning: mysql_fetch_array() expects parameter 1 to be resource, string given
two type error show how to slove it

Undefined index: page
and
Warning: mysql_fetch_array() expects parameter 1 to be resource, string given
two error show how to solve it

if possible can you tell us how to do pagination with
1 2 3 .... 15 :)))))))))))))

file:
-jquery.js
-jquery_pagination.js
are missing..!!

Just a Question, some of your php demos dont seem to be working, I was kindof disappointed since i was searching through here for inspiration

Yes it's nice but can you one more thing to this tutorial that if i move 1 page to 2 and 2 to 3 and reload the page it should stay at page no 3 not to go on default page.

Madan Kumar

It's nice

Yest it's nice, when i move page 1 to 2 or 3 page and reloading the page it's going back to default page......it's should not be

Does the pagination_data must be on a separate page? I'd like to embed the code on the page with the jquery. can I refer to a php function in: $("#content").load("pagination_data.php?page=" + pageNum, Hide_Load());?

thanks

good Shrinivas ......
you are a very genius engineer

i proud that you are Indian


may u live long. :)

good Shrinivas ......
you are a very genius engineer

i proud that you are Indian


may u live long. :)

Notice: Undefined variable: page in C:\xampp\htdocs\self\pagination_data.php on line 8

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\self\pagination_data.php on line 14

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\self\productlist.php on line

good article

Can anyone help with variables in the mysql statement? For example: instead of just

$query_pag_data = "SELECT * FROM products LIMIT $start, $per_page";

I would like to use

$query_pag_data = "SELECT * FROM products WHERE category='$category' LIMIT $start, $per_page";

But because the url does not change its just doesn't work, can anyone offer a solution?

$per_page = 9;
if(isset($_POST['page']))
{
$page=$_POST['page'];
}

$start = ($page-1)*$per_page;

$sql = "SELECT * FROM video ORDER BY id DESC LIMIT $start, $per_page";



Error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\jquery\index_video.php on line 21

If Raplace $start=0, will run good but don't pagination

Please help me!!!

is it possible to paginate along with filter / search box result on the same file
ie. i want pagination to be done for search result also for values fetched from db in mysql.

It gives me that error:
Undefined variable: page in C:\xampp\htdocs\admin\scripts\pagination_display.php on line 9

thanx dude.. really difficult for me to understand it. :)

ThanX

Thank!!

pagination with where clause not work so give solution for that

It's not working for me, please help :(

its superb and thanks alot.. (:

Nice post,thanks for sharing the informative post.

Good Design and development this site

Nice post. Thank Admin

Valuable advice and accomplished architecture you got here! I would like to acknowledge you for administration your thoughts into the being you post!! Thumbs up

Nice post. Thank Admin

It's working Good. Thanks So much!

Nice code.... Thanks a lot...

best bro

if($_GET)
{
$page=$_GET['page'];
}

Where did i get 'page' in db
and i can't able to unserstand that 'page'

plz tel me....

How to replace

1 2 3 4 5

With

1 2 .. 5

Please tell me

nice tutorial . thanks

great tutorial. How can i limit the numbers?

1 2 3 4 5

With

1 2 .. 5

thanks!