如何将结果集从select写入TXT文件 - how to write result set from select to txt file?

how to write result set from select to txt file?

本文关键字：select 写入 TXT 文件结果 | 更新日期: 2023-09-26

我有以下内容:

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                           //not correct
$count5 = mysql_num_rows($result5);                      //not correct
$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
fwrite($fh, $sql5."'n");
$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
fwrite($fh, $result5."'n");

上面不是我想要的，我想要在我的StatsFile中打印选择的实际结果集请问我怎样才能做到这一点??

不是最有效的解决方案，但应该给你一个如何做这项工作的想法

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                           //not correct
$count5 = mysql_num_rows($result5);                      //not correct
$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
fwrite($fh, $sql5."'n");
while ($row = mysql_fetch_assoc($result5) {
    foreach ($row as $key => $val) {
        fwrite($fh, "$key=>$val ");
    }
    fwrite($fh, "'n");
}
fclose($fh);

您需要获取每一行，然后将该行的值写入文件。