如何使用php基于多条记录创建多个文件假设我有100条记录为每10条记录创建1个文件

Question

此代码不起作用我想为每 10 条记录打印文件。

if($con=mysqli_connect("localhost","root","","fileDemo")){

    //echo "DB CONEECTED";

    $sql = "select id from news order by id desc";

    $data_query=mysqli_query($con,$sql);

    while($data=mysqli_fetch_assoc($data_query)){

        $id=$data['id'];

        if(!file_exists("demo_file"."-".trim($id).".txt")){

            $file_c=fopen("demo_file"."-".trim($id).".txt", 'a'); 

            fwrite($file_c,$id);

            fclose($file_c);

        } 

        // $stringData.="Name: ".$data['name']." Age:".$data['age']."\n";

    }

}else{

    echo "CONNECTION FAILD";

}

Answer 1

//open first file$handle = fopen('filename.txt', 'w');foreach ($records as $i => $record) {   //if record is 10th then close prev file and open new   if ($i % 10 == 0) {       fclose($handle);       $handle = fopen("filename_$i.txt", 'w');   }   //your logic here. Write to file I suppose   fwrite($handle, $record);}//close filefclose($handle);