PHP Save output to csv file

Question

I have a long list echoed on my screen looks like this:

UVVI0287;PMS340C
UVVI0288;PMS242C

etc

Here's the code:

foreach(glob('./xls/*.*') as $filename){

     $final = preg_replace('%^([^ ]+?)( )(.*)$%', '\1;\3', $bodytag);

     echo $final;

     echo '<br>';

 }

Is there a way of saving this output to csv using php?

Community · Accepted Answer · 2023-11-21 15:10:29Z

1

Do something like this...

$fp = fopen('file.csv', 'w');

foreach(glob('./xls/*.*') as $filename){
     $final = preg_replace('%^([^ ]+?)( )(.*)$%', '\1;\3', $bodytag);
     $temp = explode(';',$final);
     fputcsv($fp, $temp);
 }

fclose($fp);

Look into fputcsv.

edited Nov 21, 2023 at 15:10

CommunityBot

11 silver badge

answered Apr 4, 2014 at 11:21

Ashwini Agarwal

4,8582 gold badges44 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dkasipovic · Accepted Answer · 2014-04-04 11:18:31Z

0

Something like this?

$final = "";
foreach(glob('./xls/*.*') as $filename){
  $final .= preg_replace('%^([^ ]+?)( )(.*)$%', '\1;\3', $bodytag)."\r\n";
}
file_put_contents("final.csv",$final);

answered Apr 4, 2014 at 11:18

dkasipovic

6,1301 gold badge23 silver badges27 bronze badges

Comments

Rimble · Accepted Answer · 2014-04-04 11:18:38Z

0

file_put_contents('output.csv', $final);

I'm not really sure as to what exactly you are trying to output. But I might be able to update the answer based on your reply.

answered Apr 4, 2014 at 11:18

Rimble

89310 silver badges22 bronze badges

Collectives™ on Stack Overflow

PHP Save output to csv file

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related