chongchian
asked on
PHP Reporting System
Hi All,
I'm in the process of building a PHP-based reporting system. I've previously did so easily with ASP.NET's Reporting Services. I was wondering if PHP does have any sort of similar frameworks that I can take advantage of for this purpose?
--
Thks.
I'm in the process of building a PHP-based reporting system. I've previously did so easily with ASP.NET's Reporting Services. I was wondering if PHP does have any sort of similar frameworks that I can take advantage of for this purpose?
--
Thks.
ASKER
Hi themrrobert, thank you for your advice and rapid feedback, which I am gateful for . :)
Basically, I've a database of info and couple select scripts, from which, I would be required to make use of PHP to allow others to view those info via the browser.
This is really simple if I were to make use of the mysql_connect, mysql_select_db and mysql_fetch_row.
However, what I hope to do is to make it really rich like even AJAX enabled and having the ability to export it to PDF, Excel, etc.
Basically, I've a database of info and couple select scripts, from which, I would be required to make use of PHP to allow others to view those info via the browser.
This is really simple if I were to make use of the mysql_connect, mysql_select_db and mysql_fetch_row.
However, what I hope to do is to make it really rich like even AJAX enabled and having the ability to export it to PDF, Excel, etc.
Hi chongchaian
Refer the following urls.
export to pdf...
http://scripts.ringsworld.com/organizers/cookdojo-home/export-pdf.php.html
http://www.universalwebservices.net/web-programming-resources/php/using-php-to-export-content-to-adobe-acrobat-forms/
Excel
http://www.dougboude.com/blog/1/2009/06/PHP-Export-to-Excel-Snippet.cfm
Refer the following urls.
export to pdf...
http://scripts.ringsworld.com/organizers/cookdojo-home/export-pdf.php.html
http://www.universalwebservices.net/web-programming-resources/php/using-php-to-export-content-to-adobe-acrobat-forms/
Excel
http://www.dougboude.com/blog/1/2009/06/PHP-Export-to-Excel-Snippet.cfm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to make reports of sql tables, do it yourself. I'm sure you can find them on google if you really want to.
SELECT * FROM `table` WHERE 1 ORDER BY `time` SORT DESC
use PEAR::DB or MDB2 and then:
$db->setFetchMode(DB_FETCH
$ret = $db->getAll($sql);
$hs = $row[0];
$header_html = ''; //generate headers \/
foreach($hs as $k=>$v) {
$header_html .= "<th>$k</th>";
}
foreach($ret as $row) {
$html .= "<tr>";
foreach($row as $k => $v )
{
$html .= "<td>$v</td>";
}
$html .= "</tr>";
}
$html = "<table><tr>${header_html}
echo $html;
BAM report done