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."\"";
    }
}
?>

Css定义背景：【上一篇】
NickLee.Framework.V1.9.4.3：【下一篇】