formatting json data from a string in php

Question

I am trying to format the data passed by the api in to key value paris for use with javascript the data right now is one big key and not in key value paris how can i get the data as key value paris and properly formated ?

<?php

     header('Content-Type: application/json; charset=utf-8');
    $url = file_get_contents('https://www.jiosaavn.com/api.php?_format=json&query=mere%20angne%20mein&__call=autocomplete.get');
    $data = explode('[', $url);
    $format = json_encode($data[1], true);
    print_r($format);

    ?>

There is no question here

John Conde
– John Conde

2020-05-24 20:08:55 +00:00
Commented May 24, 2020 at 20:08 — John Conde
– John Conde, Commented May 24, 2020 at 20:08
updated the text

DrunkenMonkey
– DrunkenMonkey

2020-05-24 20:14:49 +00:00
Commented May 24, 2020 at 20:14 — DrunkenMonkey
– DrunkenMonkey, Commented May 24, 2020 at 20:14

MaartenDev · Accepted Answer · 2020-05-24 20:23:48Z

1

The response contains some HTML which has to be removed to be able to parse the json. This can be achieved with strip_tags. After removing the html json_decode can be used to get the values:

<?php
$content = file_get_contents('https://www.jiosaavn.com/api.php?_format=json&query=mere%20angne%20mein&__call=autocomplete.get');

$content = strip_tags($content);
$response = json_decode($content);

print_r($response);

foreach($response->albums->data as $album){
  echo $album->title;
}

result:

Mere Angne MeinLaawarisMere Angne MeinMere Angne Mein (From "Mere Angne Mein")Mere Angane Mein

edited May 24, 2020 at 20:23

answered May 24, 2020 at 20:17

MaartenDev

5,8305 gold badges23 silver badges36 bronze badges

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

Comments

Frederick Behrends · Accepted Answer · 2020-05-24 20:17:43Z

0

$url = 'https://www.jiosaavn.com/api.php_format=json&query=mere%20angne%20mein&__call=autocomplete.get';
    $data = file_get_contents($url);
    $format = json_decode($data);
    print_r($format);

answered May 24, 2020 at 20:17

Frederick Behrends

3,09526 silver badges47 bronze badges

1 Comment

M A Salman Over a year ago

Please add the explanation why this answer is correct

Collectives™ on Stack Overflow

formatting json data from a string in php

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related