php - 如何将数据库表保存在文本文件中？以及如何指定文本文件的格式？

Question

我正在使用脚本将数据库表保存在 .txt 文件中。该脚本运行完美。表字段如下所示:

8,c.s.e,computer ,9,0
9,m.c.a,b.a. in hindi ,10,0

但我希望它是这样的-:

{ "table_name": [
["8","c.s.e","computer","9","0"],
["9","m.c.a","computer","10","0"],
  ]
}

这是我的脚本:

    $fh = fopen('db.txt', 'w');
    $con = mysql_connect("localhost","root","");
    mysql_select_db("dot", $con);
    $result = mysql_query("SELECT * FROM class_master");   
    while ($row = mysql_fetch_array($result)) {          
    $num = mysql_num_fields($result) ;    
    $last = $num - 1;
    for($i = 0; $i < $num; $i++) {            
        fwrite($fh, $row[$i]);                       
        if ($i != $last) {
            fwrite($fh, ",");
        }
    }                                                                 
    fwrite($fh, "\n");
}
fclose($fh);

Answer 1

在您的代码中实现此行

fwrite($fh, json_encode($row[$i]));