Convert string to array php

Question

I have a string like this:

{ArrivalTime:300, ProductID:198, ArrivalDate:21/07/2017}, {ArrivalTime:582, ProductID:397, ArrivalDate:22/07/2017}

I used json_decode() but it's not working;

I need return array like this:

Array
(
    [0] => Array
        (
            [ArrivalTime] => 300
            [ProductID] => 198
            [ArrivalDate] => 21/07/2017
        )

    [1] => Array
        (
            [ArrivalTime] => 582
            [ProductID] => 397
            [ArrivalDate] => 21/07/2017
        )

)

Can you help me to do that? thanks.

It's not the correct JSON format. That's why json_decode() function is not working. — Bhavin
– Bhavin, Commented Jul 21, 2017 at 6:42
json_decode() doesn't work because your data is not valid json. Maybe you can solve the issue at the source of your data. — Red Bottle
– Red Bottle, Commented Jul 21, 2017 at 6:44
Possible duplicate of PHP reading invalid json with json_decode(); — Adonis
– Adonis, Commented Jul 21, 2017 at 7:45

Gangani Roshan · Accepted Answer · 2017-07-21 06:55:30Z

1

You can try

str_split — Convert a string to an array

Syntax:

array str_split ( string $string [, int $split_length = 1 ] )

Example:

<?php

$str = "Hello Friend";

$arr1 = str_split($str);

print_r($arr1);

?>

Edit:

Output:

Array
(
    [0] => H
    [1] => e
    [2] => l
    [3] => l
    [4] => o
    [5] =>
    [6] => F
    [7] => r
    [8] => i
    [9] => e
    [10] => n
    [11] => d
)

Replace string name and array name your own. Thank You.

edited Jul 21, 2017 at 6:55

answered Jul 21, 2017 at 6:47

Gangani Roshan

5831 gold badge8 silver badges25 bronze badges

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

3 Comments

MVG1984 Over a year ago

did you test your code? It will not work as he wants. He have to check why his json string not formatted correctly.

Gangani Roshan Over a year ago

Yes dude You can try it in simple way. M answer only how to convert string to array.

Nawin Over a year ago

Actually, he is not asking this! @GanganiRoshan

Liu.handy · Accepted Answer · 2017-07-21 07:07:16Z

1

Run follow code to analyse it:

function strAnalyse($str){
        preg_match_all('/(?<={)[^{}]*(?=})/',$str,$match);
        $result = array();
        foreach($match[0] as $item){
            $one =array();
            $tmp = explode(',',$item);
            foreach($tmp as $kv){
                $a = explode(':',$kv);
                $one[trim($a[0])] = trim($a[1]);
            }
            array_push($result,$one);
        }
        echo '<pre>';
        print_r($result);
}

result:

Array
(
    [0] => Array
        (
            [ArrivalTime] => 300
            [ProductID] => 198
            [ArrivalDate] => 21/07/2017
        )

    [1] => Array
        (
            [ArrivalTime] => 582
            [ProductID] => 397
            [ArrivalDate] => 22/07/2017
        )

)

answered Jul 21, 2017 at 7:07

Liu.handy

593 bronze badges

2 Comments

Nawin Over a year ago

1 for the Answer and we don't know that json is correct anyway your code is fine

Liu.handy Over a year ago

That json is not valid,because it lack of key's and value's quote.

Arun pandian M · Accepted Answer · 2017-07-21 06:55:17Z

0

the json is invalid even if we add "[]" (array brackets)

value should be in the any one of the format :

string, number,object,array,true,false,null

in your case there is a date in the value field change it to string by enclosing ""(double quotes)

the key in your json is a string for json key the string should be enclosed by ""(double quotes)

" chars "

offical documentation : http://www.json.org/

the correct json format for your json is

   [{
    "ArrivalTime": 300,
    "ProductID": 198,
    "ArrivalDate": "21 / 07 / 2017"
}, {
    "ArrivalTime": 582,
    "ProductID": 397,
    "ArrivalDate": "22 / 07 / 2017"
}]

answered Jul 21, 2017 at 6:55

Arun pandian M

89210 silver badges17 bronze badges

Comments

MVG1984 · Accepted Answer · 2017-07-21 07:00:48Z

0

You need to wrap your "json" string with [] and quotes, of course (or check, why it not wrapped earlier):

[{"ArrivalTime": 300,"ProductID": 198,"ArrivalDate": "21 / 07 / 2017"}, {"ArrivalTime": 582,"ProductID": 397,"ArrivalDate": "22 / 07 / 2017"}]

Then it will be correct json format and json_decode() create correct array.

edited Jul 21, 2017 at 7:00

answered Jul 21, 2017 at 6:45

MVG1984

6454 silver badges15 bronze badges

3 Comments

Nawin Over a year ago

Is this valid json?

MVG1984 Over a year ago

If with [ and ] - yes. Then it will be array.

MVG1984 Over a year ago

Your right, in my example a forgot quotes, and i've checked string with them :)

Pang · Accepted Answer · 2017-07-22 04:40:23Z

0

That is not a valid json format. But if you have such kinda string try this code:

$string = "{ArrivalTime:300, ProductID:198, ArrivalDate:21/07/2017}, {ArrivalTime:582, ProductID:397, ArrivalDate:22/07/2017}";


$key = $value = $resultArray= array();

$arrayJson = explode('}, ', $string);



foreach ($arrayJson as $arrayJsonRep) {

    $repJson = str_replace('{', '', $arrayJsonRep);
    $repJson = str_replace('}', '', $repJson);
    $repJsonExp = explode(', ', $repJson);

    foreach ($repJsonExp as $x) {

        $repJsonExpfirst=  explode(':', $x); 
        array_push($key, $repJsonExpfirst[0]);
        array_push($value, $repJsonExpfirst[1]);
    }

    $finalArray = array_combine($key, $value);
    array_push($resultArray, $finalArray);
}



print_r($resultArray);

edited Jul 22, 2017 at 4:40

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Jul 21, 2017 at 9:41

Shivrag

113 bronze badges

Collectives™ on Stack Overflow

Convert string to array php

5 Answers 5

3 Comments

2 Comments

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

2 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related