Guest User

Untitled

a guest
Dec 11th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. private function tr_csv_from_result($query, $delim = ";", $newline = "\n", $enclosure = '"')
  2. {
  3. if ( ! is_object($query) OR ! method_exists($query, 'list_fields'))
  4. {
  5. show_error('You must submit a valid result object');
  6. }
  7.  
  8. $out = '';
  9.  
  10. foreach ($query->list_fields() as $name)
  11. {
  12. $out .= $enclosure.str_replace($enclosure, $enclosure.$enclosure, $name).$enclosure.$delim;
  13. }
  14.  
  15. $out = rtrim($out);
  16. $out .= $newline;
  17.  
  18. foreach ($query->result_array() as $row)
  19. {
  20. foreach ($row as $item)
  21. {
  22. if($item == '' || strlen($item) < 1) $item = '-';
  23. $out .= $enclosure.str_replace($enclosure, $enclosure.$enclosure, str_replace("\n","&nbsp;",$item) ).$enclosure.$delim;
  24. }
  25. $out = rtrim($out);
  26. $out .= $newline;
  27. }
  28.  
  29. return $out;
  30. }
Add Comment
Please, Sign In to add comment