CSV generation in PHP Smarty

Question

I have the PHP output, which is in table form, and I want that output in CSV format. How can I get that using PHP Smarty?

Answer 1

You should parse that PHP output with an xml parser. Use somethink like:

$phpOutput = ... ; //this is the output containing only the table
$xml = simplexml_load_string($phpOutput);
$csvOutput = "";
foreach ($xml->tr as $rows)
{
   $cells = array();
   foreach ($rows->td as $cell)
   {
      $cells[] = (string)$cell;
   }
   $csvOutput .= implode(",",$cells)."\r\n";
}

$smarty->assign("csv",$csvOutput);

Of course you must be careful and close every tag if you don't want to get warnings.