PHP Json array decode in php and inserting mysql

Question

"SCI-6":{"quantity":11,"id":"SCI-6","price":15,"name":"notebooks"},
"SCI-7":{"quantity":1,"id":"SCI-7","price":10,"name":"posters"},
"SCI-8":{"quantity":2,"id":"SCI-8","price":15,"name":"pen"},
"SCI-9":{"quantity":4,"id":"SCI-9","price":100,"name":"charger"},
"SCI-10":{"quantity":1,"id":"SCI-10","price":10.25,"name":"News Paper"}

please help me to decode as variables and insert the values to Mysql using php

use php json_decode: http://php.net/manual/en/function.json-decode.php — SIDU, Jan 21 '16 at 05:53

AnkiiG · Answer 1 · 2016-01-21T06:06:42.943

Use json_decode — Decodes a JSON string

Try as below :

<?php 
$json = '{"SCI-6":{"quantity":11,"id":"SCI-6","price":15,"name":"notebooks"},"SCI-7":{"quantity":1,"id":"SCI-7","price":10,"name":"posters"},"SCI-8":{"quantity":2,"id":"SCI-8","price":15,"name":"pen"},"SCI-9":{"quantity":4,"id":"SCI-9","price":100,"name":"charger"},"SCI-10":{"quantity":1,"id":"SCI-10","price":10.25,"name":"News Paper"}}';
$result_data = json_decode($json);
foreach($result_data as $value)
{
    $stmt = mysqli_prepare("INSERT INTO tablename (quantity, id, price, name) (?, ?, ?, ?)");
    mysqli_stmt_bind_param($stmt, "dsss", $value->quantity, $value->id, $value->price, $value->name);
    mysqli_stmt_execute($stmt);
}
?>

Output you will get is :

stdClass Object
(
    [SCI-6] => stdClass Object
        (
            [quantity] => 11
            [id] => SCI-6
            [price] => 15
            [name] => notebooks
        )

    [SCI-7] => stdClass Object
        (
            [quantity] => 1
            [id] => SCI-7
            [price] => 10
            [name] => posters
        )

    [SCI-8] => stdClass Object
        (
            [quantity] => 2
            [id] => SCI-8
            [price] => 15
            [name] => pen
        )

    [SCI-9] => stdClass Object
        (
            [quantity] => 4
            [id] => SCI-9
            [price] => 100
            [name] => charger
        )

    [SCI-10] => stdClass Object
        (
            [quantity] => 1
            [id] => SCI-10
            [price] => 10.25
            [name] => News Paper
        )

)

i'm just wondering how can he access an object inside.. `$obj->SCI-6->quantity` will make it asystax error? — roullie, Jan 21 '16 at 06:03
@roullie `foreach` loop will solve the problem. Please look at my answer — AnkiiG, Jan 21 '16 at 06:29

score 2 · Accepted Answer · answered Jan 21 '16 at 06:05

$data = '{"SCI-6":{"quantity":11,"id":"SCI-6","price":15,"name":"notebooks"},"SCI-7":{"quantity":1,"id":"SCI-7","price":10,"name":"posters"},"SCI-8":{"quantity":2,"id":"SCI-8","price":15,"name":"pen"},"SCI-9":{"quantity":4,"id":"SCI-9","price":100,"name":"charger"},"SCI-10":{"quantity":1,"id":"SCI-10","price":10.25,"name":"News Paper"}}';

$json_data=json_decode($data);
foreach($json_data as $json_value)
{

    mysql_query("INSERT INTO yourtable (quantity, id, price, name) values ('".$json_value->quantity."','".$json_value->id."','".$json_value->price."','".$json_value->name."')");

}

score 0 · Answer 3 · answered Jan 21 '16 at 05:55

Assuming your json string is

$dat = '{"SCI-6":{"quantity":11,"id":"SCI-6","price":15,"name":"notebooks"},"SCI-7":{"quantity":1,"id":"SCI-7","price":10,"name":"posters"},"SCI-8":{"quantity":2,"id":"SCI-8","price":15,"name":"pen"},"SCI-9":{"quantity":4,"id":"SCI-9","price":100,"name":"charger"},"SCI-10":{"quantity":1,"id":"SCI-10","price":10.25,"name":"News Paper"}}';

With the opening and closing brackets at the end (otherwise it's not valid json) then we can decode it like the following:

$jsondata = json_decode($dat, true);
foreach($jsondata as $vals)
{
    $stmt = mysqli_prepare("INSERT INTO yourtable (quantity, id, price, name) (?, ?, ?, ?)");
    mysqli_stmt_bind_param($stmt, "dsss", $vals['quantity'], $vals['id'], $vals['price'], $vals['name']);
    mysqli_stmt_execute($stmt);
}

score 0 · Answer 4 · answered Jan 21 '16 at 06:03

You can use json_decode function for decoding json:

$string = '{"SCI-6":{"quantity":11,"id":"SCI-6","price":15,"name":"notebooks"},"SCI-7":{"quantity":1,"id":"SCI-7","price":10,"name":"posters"},"SCI-8":{"quantity":2,"id":"SCI-8","price":15,"name":"pen"},"SCI-9":{"quantity":4,"id":"SCI-9","price":100,"name":"charger"},"SCI-10":{"quantity":1,"id":"SCI-10","price":10.25,"name":"News Paper"}}';

echo "<pre>";    
print_r(json_decode($string));

Result:

stdClass Object
(
    [SCI-6] => stdClass Object
        (
            [quantity] => 11
            [id] => SCI-6
            [price] => 15
            [name] => notebooks
        )

    [SCI-7] => stdClass Object
        (
            [quantity] => 1
            [id] => SCI-7
            [price] => 10
            [name] => posters
        )

    [SCI-8] => stdClass Object
        (
            [quantity] => 2
            [id] => SCI-8
            [price] => 15
            [name] => pen
        )

    [SCI-9] => stdClass Object
        (
            [quantity] => 4
            [id] => SCI-9
            [price] => 100
            [name] => charger
        )

    [SCI-10] => stdClass Object
        (
            [quantity] => 1
            [id] => SCI-10
            [price] => 10.25
            [name] => News Paper
        )

)

Side Note:

Your json consists on multidimensional array so you need to use json inside the {}.

@AbhilashEnair: u r welcome, dont forget to chose the best answer as accepted.. — devpro, Jan 21 '16 at 07:45

score -1 · Answer 5 · answered Jan 21 '16 at 05:55

-1

You can use json_decode() to decode the json data.

You can also try unserialize() if it doesn't works.

answered Jan 21 '16 at 05:55

Wolfack

2,667
1
26
50

PHP Json array decode in php and inserting mysql

5 Answers5