News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brian Swan's Blog:
How to Page Data with the SQL Server Drivers for PHP
July 22, 2010 @ 09:16:01

Brian Swan has a quick new post today about using the pagination feature in the latest version of the SQL Server driver for PHP.

So, with the final release of the 2.0 version of the driver coming soon, I thought it was high time I posted something about using the functionality that was added in the v1.1 driver (better late then never!). While I'm at it, I'll include code that shows how to do paging with the PDO driver. (Complete scripts attached to this post.)

He gives a basic example of paginated data that lets you move back and forth with simple text links on the page. The key is in the row_number function that lets you specify the block of records to return. Code is included for this and a few other modifications including numeric links to jump to certain pages in the results. All scripts are included as a download.

0 comments voice your opinion now!
sqlserver driver pagination tutorial feature


blog comments powered by Disqus

Similar Posts

DevShed: A Better Way to Determine MIME Types for MIME Email with PHP

Jakub Zalas' Blog: Mocking Symfony Container services in Behat scenarios with Mockery

IBM developerWorks: A step-by-step guide to publishing your own PEAR channels

Stefan Mischook's Blog: PHP Shopping Cart Tutorial

Abou Kone's Blog: Set up JSON action output in CakePHP 1.3


Community Events

Don't see your event here?
Let us know!


framework community laravel5 opinion symfony interview api threedevsandamaybe release version introduction security unittest podcast language voicesoftheelephpant series laravel library extension

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework