Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jul 1st, 2012  |  syntax: None  |  size: 0.84 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Change mysql column names for use with FPutCSV()
  2. $result = mysql_query("show columns from mash");
  3. for ($i = 0; $i < mysql_num_rows($result); $i++) {
  4.     $colArray[$i] = mysql_fetch_assoc($result);
  5.     $fieldArray[$i] = $colArray[$i]['Field'];
  6. }
  7. fputcsv($fp,$fieldArray);
  8.        
  9. $labels = array(
  10.   'col_name'=>'Column 1',
  11.   'id'=>'User ID'
  12. ); // and so on
  13.  
  14. $result = mysql_query("show columns from mash");
  15. for ($i = 0; $i < mysql_num_rows($result); $i++) {
  16.     $colArray[$i] = mysql_fetch_assoc($result);
  17.     $fieldArray[$i] = $labels[$colArray[$i]['Field']];
  18. }
  19. fputcsv($fp,$fieldArray);
  20.        
  21. $result = mysql_query("show columns from mash");
  22. for ($i = 0; $i < mysql_num_rows($result); $i++) {
  23.     $colArray[$i] = mysql_fetch_assoc($result);
  24.     $fieldArray[$i] = _title_case_function_(str_replace('_', ' ', $colArray[$i]['Field']]));
  25. }
  26. fputcsv($fp,$fieldArray);