Php convert string into JSON or an Array

Question

Can anyone please help me for converting the string into an Array or JSON as well? Please take look on the text sample below;

{
    "account_id": "dfdfdf",
    "email": "[email protected]",
    "id": "dfdfdf",
    "name": "Gmail Team",
    "object": "contact",
    "phone_numbers": []
},
{
    "account_id": "dfdf",
    "email": "[email protected]",
    "id": "dfdf",
    "name": "Ab",
    "object": "contact",
    "phone_numbers": []
},
{
    "account_id": "dfdf",
    "email": "[email protected]",
    "id": "dfdfdf",
    "name": "xyz",
    "object": "contact",
    "phone_numbers": []
},

I have tried

preg_match_all("/\{([^\)]*)\},/", $stream[0], $aMatches);

But it doesn't return anything. I also have tried json_decode, json_encode but could not find any success on it.

Thanks

@fusion3k Already tried. This is string and it results in null — Saeed Afzal
– Saeed Afzal, Commented Mar 8, 2016 at 15:47
Please provide a link to real string. With your example, below provided answer is fine. — fusion3k
– fusion3k, Commented Mar 8, 2016 at 15:49
thanks for the support @fusion3k . I agree, the string given is not the same as what he is seeing if the problem persists. — CodeGodie
– CodeGodie, Commented Mar 8, 2016 at 15:50

CodeGodie · Accepted Answer · 2016-03-08 15:21:25Z

12

The goal is to turn it into appropriate JSON format so that you can use json_decode. Ill break it down in steps:

remove all \n characters:

$string = str_replace('\n', '', $string);

remove last comma
```
$string = rtrim($string, ',');
```
add brackets
```
$string = "[" . trim($string) . "]";
```
turn it into PHP array:
```
$json = json_decode($string, true);
```

Result:

$string = ''; //your string
$string = str_replace('\n', '', $string);
$string = rtrim($string, ',');
$string = "[" . trim($string) . "]";
$json = json_decode($string, true);
var_dump($json);

Output:

array (size=3)
  0 => 
    array (size=6)
      'account_id' => string '43z95ujithllc32fn02u8ynef' (length=25)
      'email' => string '[email protected]' (length=23)
      'id' => string '955xl0q3h9qe0sc11so8cojo2' (length=25)
      'name' => string 'Gmail Team' (length=10)
      'object' => string 'contact' (length=7)
      'phone_numbers' => 
        array (size=0)
          empty
  1 => 
    array (size=6)
      'account_id' => string '43z95ujithllc32fn02u8ynef' (length=25)
      'email' => string '[email protected]' (length=21)
      'id' => string '3u4e6i9ka3e7ad4km90nip73u' (length=25)
      'name' => string 'Test Account 1' (length=14)
      'object' => string 'contact' (length=7)
      'phone_numbers' => 
        array (size=0)
          empty
  2 => 
    array (size=6)
      'account_id' => string '43z95ujithllc32fn02u8ynef' (length=25)
      'email' => string '[email protected]' (length=20)
      'id' => string 'bt3lphmp0g14y82zelpcf0w0r' (length=25)
      'name' => string 'Test Account' (length=12)
      'object' => string 'contact' (length=7)
      'phone_numbers' => 
        array (size=0)
          empty

answered Mar 8, 2016 at 15:21

CodeGodie

12.2k6 gold badges40 silver badges66 bronze badges

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

5 Comments

CodeGodie Over a year ago

then you are not providing all the string in your original post.

CodeGodie Over a year ago

how is your string formed? Where are you getting the string from?

Saeed Afzal Over a year ago

It is string response from a third party API Nylas. I am posting exactly what I am having. I want array where data between { and }, can be get as internal array

CodeGodie Over a year ago

I see that you updated your string but that is very different than your original string. Before you had \n characters... what happened to them?

CodeGodie Over a year ago

in that case, do the same as my answer, but dont follow step 1.

Collectives™ on Stack Overflow

Php convert string into JSON or an Array

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