PHP: How to parse JSON data

Question

i am trying to send JSON data to PHP server, but i can understand how can i parse my JSON in PHP and insert values in Mysql database.

Here is how looks my JSON data

 {"reps_list":{"selected_subcategory_id":[0,1,2]}}

Here is my PHP code:

$reps_list = $_POST['reps_list'];
$reps_list= json_decode($reps_list,TRUE);

 for($i = 0; $i <= count($array['reps_list']['selected_subcategory_id']); $i++){
mysqli_query($conn, "INSERT INTO reps VALUES(NULL, '".$array['reps_list']['selected_subcategory_id'][i]."', 1, 1 )");

}

Any Suggestions?

If that was valid JSON data then you'd use json_decode, but it's not so you can't. — tadman
– tadman, Commented Mar 20, 2018 at 17:47
You have an SQL injection vulnerability. You should use parameters in your query, instead of interpolating variables into your SQL string. json_decode() does not protect values. — Bill Karwin
– Bill Karwin, Commented Mar 20, 2018 at 17:54

A l w a y s S u n n y · Accepted Answer · 2018-03-20 17:57:37Z

2

Try like this for your valid json, decode the string as array using json_decode with second parameter true to make it array and then treat it as an array before using it on db query.

$array = json_decode('{"reps_list":{"selected_subcategory_id":[0,1,2]}}',1);
echo "Main Array after json string decode \n\n";
print_r($array); 
echo "\n\n";
echo "Access selected_subcategory_id \n\n";
print_r($array['reps_list']['selected_subcategory_id']);

Output:

Main Array after json string decode

Array
(
    [reps_list] => Array
        (
            [selected_subcategory_id] => Array
                (
                    [0] => 0
                    [1] => 1
                    [2] => 2
                )

        )

)

Access selected_subcategory_id

Array
(
    [0] => 0
    [1] => 1
    [2] => 2
)

DEMO: https://eval.in/975261

edited Mar 20, 2018 at 17:57

answered Mar 20, 2018 at 17:52

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

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

Comments

Edward · Accepted Answer · 2018-03-20 18:01:25Z

1

Since you've updated your post with the intention to INSERT it into the database, here is what will work:

$reps_list = $_POST['reps_list'];
$json = json_decode($reps_list,TRUE);

$arr = $json['reps_list']['selected_subcategory_id'];

$insertWorkout = $mysqli->prepare("INSERT INTO reps (column1, column2, column3) VALUES (?, ?, ?)");
$insertWorkout->bind_param("iii", $arr[0], $arr[1], $arr[2]); // iii means they are all integers
$insertWorkout->execute();

answered Mar 20, 2018 at 18:01

Edward

2,3692 gold badges22 silver badges33 bronze badges

1 Comment

Giorgi Asaturyan Over a year ago

thanks for answer, have updated my question, i want to insert data in LOOP, but when i am running the code, throws exception like this Undefined index: i

Mathan Kumar · Accepted Answer · 2018-03-20 18:16:43Z

0

You can use

foreach($reps_list['selected_subcategory_id'] as $key => $value){

mysqli_query($conn, "INSERT INTO reps VALUES(NULL, '".$value."', 1, 1 )");

}

edited Mar 20, 2018 at 18:16

answered Mar 20, 2018 at 18:13

Mathan Kumar

9429 silver badges19 bronze badges

2 Comments

Giorgi Asaturyan Over a year ago

throws this exception

PHP Parse error:  syntax error, unexpected '$key' (T_VARIABLE) in /home/asata/public_html/etsports/data/add_reps.php on line 28

Mathan Kumar Over a year ago

you can try now

Collectives™ on Stack Overflow

PHP: How to parse JSON data

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related