foreach 循环循环遍历要显示在单独表中的日期数组

Question

我正在尝试构建我的 foreach 循环来循环遍历时间戳数组中的所有日期，以便我可以在每个日期的 5 个单独的表中显示结果这是我从数据库获取信息的功能$users_site = "London";$timeStampFrom = ( [0] => 1596655740 [1] => 1596745740 [2] => 1596828540 [3] => 1597087740 [4] => 1597177800 );$timeStampTo = ( [0] => 1596659340 [1] => 1596749340 [2] => 1596832140 [3] => 1597095000 [4] => 1597181400 );function show_available_equipment($users_site, $timeStampFrom, $timeStampTo){// defines db from instialize page as a global variableforeach ($timeStampFrom as $timeStampStart=>$timeStampTo) {global $db;//SQL statement to query the database for available gear$sql= "SELECT av_inventory.ID AS equipID, av_equipment_type.equipment, "        . "av_inventory.product, av_inventory.serial, av_inventory.current_location, "        . "av_inventory.site, av_inventory.status, av_products.product, av_buildings.building FROM av_inventory JOIN "        . "av_equipment_type ON av_inventory.equipment =av_equipment_type.ID "        . "JOIN av_products ON av_inventory.product = av_products.ID JOIN "        . "av_buildings ON av_inventory.current_location = av_buildings.ID WHERE "        . "av_inventory.site =?  AND av_inventory.ID NOT IN (SELECT av_bookings.av_inventory_id FROM "        . "av_bookings WHERE date_time_from <= ? and date_time_to >= ?)  GROUP BY av_inventory.ID;";        // prepares our sql statement        $stmt = mysqli_stmt_init($db);        //if there is a SQL error exit        if (!mysqli_stmt_prepare($stmt, $sql)) {        header("Location: book_gear.php?error=sqlerror123");         exit();         }}}}这里我尝试根据给定的 5 个日期显示信息。每天一张桌子。目前我刚刚获得第一天的信息，这让我认为我的函数循环不正确。

Answer 1

在获取SQL数据的函数中，第一次循环后返回结果：

function show_available_equipment($users_site, $timeStampFrom, $timeStampTo){

      // defines db from instialize page as a global variable

      foreach ($timeStampFrom as $timeStampStart=>$timeStampTo) { // <----- Only runs once

            ........................

            //if there is a SQL error exit

            if (!mysqli_stmt_prepare($stmt, $sql)) {

                header("Location: book_gear.php?error=sqlerror123");

                exit();

             }

            // otherwise go ahead

            else {

                

                ...........................

                $result = mysqli_stmt_get_result($stmt);

                return $result; //  <---------- Returns after first loop

            }

      }

}

从数据库检索每个结果后，您需要将其添加到某种$all_results变量中。循环完成后，返回$all_results。