PHP议程与mysql回显表中的记录

Question

下午好，

我遇到了一个问题，我不知道如何解决。

我正在使用 php 和 mysql 制定议程，但我认为我的方法是错误的。现在，如果一天有 1 个约会，它可以正常工作，但如果有 2 个约会，它就会损坏。

我的代码:

        include('../dbc.php');

        $dag = $_GET['dag'];
        $maand = $_GET['maand'];
        $jaar = $_GET['jaar'];

        $datum = $jaar."-".$maand."-".$dag;


        $datavergader = mysqli_fetch_assoc(mysqli_query($dbc,"SELECT * FROM `tbl_reservatie` WHERE op = '".$datum."' AND ruimte = 'vergader';"));

在这里，我每隔一个半小时就制作一张 table ，并在有预约时更改类别以更改颜色。

<table cellspacing="0" style="width:100%">
                  <tr>
                    <th>8:00</th>
                    <td <?php if($datavergader['van'] == "800"){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>8:30</th>
                    <td <?php if(($datavergader['van'] <= "830") && ($datavergader['tot'] >= "830" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>9:00</th>
                    <td <?php if(($datavergader['van'] <= "900") && ($datavergader['tot'] >= "900" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>9:30</th>
                    <td <?php if(($datavergader['van'] <= "930") && ($datavergader['tot'] >= "930" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>10:00</th>
                    <td <?php if(($datavergader['van'] <= "1000") && ($datavergader['tot'] >= "1000" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>10:30</th>
                    <td <?php if(($datavergader['van'] <= "1030") && ($datavergader['tot'] >= "1030" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>11:30</th>
                    <td <?php if(($datavergader['van'] <= "1130") && ($datavergader['tot'] >= "1130" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>12:00</th>
                    <td <?php if(($datavergader['van'] <= "1200") && ($datavergader['tot'] >= "1200" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>12:30</th>
                    <td <?php if(($datavergader['van'] <= "1230") && ($datavergader['tot'] >= "1230" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>13:00</th>
                    <td <?php if(($datavergader['van'] <= "1300") && ($datavergader['tot'] >= "1300" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>13:30</th>
                    <td <?php if(($datavergader['van'] <= "1330") && ($datavergader['tot'] >= "1330" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>14:00</th>
                    <td <?php if(($datavergader['van'] <= "1400") && ($datavergader['tot'] >= "1400" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>14:30</th>
                    <td <?php if(($datavergader['van'] <= "1430") && ($datavergader['tot'] >= "1430" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>15:00</th>
                    <td <?php if(($datavergader['van'] <= "1500") && ($datavergader['tot'] >= "1500" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>15:30</th>
                    <td <?php if(($datavergader['van'] <= "1530") && ($datavergader['tot'] >= "1530" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>16:00</th>
                    <td <?php if(($datavergader['van'] <= "1600") && ($datavergader['tot'] >= "1600" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>16:30</th>
                    <td <?php if(($datavergader['van'] <= "1630") && ($datavergader['tot'] >= "1630" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>17:00</th>
                    <td <?php if(($datavergader['van'] <= "1700") && ($datavergader['tot'] >= "1700" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>17:30</th>
                    <td <?php if(($datavergader['van'] <= "1730") && ($datavergader['tot'] >= "1730" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>18:00</th>
                    <td <?php if(($datavergader['van'] <= "1800") && ($datavergader['tot'] >= "1800" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>18:30</th>
                    <td <?php if(($datavergader['van'] <= "1830") && ($datavergader['tot'] >= "1830" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>19:00</th>
                    <td <?php if(($datavergader['van'] <= "1900") && ($datavergader['tot'] >= "1900" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>19:30</th>
                    <td <?php if(($datavergader['van'] <= "1930") && ($datavergader['tot'] >= "1930" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>20:00</th>
                    <td <?php if(($datavergader['van'] <= "2000") && ($datavergader['tot'] >= "2000" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>20:30</th>
                    <td <?php if(($datavergader['van'] <= "2030") && ($datavergader['tot'] >= "2030" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                  <tr>
                    <th>21:00</th>
                    <td <?php if(($datavergader['van'] <= "2100") && ($datavergader['tot'] >= "2100" )){echo 'class="bezet"';}else{ echo "class='beschikbaar'";} ?> ></td>
                  </tr>
                </table>

我知道为什么它不能正确回显其他约会，因为它只能在 datavergader 中存储一条记录。但我该如何解决这个问题呢？

Answer 1

尝试使用while()

while ($datavergader = mysqli_fetch_assoc(mysqli_query($dbc,"SELECT * FROM `tbl_reservatie` WHERE op = '".$datum."' AND ruimte = 'vergader';"))) {
    // you table-rows to display data
}