MySQL转CSV文件

MySQL转CSV文件

 
#! /usr/bin/php
 
<?php
$filename = "outdata.csv";
$db = mysql_connect(DBHOST, DBUSER, DBPASS);
mysql_select_db(DBNAME);
 
//$sql = "set names utf8";
//$query = mysql_query($sql, $db);
 
$sql = "select * from t_table";
$query = mysql_query($sql, $db);
 
if (false === $query) {
    echo "Can't query";
    exit(1);
}
 
$fp = fopen($filename, 'a');
if (false === $fp) {
    echo "Can't open./n";
    exit(1);
}
 
while ($entry = mysql_fetch_array($query, MYSQL_NUM)) {
    array_walk($entry, 'userData');
    if (false === fwrite($fp, join(",", $entry)."/n")) {
        echo "Can't write./n";
        exit(1);
    }
}
 
if (fclose($fp)) {
    echo "Complete!/n";
}
 
// -------------------------------------------------------- function -------------------------------------------------------- //
 
function userData(&$value) {
    $value = preg_replace("//"/", '""', $value);
    if (strpos($value, "/"") || strpos($value, ",")) {
        $value = "/"".$value."/"";
    }
}
?>