ADOdb: Quick Export Data

Export data to CSV (Comma Separated Value) and tab-delimited formats is one of cute fiture in ADOdb. You can add simple line code to produce data in csv. It will usefull if you want create backup feature in your application (without write complicated code).

Below for example:

<?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); 
    } 
?>