Dynamic MySQL Next Page Slide Effects?

Discussion in 'HTML & Website Design' started by scottlpool2003, Nov 19, 2012.

  1. #1
    I'm pulling data from MySql using PHP and displaying 5 per page while using << Previous Next >> buttons to grab the next page so the URL looks like: ?id=59&page=2

    Is there a way to put some kind of effect on this such as a page transition or does anybody know of a way to do it in CSS3 or JQuery?
     
    scottlpool2003, Nov 19, 2012 IP
  2. Zora2012

    Zora2012 Greenhorn

    Messages:
    82
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    6
    #2
    Dynamic fader effect image transitions in IE highlight this easy, short, cross-browser cut-and-paste script that presents images in a continuous slideshow format. Any number of images can be used, and timing is adjustable.It is great for newcomers, but a solid utility script, too.
     
    Zora2012, Nov 20, 2012 IP
  3. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #3
    Use POST instead of GET to eliminate the URL. You can use GET to just retrieve data, but you don't have to.
     
    Rukbat, Nov 22, 2012 IP
  4. scottlpool2003

    scottlpool2003 Well-Known Member

    Messages:
    1,708
    Likes Received:
    49
    Best Answers:
    9
    Trophy Points:
    150
    #4
    That means my navigation links would be forms? The pages are dynamic categories, pages etc so post wouldn't work in this instance.
     
    scottlpool2003, Nov 23, 2012 IP
  5. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #5
    No, it just means that the URL wouldn't show the data, the question mark and the parts after it. The data would still be sent to the PHP page.
     
    Rukbat, Nov 23, 2012 IP
  6. ArticleMonkey

    ArticleMonkey Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    don't forget to use rel="next" and rel="prev" on your links...
     
    ArticleMonkey, Nov 24, 2012 IP
  7. scottlpool2003

    scottlpool2003 Well-Known Member

    Messages:
    1,708
    Likes Received:
    49
    Best Answers:
    9
    Trophy Points:
    150
    #7
    Thanks, it's not exactly what I was asking for though. I was asking if there's a better way to pull out the records for next/previous pages rather than ugly refreshing.

    The page works like this:

    ?id=1 > This is a main item but within this I have a list of related items which I have limited to 10 with next/previous buttons. If the button is clicked, the URL becomes
    ?id=1&page=2

    What I need is a more efficient way to pull the related items out without putting too much of a load on the server and without refreshing the page.
     
    scottlpool2003, Nov 26, 2012 IP
  8. scottlpool2003

    scottlpool2003 Well-Known Member

    Messages:
    1,708
    Likes Received:
    49
    Best Answers:
    9
    Trophy Points:
    150
    #8
    This does not relate to the question at all...
     
    scottlpool2003, Nov 26, 2012 IP
  9. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #9
    Using LIMIT doesn't put much load on the server.

    Use AJAX.
     
    Rukbat, Nov 26, 2012 IP
  10. bowodesign

    bowodesign Member

    Messages:
    55
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #10
    found this, maybe this can help you hxxp://www.9lessons.info/2010/10/pagination-with-jquery-php-ajax-and.html or maybe you will find the answer from one of this hxxp://www.jqueryrain.com/2012/04/best-ajax-jquery-pagination-plugin-tutorial-with-example-demo/
     
    bowodesign, Nov 26, 2012 IP