SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast
    Join Date
    Jun 2011
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Multiple pages for search results from msql database

    Hi all,

    Another quick (possible long) question.

    I have a msql database with lots of data in, when I do a php script to search and pull up the information I want the webpage has loads of records displayed, what I want to do is have it display say 10 then at the bottom of the list have page numbers that will allow users to move to the next page etc, like on most websites, I just wanted to know how you do this.

    Hope this makes sense

    Thanks






    ---
    - Sent from my iPhone using Tapatalk

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,508
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    Yes it makes sense
    It's called pagination. Try a search in this forum, or google for it, and you'll find tons of examples.

  3. #3
    SitePoint Enthusiast
    Join Date
    Jun 2011
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks mate I didn't know what it was called, thanks for your tip


    ---
    - Sent from my iPhone using Tapatalk

  4. #4
    SitePoint Enthusiast
    Join Date
    Jun 2011
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The first google search with knowing the name brings a great tutorial,

    http://www.phpfreaks.com/tutorial/basic-pagination

    Thanks


    ---
    - Sent from my iPhone using Tapatalk

  5. #5
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,508
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    You're welcome. If you have any questions/problems when you implement the pagination, don't hesitate to post them here.

  6. #6
    SitePoint Enthusiast
    Join Date
    Jun 2011
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you


    ---
    - Sent from my iPhone using Tapatalk

  7. #7
    SitePoint Enthusiast
    Join Date
    Aug 2010
    Location
    Perundurai, Tamilnadu, India
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Here is another paginator which i used it in few clients websites.

    PHP Paginator

    This is very easy pluginable in any code and which works very independently.
    Might useful for you.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •