pdo mysql fetchall_将结果从PDO::fetchAll()转换为数组

发现这一点，天知道在哪里，很久以前就完成了这个任务。我希望你觉得这对你有帮助：

/**

* Formats a line (passed as a fields array) as CSV and returns the CSV as a string.

* Adapted from http://us3.php.net/manual/en/function.fputcsv.php#87120

*/

function arrayToCsv( array &$fields, $delimiter = ';', $enclosure = '"', $encloseAll = false, $nullToMysqlNull = false ) {

$delimiter_esc = preg_quote($delimiter, '/');

$enclosure_esc = preg_quote($enclosure, '/');

$output = array();

foreach ( $fields as $field ) {

if ($field === null && $nullToMysqlNull) {

$output[] = 'NULL';

continue;

}

// Enclose fields containing $delimiter, $enclosure or whitespace

if ( $encloseAll || preg_match( "/(?:${delimiter_esc}|${enclosure_esc}|s)/", $field ) ) {

$output[] = $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field) . $enclosure;

}

else {

$output[] = $field;

}

}

return implode( $delimiter, $output );

}