/**
* Returns the data for one table
*
* @access public
*
* @param AbstractDB $db db identifier
* @param String $table table name
* @param Integer $type ANYDB_DUMP_ constants
* @param String $seperator for csv files
*
* @returns Array the table data
*/
function getTableData(&$db, $table, $type = ANYDB_DUMP_SQL, $seperator = "\t")
{
$res = '';
$first = true;
// get all the data
$query = "SELECT * FROM {$table}";
$db->query($query, ANYDB_RES_ASSOC);
while ($line = $db->getNext()) {
$line = $db->escapeStr($line);
switch ($type) {
case ANYDB_DUMP_SQL:
$res .= QueryHelper::insert($table, $line) . ";\n";
break;
case ANYDB_DUMP_CSV:
if ($first) {
$res .= implode($seperator, array_keys($line)) . "\n";
$first = false;
}
$res .= implode($seperator, $line) . "\n";
break;
}
}
return $res;
}
