ADOdb Library for PHP Manual
Prev	Exporting in CSV or Tab-Delimited Format	Next

Exporting in CSV or Tab-Delimited Format

We provide some helper functions to export in comma-separated-value (CSV) and tab-delimited formats:

 <?php 

    include_once('toexport.inc.php'); 


    include_once('adodb.inc.php'); 




    $db = 
&NewADOConnection('mysql'); 


    $db->Connect($server, 
$userid, $password, 
$database); 

    $rs = 
$db->Execute('select 
fname as "First Name", surname as "Surname" from table'); 




    print "<pre>"; 


    print rs2csv($rs); 
# return a string, CSV format 

    print '<hr>'; 


    $rs->MoveFirst(); 
# note, some databases do not support MoveFirst 

    print rs2tab($rs,false); 
# return a string, tab-delimited false == suppress 
field names in first line 



    print '<hr>'; 


    $rs->MoveFirst(); 


    rs2tabout($rs); 
# send to stdout directly (there is also an rs2csvout 
function) 

    print "</pre>"; 




    $rs->MoveFirst(); 


    $fp = 
fopen($path, 
"w"); 

    if ($fp) 
{ 

        rs2csvfile($rs, 
$fp); # 
write to file (there is also an rs2tabfile function) 

        fclose($fp); 


    } 

?>

Carriage-returns or newlines are converted to spaces. Field names are returned in the first line of text. Strings containing the delimiter character are quoted with double-quotes. Double-quotes are double-quoted again. This conforms to Excel import and export guide-lines.

All the above functions take as an optional last parameter, $addtitles which defaults to true. When set to false field names in the first line are suppressed.

Prev	Home	Next
Implementing Scrolling with Next and Previous	Up	Recordset Filters