如何使用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 file

fclose($handle);