All software listed below is available free of charge, and may be distributed freely. The software is provided as-is, with no warranty, implied or otherwise.
This class is designed to output lists or reports of data, typically directly from database query results, but also quite useful for quickly formatting generic array results for display. Features include record linking (i.e. the link for each row in the resulting list depends on the values of data within that row - useful in drill-down style reporting systems), record pagination, column sorting, customizable list colors and styles, row highlighting, and downloading to delimited text files and XML.
Read a tutorial suite of examples using the ReportList class here.
SqlCommand (Zip archive, Latest version: 2005-12-07)
SqlCommand (Zip archive, 2004-04-01)
The SqlCommand class improves the functionality and simplicity of calling stored procedures in a Microsoft SQL Server database via PHP (using the PEAR database connectivity library). The Zip file contains the class itself, as well as full documentation and example usage. Click here to view the readme file.
Read an article about this class on SitePoint or locally here.
The methodology behind using XML query definitions to build OleDbCommand and SqlCommand objects in your .NET applications, on-the-fly at runtime. This allows you to decouple more of your database code from your middle-tier logic than even stored procedure usage alone will allow for.
Read an article about this on SitePoint or locally here.