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