Extracting Json Data from PHP log file and Adding in a new column

Question

I am newbie to php, Here is my json file ,

{"hint_data":{"locations":["AXQDAP____8AAAAABwAAABEAAAAYAAAAIwIAAERwAgAAAAAADgyCAef7TAMCAAEB","bOsDAP____8AAAAAAwAAAAcAAADFAQAAFAAAAEJwAgAAAAAANQeCAdzdTAMFAAEB"],"checksum":326195011},"route_name":["",""],"via_indices":[0,15],"via_points":[[25.299982,55.376873],[25.29874,55.369179]],"found_alternative":false,"route_summary":{"end_point":"","start_point":"","total_time":101,"total_distance":871},"route_geometry":"{_ego@m}|rhBpBaBvHuC`EuArEUtEtAlDvEnD`MlDvMli@hsEfFzn@QlTgNhwCs@fKwBjF","status_message":"Found route between points","status":0}

I need to extract the total_time only from the json and print the extracted total_time to a new column in a csv file,could someone please help me in that?

You need these: $result['total_time'] = $result['route_summary']['total_time']; $json = json_encode($result); — Murad Hasan
– Murad Hasan, Commented May 26, 2016 at 7:05

Murad Hasan · Accepted Answer · 2016-05-26 07:07:54Z

1

You need these i think.

$json = '{"hint_data":{"locations":["AXQDAP____8AAAAABwAAABEAAAAYAAAAIwIAAERwAgAAAAAADgyCAef7TAMCAAEB","bOsDAP____8AAAAAAwAAAAcAAADFAQAAFAAAAEJwAgAAAAAANQeCAdzdTAMFAAEB"],"checksum":326195011},"route_name":["",""],"via_indices":[0,15],"via_points":[[25.299982,55.376873],[25.29874,55.369179]],"found_alternative":false,"route_summary":{"end_point":"","start_point":"","total_time":101,"total_distance":871},"route_geometry":"{_ego@m}|rhBpBaBvHuC`EuArEUtEtAlDvEnD`MlDvMli@hsEfFzn@QlTgNhwCs@fKwBjF","status_message":"Found route between points","status":0}';
$assoc = true;
$result = json_decode ($json, $assoc);
$result['total_time'] = $result['route_summary']['total_time'];

$json = json_encode($result);

Now its time to put these $json back to a file using file_put_contents.

file_put_contents('file.csv', $json );

answered May 26, 2016 at 7:07

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

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

Comments

Elzo Valugi · Accepted Answer · 2016-05-26 07:02:01Z

0

Save your json string into a json file, load it and you can use json_decode function to load it in PHP as an array.

$string = file_get_contents('file.json');
$json = json_decode($string, true);
$totalTime = $json['route_summary']['total_time']; // 101

How to export the results to CSV file afterwards you have examples here on SO.

answered May 26, 2016 at 7:02

Elzo Valugi

28.1k17 gold badges97 silver badges115 bronze badges

1 Comment

Murad Hasan Over a year ago

The Question is not about to get the total_time only, Its about to put, extracted total_time to a new column in a csv file.

Collectives™ on Stack Overflow

Extracting Json Data from PHP log file and Adding in a new column

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related