I am getting {"1":["77","77"],"2":["33","55","66"]}
as JSON
Which I am decoding in PHP as $organize = json_decode($json);
Now to store value in database I am doing something like
foreach($organize->{1} as $pos => $div){
$pos1 = 1;
$sql = "INSERT INTO process VALUES (DEFAULT,'".mysqli_real_escape_string($conn,$pos1)."','".mysqli_real_escape_string($conn,$div)."')";
if ($conn->query($sql) === TRUE) {
}
}
foreach($organize->{2} as $pos => $div){
$pos1 = 2;
$sql = "INSERT INTO process VALUES (DEFAULT,'".mysqli_real_escape_string($conn,$pos1)."','".mysqli_real_escape_string($conn,$div)."')";
if ($conn->query($sql) === TRUE) {
}
}
Where $organize->(1) and $organize->(2)
are specifically entered from the json output above
Is there way to retrieve the keys "1" & "2" or any number so I put a forloop outsite my main forloop and it automatically stores for every data.
Something like
foreach(ACCESS KEYS HERE)
foreach($organize->{$KEY NUMBER HERE} as $pos => $div){
$pos1 = $KEY NUMBER HERE;
$sql = "INSERT INTO process VALUES (DEFAULT,'".mysqli_real_escape_string($conn,$pos1)."','".mysqli_real_escape_string($conn,$div)."')";
if ($conn->query($sql) === TRUE) {
}
}
}
Is there a way to make it dynamic like that.
Thank You.