function csv_output($query) { global $fields; $result = full_query($query); while ($data = mysql_fetch_array($result)) { foreach ($fields as $field) { echo csv_clean($data[$field]) . ","; } echo "\r\n"; } }
/** * Print generic normal Item Cell * * @param $type display type (0=HTML, 1=Sylk,2=PDF,3=CSV) * @param $value value to display * @param $num column number * @param $row row number * @param $extraparam extra parameters for display * *@return string to display **/ static function showItem($type, $value, &$num, $row, $extraparam = '') { $out = ""; switch ($type) { case PDF_OUTPUT_LANDSCAPE: //pdf //pdf case PDF_OUTPUT_PORTRAIT: global $PDF_ARRAY, $PDF_HEADER; $value = weblink_extract($value); $PDF_ARRAY[$row][$num] = decodeFromUtf8(html_clean($value), 'windows-1252'); break; case SYLK_OUTPUT: //sylk global $SYLK_ARRAY, $SYLK_HEADER, $SYLK_SIZE; $value = weblink_extract($value); $SYLK_ARRAY[$row][$num] = sylk_clean($value); $SYLK_SIZE[$num] = max($SYLK_SIZE[$num], utf8_strlen($SYLK_ARRAY[$row][$num])); break; case CSV_OUTPUT: //csv $value = weblink_extract($value); $out = "\"" . csv_clean($value) . "\"" . $_SESSION["glpicsv_delimiter"]; break; default: //TODO supprimer valign pour mettre class mais conflit avec $extraparam $out = "<td {$extraparam} valign='top'>"; /* if (!preg_match('/<hr>/',$value)) { $values = preg_split("/<br>/i",$value); $line_delimiter = '<br>'; } else { $values = preg_split("/<hr>/i",$value); $line_delimiter = '<hr>'; } $limitto = 20; if (count($values) > $limitto) { for ( $i=0 ; $i<$limitto ; $i++) { $out .= $values[$i].$line_delimiter; } $rand=mt_rand(); $out .= "... "; $out .= showToolTip($value,array('display' => false, 'autoclose' => false)); } else {*/ $out .= $value; // } $out .= "</td>\n"; } $num++; return $out; }