Php & Pear Development

[Reup]

I've been using a couple of useful PHP classes I'd thought I'd share:

FPDF - A quick PDF creation class (http://www.fpdf.org/)
This is a really easy way to create good looking PDF documents on the fly! I've made colourfull tables and more with this in minutes!

PHPMailer - Great mail class (http://phpmailer.sourceforge.net/)
It has so many neat options!

And recently discovered the benefit of using PEAR-classes as well! I've used Spreadsheet_Excel_Writer (http://pear.php.net/package/Spreadsheet_Excel_Writer) to create .XLS files really quickly. I've been digging through all the other PEAR-classes and there are so many that look great. If anyone's interested I'll post my generic MySQL-dataset to .XLS-'parser' :ok:

If someone else has nifty classes they wrote or know about, I'd like to hear about them (links to if you got 'em)!

[Data]

indedd handy.

[Reup]

For anyone interested. This only works if PEAR is installed and configured on your server.


require_once 'Spreadsheet/Excel/Writer.php';

// $dataSet is any MySQL-query-result
// $title is the file-name including the complete path
// $MODE == 0 -> save as local file
// $MODE == 1 -> send HTTP headers -> open in browser! only use in NEW file, or
// the remaining HTML will be send to the sheet as well!!!

function writeExcel( $dataSet, $title, $MODE )
{
// Creating a workbook
$filename = $title.'.xls';
$pathname = '.';
$workbook = new Spreadsheet_Excel_Writer( $pathname.$filename );

// Creating formats
// Only bold in this case
$format_bold =& $workbook->addFormat();
$format_bold->setBold();

// sending HTTP headers if $MODE is set to 1
if( $MODE == 1 ) $workbook->send($filename);

// Creating a worksheet
$worksheet =& $workbook->addWorksheet('SU5-Aanvragen'.$datum);

// Writing column headers (bold)
$numFields = mysql_num_fields( $dataSet );
for( $k = 0; $k < $numFields; $k++ )
{
*$field = mysql_fetch_field( $dataSet, $k );
*$fieldName = $field->name;
*
*$worksheet->write( 0, $k, $fieldName, $format_bold );
}
*
//writing data, row for row (regular)
for( $i = 0; $i < mysql_num_rows( $dataSet ); $i++ )
{
*// starting form row 1, because row 0 is the header-row
*$row = mysql_fetch_array( $dataSet );
*$index = $i + 1;
*for( $k = 0; $k < $numFields; $k++ )
*{
* $worksheet->write( $index, $k, $row[$k], $formal_bold );
*} *
}

// return the filename!

// Let's send the file
$workbook->close();

return $pathname.$filename;
}