将MYSQL查询写入CSV文件可以'；t写入查询 - Write MYSQL query to CSV file can't write query

Write MYSQL query to CSV file can't write query

本文关键字：查询文件 MYSQL CSV | 更新日期: 2024-04-12

所有这些都驻留在ubuntu LAMP服务器上。我正在尝试将sql查询的结果放入csv文件中。php可以查询数据库并创建csv文件。但我无法将结果写入csv文件。

 <?php
//connect to db and query
$db_conn=mysqli_connect(xxxx, xxxx, xxxx, xxxx);
if (mysqli_connect_errno($db_conn))
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
$result = mysqli_query($db_conn,'SELECT time, bid, ask, volume FROM MtGox LIMIT 50');
$fp = fopen('/var/www/BTCData.csv',"w")or die("can't open file");
//store results as array and put into csv file
$fp = fopen('/var/www/TempFile.csv',"w")or die("can't open file");
$row = mysqli_fetch_assoc($result)or die('failure!');
foreach ($row as $fields) {
fputcsv($fp, $fields);
}
fclose($fp);
echo 'success!';
?>

$db_conn=mysqli_connect(xxxx, xxxx, xxxx, xxxx);
if (mysqli_connect_errno($db_conn)) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($db_conn,'SELECT time, bid, ask, volume FROM MtGox LIMIT 50');   
$data = '';
while ($row = mysql_fetch_assoc($result)) {
    $data .= $row['time'].';';
    $data .= $row['bid'].';';
    $data .= $row['ask'].';';
    $data .= $row['volume'].';';
}
file_put_contents ('/var/www/BTCData.csv', $data);