如何在Json数组中获取Json对象并将其存储在MySql中[php]

Question

This question already has an answer here:

• How do I extract data from JSON with PHP? 5 answers

I want get Json objects from the json array and store each values in mysql using php.

$arr = "[{"fruit":"Apples","isSelected":false,"number":0},{"fruit":"Oranges","isSelected":false,"number":0},{"fruit":"Potatoes","isSelected":false,"number":0},{"fruit":"Tomatoes","isSelected":false,"number":0},{"fruit":"Grapes","isSelected":false,"number":0},{"fruit":"Dhanana","isSelected":false,"number":0}]";

</div>

Answer 1

try this code

Using json_decode

<?php
$arr = '[{"fruit":"Apples","isSelected":false,"number":0},{"fruit":"Oranges","isSelected":false,"number":0},{"fruit":"Potatoes","isSelected":false,"number":0},{"fruit":"Tomatoes","isSelected":false,"number":0},{"fruit":"Grapes","isSelected":false,"number":0},{"fruit":"Dhanana","isSelected":false,"number":0}]';
$data = json_decode($arr);
echo "<pre>";
print_r($data);
foreach($data as $k=>$v){
    echo $v->fruit." ".$v->isSelected." ".$v->number."<br>"; //store in db here using value
    print_r($v);
}
?>