Php file_put_contents json into csv single cell

Question

file_put_contents(
            $log,
            $this->info['http_code'].", ".
            $this->info['url'].", ".
            '{"12345":"98765","56789":"54321"}'.", ".
            date("Y-m-d H:m:i") .", ".
            PHP_EOL,
            FILE_APPEND
        );

I have a log required to save json into one single csv cell

Because comma (,) it jump to next column's cell.

Anyone know how to store this json data in single cell?

Sahil Gulati · Accepted Answer · 2017-04-21 03:04:02Z

2

Try this, Here instead of using file_put_contents you should use fputcsv add also there is no need for PHP_EOL, in this current string next time you call fputcsv then it will automatically comes into your next line.

<?php
$resource=fopen($log, "w+");
fputcsv($resource, 
   array(
      $this->info['http_code'],
      $this->info['url'],
      '{"12345":"98765","56789":"54321"}',
      date("Y-m-d H:m:i")
    )
);

answered Apr 21, 2017 at 3:04

Sahil Gulati

15.2k4 gold badges28 silver badges43 bronze badges

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

5 Comments

Benjamin W Over a year ago

sry i actually only want json part in single column

Sahil Gulati Over a year ago

@BenjaminW Do you want json to be inserted like cells?

Benjamin W Over a year ago

all json in single cell,

Sahil Gulati Over a year ago

Try this, it will put you json in one cell.

Sahil Gulati Over a year ago

just make sure you are using .csv extension for your $log and also put only array of strings as a second argument in fputcsv

Collectives™ on Stack Overflow

Php file_put_contents json into csv single cell

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related