Pagination Tutorial for PHP MySQL Programmers – Web Intersect Paging Database Results

Get the independent generic version of this tutorial in text tutorial form here: www.developphp.com Web Intersect Source Code: www.webintersect.com Adam teaches how to throw down on custom PHP MySQL Pagination programming.
Video Rating: 4 / 5

20 comments

  1. MrSbg91

    Hi sir…how to implement this one in search results? Pagination in search results, that’s what i mean.
    Thank you.

    BTW, thanks for this great tutorial.

  2. dzuua

    I need Support, it is working but when i have menu’s category_id
    (
    $id = mysql_real_escape_string($_GET['id']);
    $sql=mysql_query(“SELECT * FROM news WHERE category_id=$id ORDER BY id ASC”);
    ) – it is not working. Help mi :)

  4. LostLegend2015

    Ran out of room.

    I know this isn’t your fault or problem. But I would appreciate any help. Thanks

  5. LostLegend2015

    I dont know if you still support this video but thought Id give it a go.

    Basically your tutorial works perfectly my results are paginated. I’m learning how to build ecommerce sites so pagination is a must. However I have a function that uses the get method to allow users to sort data but if I click second page it loses this sorting specified so the user has to resort every page is there a way to carry this over.

    When I click next page it overrides whats in the url. Any way to add it on instead

  6. motorino64

    Great video as usual, but I have some difficulty to make it work for me , The php file parse on a div content and when I try to change page it parse on new full page , any way to change :$_SERVER['PHP_SELF'] to parse on the div call by javascript ?
    Thanks 

  8. fattbass69

    hi, i have question, i use your pagination tutorial, and i have problem, when i have long comments, they “go” out of bounds of my page, at the page bottom horizontal ruler shows up. what should do ?

  9. tradesmanstips

    Hi I’m getting that error all the time, have you managed to fix it yet? It seems to be something to do with the $sql2? Cheers, Rob.

  13. benyboy6666

    i keep getting this error message, also i am using MAMP, thanks.
    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Applications/MAMP/htdocs/test/scripts/homePage_randomMembers.php on line 33

  18. MrSbg91

    Thanks to you sir…you made me understand pagination thru your video tuts.
    More power.

    I subscribed. :D

  20. onlizhen

    $sql1=mysql_query(“Select pid, title, author, price, picture1 from tblproducts where scid=’$scid’ and penabled=’1′ ORDER BY pid ASC”);

    when i put the $scid it can only be function in first paging when i reach second page the page is blank but when i use the scid in ’1′ can be function and take all from database which the scid is 1 but can use in variable passing