Tag Archive for 'Databases'

Flexible Data Display with PDO and HTML_Table_Matrix

 

Have you ever wanted to set up an application that displays tabular data, and wanted to use the same view for each query?  While PHP is excellent for writing small-footprint queries, its ability to be embedded in HTML leaves the creativity to the programmer to figure out a consistent display solution for tabular data.
We need [...]

MySQL Views to the Rescue!

 

I was recently presented with the challenge of aggregating database hits for content that is e-mailed and commented on.  My gut reaction was to think of a PHP script, or perhaps set of scripts to filter & count the database rows.  Script processing of data sets with proper ORM can yield very meaningful information to [...]

Get Propelled!

 

About two years ago I read of an emerging ORM-solution called Propel.  Having just finished my first full readthrough of PHP 5 Object, Patterns, and Practice by Matt Zandstra, I was eager to research object relational mappers that differed from the one used in that book.  My experience was one of major disappointment.  After spending [...]