I am new to PHP Script , I am trying to iterate through foreach loop in PHP I am getting only first value result loop is not going to next element in array.
// Parsing data
$Id = htmlentities($_POST["Id"]);
$tables = array("Monday" , "Tuesday" , "Wednesday" , "Thursday" , "Friday" , "Saturday" , "Sunday") ;
foreach ($tables as $value) {
//Call CheckData function
$result = checkData($value ,$Id , $conn);
if(!empty($result)) {
$returnArray["status"] = true ;
$returnArray["message"] = $result ;
$returnArray["Day of Week"] = $value ;
echo json_encode($returnArray) ;
} else {
$returnArray["status"] = false ;
$returnArray["message"] = "No data found for ' $value'";
$returnArray["Day of Week"] = $value ;
echo json_encode($returnArray) ;
}
}
return ;
I get result for Monday only not for Tuesday and so on.
//Code for CheckData
function checkData($value ,$Id , $conn) {
$returnValue[] = array() ;
//SQL query
$sql = "SELECT * FROM $value WHERE Id = '$Id'" ;
//Store the result in $result
$result = mysqli_query($conn , $sql);
while ($row = mysqli_fetch_array($result)) {
$returnValue[] = array_map(utf8_encode ,$row);
}
return $returnValue ;
}