Contents tagged with paging
-
Paging Data with Different Cursor Types
This post is a follow up to a post I did last week: Paging Data with the SQL Server Drivers for PHP: Simplified. In that post, I showed how to leverage scrollable cursors to simplify code for paging data. However, my investigation used only one type of scrollable cursor: a static cursor. In this post, I’ll investigate the behavioral differences of paging data with a static cursor and the other two scrollable cursor types: keyset and dynamic cursors. I did write a high-level comparison of the different cursor types last year, but what I really want to focus on in this post are the practical differences between the different cursor types in the paging scenario.
-
Paging Data with the SQL Server Drivers for PHP: Simplified
One of the best insights I had at the SQL Server JumpIn! Camp back in November was this: Lots of PHP applications and frameworks generate SQL queries dynamically. I’m sure that for very experienced developers, that realization comes across as somewhat naive – and perhaps it is. However, to be clear, the realization had more to do with just how often applications/frameworks need to dynamically create SQL queries, not that the practice is sometimes necessary.
-
How to Page Data with the SQL Server Drivers for PHP
Shortly after the 1.0 version of the SQL Server Driver for PHP was released, I posted on the team blog as about how to page data with the driver. In the v1.1 release of the driver, the team added some functionality that made paging data easier and more intuitive, but I never got around to a blog post that showed how to use the new functionality. 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.)