News Feed
Sections




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

Gonzalo Ayuso's Blog:
Pivot tables in PHP
January 25, 2010 @ 08:45:51

In this new post today Gonzalo Ayuso shows how to make "pivot tables" (at least the concept) in a PHP script to modify a data set and transform it into something else.

It's not very difficult to handle pivot tables by hand but the work is always the same: groups by, totals, subtotals, totals per row... Now I want to write a class to pivot tables in PHP with the most common requirements (at least for me).

His examples takes a few rows of records from a MySQL result and shows how, with the help of a library he's developed, he can make a few commands and fetch just the data he needs including the column to pivot on. A few more examples are also included.

0 comments voice your opinion now!
pivot table tutorial library group


blog comments powered by Disqus

Similar Posts

Sudheer Satyanarayana's Blog: A Bit Of XML, RSS And CURL In 7 Lines Of PHP And A Useful Program

Zend Developer Zone: Paging Data Sets With PEAR Pager

phpDevelopment Blog: Zend Framework Tutorial Series: Part 3 – Login and Signup with (RE)Captcha

DevShed: Checking Boolean Values with Filters in PHP 5

Zend: Extension Writing Tutorials - Resources (Part 3)


Community Events





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


series podcast symfony list introduction community update release install deployment framework package library laravel api tips zendserver interview language opinion

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