PHP Tutorials: Pagination (Part 1)

July 10th, 2010 | by admin |


Visit the forum for help! phpacademy.info Follow on Twitter! twitter.com Paginating results from a MySQL database. This is a (almost) simple method of showing paginated results effectively.

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

  1. 25 Responses to “PHP Tutorials: Pagination (Part 1)”

  2. By harleybalo on Sep 21, 2009 | Reply

    Easy to understand… Good work man

  3. By Josabooba on Oct 19, 2009 | Reply

    Result! :-)

  4. By shanetalbert on Nov 2, 2009 | Reply

    sweet! very easy to understand. 5/5

  5. By silvavids on Nov 9, 2009 | Reply

    where could i insert this on the search engine result page from your search engine tutorial please help…

  6. By punxz18 on Nov 10, 2009 | Reply

    question: may i use mysql_fetch_object instead of assoc in your while?

  7. By punxz18 on Nov 10, 2009 | Reply

    I am using your dynamaic page tutorial with this pagination of yours and everytime i click on a link it goes blank :(

  8. By someturkishguy on Nov 11, 2009 | Reply

    to count all the data in table you should not select all fields in table…

    SELECT COUNT(*) as total FROM table

    should work better…

  9. By ScriptFire on Nov 19, 2009 | Reply

    This is your best video ever :D Thank you so much!

  10. By Kamangir6 on Nov 23, 2009 | Reply

    Very good tutorial !!

  11. By willzurmacht on Nov 28, 2009 | Reply

    Thank you very much. adding on my favorites. lots debts on you man.

  12. By Lukaydo on Dec 4, 2009 | Reply

    hi, for first sorry for my english :)
    great tutorial it very helps me, but i add this “if($start < 0) $start = 0;" after this code in your example "if(!$start)$start = 0;" cause if you add manualy $star in url for example 3, than if you select previous button the value of start will be -2 (in your example) and there will be error. and this if($start < 0) $start = 0 give the value 0 of $start instead of -2 // correct me if i am wrong :)

  13. By fabiotimor on Dec 13, 2009 | Reply

    YOU ARE THE BEST!!!

  14. By lnorby06 on Jan 10, 2010 | Reply

    and even faster…

  15. By darkelectrofreak on Feb 19, 2010 | Reply

    Brilliant tutorial, thank you very much.

  16. By AdamHamletKiani on Mar 14, 2010 | Reply

    you cant click when your mouse displays the thinking cursor? THATS strange

  17. By waleed7s on Mar 27, 2010 | Reply

    Thank you so much

  18. By nsp2win on Apr 3, 2010 | Reply

    @qabandiman you should probably be doing if ( !isset($start) ) instead of just !$start

  19. By sebastinselvaraj on Apr 20, 2010 | Reply

    hi i uss this code but its one error thst is undefine index start in fir t part so i could not continue so please cleare tht start variable ……………… mail me urgent mail4sebastin selvaraj gmail .coom

  20. By Stijnhy on Apr 29, 2010 | Reply

    Thanks a lot buddy, I really thought this was WAY more complex. I implented this in a site announcing a party, check it out :)

    vive-lawete(dot)be(dot)tt

  21. By sarmenhb on May 9, 2010 | Reply

    isnt the term pagination refered to as page-in-ation rather than pag-in-ation ?

  22. By rickyja100 on Jun 17, 2010 | Reply

    heyy i get a error with this line of code if (!$start)

  23. By rickyja100 on Jun 17, 2010 | Reply

    i have a error with this line of code $start = $_GET ['start'];

  24. By PartyPooperX on Jun 23, 2010 | Reply

    thanks for the video!

  25. By polinejkes123 on Jun 26, 2010 | Reply

    Very very very helpful. And what is the most important?? it was showed in the easiest way in the world how to create pagination. That user has so many super videos that i will download all of them.

  26. By webmastersize on Jun 27, 2010 | Reply

    For the Error : Notice: “Undefined index: start …” Type:

    if (!isset($_GET['start']))
    $_GET['start']=’0′;

    At the Beginning.

    Rate The comment so other people can see it :)

Post a Comment