JAVASCRIPT

Paginating Database Records with the jQuery Quick Pagination Plug-in

In this fourth part of a five-part series, I start developing a basic database-driven web application that displays a list of fictional users fetched from a MySQL table. The application is capable of generating a couple of static sections of a web page, including the typical header and footer sections.

Author Info:

By: Alejandro Gervasio

Poor Best

Rating:

/ 2

December 30, 2009

TABLE OF CONTENTS:

<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse auctor commodo risus, et ultrices sapien vestibulum non. Maecenas scelerisque quam a nulla mattis tincidunt. Etiam massa libero, pharetra vel laoreet et, ultrices non leo. Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>

</div>

(footer.htm)

<h2>Footer section</h2>

</div>

</body>

</html>

As seen above, the XHTML page responsible for displaying the set of paginated database records will be assembled in separate sections, a commonly-used approach when working with procedural PHP scripts. At this stage, only the page’s header and footer static areas have been defined, but there’s a section to come that will show dynamic content fetched from the corresponding “users” MySQL table.

But guess what? The definition of this remaining partial web page will be covered in the final part of the series, so for the moment feel free to take a deep breath and read the remainder of this article.

Final thoughts

That’s all for the moment. In this fourth chapter of the series, I started developing a basic database-driven web application that displays a list of fictional users fetched from a MySQL table. So far, the application is in a rather incomplete state, since it’s only capable of generating a couple of static sections of a web page, including the typical header and footer sections.

It’s necessary to define an additional section that not only shows the user-related database records on screen, but displays them in chunks of paginated data. Well, all of these tasks will be properly addressed in the last tutorial of the series. They will require the implementation of a page controller in PHP and the use of the Quick Pagination plug-in.

Don’t miss the final chapter!

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.