May
27

Ajax Pagination: Fresh Ajax pagination using PHP jQuery and mySQL. Part 3

Author ZeeShaN    Category AJAX, JQuery, PHP, Web Development     Tags

Today i am going to build a simple ajax based pagination system with overlay loader to put some attractive look. Demo and code available.

Table Structure

CREATE TABLE `records` (
  `id` int(11) NOT NULL auto_increment,
  `img` varchar(255) NOT NULL,
  `message` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
)

Add To Facebook Stumble This Digg This Add To Del.icio.us Add To Reddit Add To Yahoo Add To Twitter


Written by ZeeShaN

ZeeShaN RasooL is a web developer who loves to work in latest technologies to create more interactive dynamic and beautiful web pages.

  • Irfan Ahmed

    i have used inside joomla 1.5 , excellent work Zee.

    December 17 2011
    CommentsLike
    • Ody

      Or it uses more tables ?

      i like your article

      thank you mr. ZeeShaN

      November 17 2011
      CommentsLike
      • Ody

        what about when it uses 2 tables?

        November 17 2011
        CommentsLike
        • ZeeShaN

          Thanks Brenda :)

          November 02 2011
          CommentsLike
          • Brenda

            dbcon.php

            $host=”localhost”;
            $usuario=”youruser”;
            $contrasenia=”yourpass”;

            $conectar=mysql_connect($host,$usuario,$contrasenia);

            mysql_select_db (“yourdatabase”,$conectar);

            November 02 2011
            CommentsLike
            • Brenda

              dbcon.php

              November 02 2011
              CommentsLike
              • Brenda

                Excellent :d

                dbcon.php

                ——————————————-
                Yo have to change this sentence in data.php
                $sql = “select * from records order by id limit “.$start.”,4″;
                :D and It works perfectly

                November 02 2011
                CommentsLike

                • hi every one how can make a php mysql ajax pagination like previous 1,2,3,[4],5,6,7,8,9 next when next the url will change and also result.i need it done by ajax

                  August 31 2011
                  CommentsLike
                  • calle

                    Great script! i’m trying to pass multiple params through it without any luck..

                    Can anyone see what’s wrong in this? The class is set in
                    $(“#content”).load(“data2.php?page=” + this.id + “&category=” + this.class, hideLoader);

                    August 24 2011
                    CommentsLike
                    • ss

                      adsasdasd

                      July 20 2011
                      CommentsLike








                      Enter your Email:

                      Click Here for Popular

                      Who I Am

                      Zeeshan Rasool

                      Software Engineer - PHP
                      Lahore - Pakistan

                      zeeshan(@)99points.info
                      Skype: zeeshan-rasool
                      gTalk: zishan.rasool85

                      Categories

                      Tags

                      Comments