MySQL Table Dump

Original - php Code mysqldump --no-create-info --tab=<dir_to_dump_to> --fields-optionally-enclosed-by=<something> --fields-escaped-by=<something> --fields-terminated-by=<something> --lines-terminated-by=<something> db_name [table_name]

 
mysqldump --no-create-info --tab=<dir_to_dump_to> --fields-optionally-enclosed-by=<something> --fields-escaped-by=<something> --fields-terminated-by=<something> --lines-terminated-by=<something> db_name [table_name] 

Original - php Code <?php //use a select like: SELECT * FROM <table>; //then, using mysql_fetch_array" while($holding[]=mysql_fetch_array()); //take away the last element which is not valid unset($holding[count($holding)-1); //open the file to write out to... //write out the column headers in CSV format //build the array to write out... for($x=0,$y=count($holding);$x<$y;$x++){ $out_ara=implode(',',$holding[$x]); $out_ara.="n"; //write out $out_ara to the file } //now close the file //you are done... ?>

 
<?php
//use a select like: SELECT * FROM <table>;
//then, using mysql_fetch_array"
while($holding[]=mysql_fetch_array());
 
//take away the last element which is not valid
unset($holding[count($holding)-1);
 
//open the file to write out to...
 
//write out the column headers in CSV format
 
//build the array to write out...
for($x=0,$y=count($holding);$x<$y;$x++){
  $out_ara=implode(',',$holding[$x]);
  $out_ara.="n";
  //write out $out_ara to the file
}
 
//now close the file
 
//you are done...
?> 

Original - php Code <?php function alter_field (&$value, $key) { $value = str_replace ('"', '""', $value); //eliminating the new-lines //i'm not really sure about this substitution //so you should cnheck it somehow $value = str_replace ("rn", 'n', $value); //embracing with quotation marks $value = '"' . $value . '"'; } //build the array to write out... for($x=0,$y=count($holding);$x<$y;$x++){ array_walk ($holding[$x], 'alter_field'); $out_ara=implode(',',$holding[$x]); $out_ara.="n"; //write out $out_ara to the file } ?>

 
<?php
 
function alter_field (&$value, $key) {
 
  $value = str_replace ('"', '""', $value);
  //eliminating the new-lines
  //i'm not really sure about this substitution
  //so you should cnheck it somehow
  $value = str_replace ("rn", 'n', $value);
  //embracing with quotation marks
  $value = '"' . $value . '"';
 
}
 
//build the array to write out...
for($x=0,$y=count($holding);$x<$y;$x++){
  array_walk ($holding[$x], 'alter_field');
  $out_ara=implode(',',$holding[$x]);
  $out_ara.="n";
  //write out $out_ara to the file
}
?>