doucang8303 2017-06-19 08:08
浏览 61

在Php脚本中迭代foreach

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 ;

}
  • 写回答

1条回答 默认 最新

  • dthswrp84966 2017-06-19 08:33
    关注
    //Parsing data
    $Id = htmlentities($_POST["Id"]);
    $tables  = array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday") ;
    $returnArray = [];
    $intCount = 0;
    foreach ($tables as $value) {       
        //Call CheckData function
        $result = checkData($value ,$Id , $conn);
        if (!empty($result)) {
            $returnArray[$intCount]["status"] = true  ;
            $returnArray[$intCount]["message"] = $result ;
            $returnArray[$intCount]["Day of Week"] = $value  ;     
            echo json_encode($returnArray) ;       
        } else {
           $returnArray[$intCount]["status"] = false ;
           $returnArray[$intCount]["message"] = "No data found for ' $value'";
           $returnArray[$intCount]["Day of Week"] = $value  ;  
           echo json_encode($returnArray) ;
        }
        $intCount++;
    }
    return ;
    
    评论

报告相同问题?

悬赏问题

  • ¥15 msix packaging tool打包问题
  • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
  • ¥30 深度学习,前后端连接
  • ¥15 孟德尔随机化结果不一致
  • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线