What is the Best Way to Extract Data from This Array? I Need to display the First Object of My Array, Specifically the id field in the 3rd Row.
<?php
$con=mysqli_connect("localhost","root","","arrayy");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT `survey_answers` FROM `user_survey_start`";
if ($result=mysqli_query($con,$sql)){
while ($row = mysqli_fetch_row($result)){
$json = $row[0];
$jason_array = json_decode($json,true);
foreach ($jason_array as $data){
$id[] = $data['id'];
//$answer[] = $data['answer'];
// $type[] = $data['type'];
// code here for inserting/updating values in database column
}
echo implode(',',$id)."</br>";
// echo implode(',',$answer);
// echo implode (',',$type);
}
}
mysqli_close($con);
?>
Please also refer to this Image for the Output https://i.stack.imgur.com/GRrl0.jpg