To use just paste and run from JFoxConsole tab, and edit with table want export.
/* JoomlaFox! Code Snippet to export Joomla table as .csv, Version 1.0, 2009-12-05
* by Emerson Rocha Luiz - Licenced by Creative Commons By 3.0
* http://www.fititnt.org/codigo/joomlafox/export-csv.html */
$joomla_table = 'users'; //Edit for one simple table export (no need table prefix)
$query = "";// Edit here if you want COMPLEX selects from table(s)/especific fields
//TODO: make this code a bit more 'Joomla Framework Like'
$app = JFactory::getApplication();
$table = $app->getCfg('dbprefix') . $joomla_table;
if (!$query){
$query = "select * from $table";
}
$host = $app->getCfg('host');
$db = $app->getCfg('db');
$user = $app->getCfg('user');
$password = $app->getCfg('password');
$myquery = mysql_query($query);
$fields_cnt = mysql_num_fields($myquery);
$time=date('m.d.y-H.i.s');
$filenameoutput ="JFoxCSV-{$joomla_table}_{$time}";
//Output CSV Options
$line_terminated = "\n";
$field_terminated = ",";
$enclosed = '"';
$escaped = '\\';
$export_schema = '';
for ($i = 0; $i < $fields_cnt; $i++)
{
$l = $enclosed . str_replace($enclosed, $escaped . $enclosed,
stripslashes(mysql_field_name($myquery, $i))) . $enclosed;
$export_schema .= $l;
$export_schema .= $field_terminated;
}
$output = trim(substr($export_schema, 0, -1));
$output .= $line_terminated;
while ($row = mysql_fetch_array($myquery))
{
$export_schema = '';
for ($j = 0; $j < $fields_cnt; $j++)
{
if ($row[$j] == '0' || $row[$j] != '')
{
if ($enclosed == '')
{
$export_schema .= $row[$j];
} else
{
$export_schema .= $enclosed .
str_replace($enclosed, $escaped . $enclosed, $row[$j]) . $enclosed;
}
} else
{
$export_schema .= '';
}
if ($j < $fields_cnt - 1)
{
$export_schema .= $field_terminated;
}
}
$output .= $export_schema;
$output .= $line_terminated;
}
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Length: " . strlen($output));
header("Content-type: application/csv");
header("Content-Disposition: attachment; filename={$filenameoutput}.csv");
echo $output;
exit;
$app->close();