循环行和列动态选择划分问题

Question

我的问题是我的系统需要借助MySQL输出特定商店可用的表总数。正如我所发现的，$seat = 11 和 11 不能完全除以 3，它只输出 10 个席位。任何帮助都会有所帮助。

<?php
$cols = 5;
$rows = round($seat / $cols);
$num = 1;
//echo "<table border='1'>";
for ($tr = 1; $tr <= $rows; $tr++) {
echo "<div class='seatRow'>";
echo "<div class='seatRowNumber'>";
echo "</div>";
for ($td = 1; $td <= $cols; $td++) {
//echo "<td>row: ".$tr." column: ".$td."</td>";
echo "<div id='_$num' role='checkbox' value='45' aria-checked='false' focusable='true' tabindex='-1' class=' seatNumber '>" . $num++ . "";
echo "</div>";
}
echo "</div>";
}
//echo "</table>";
?>

Answer 1

只需使用ceil()而不是round()如果您已达到座位数，则中断第二个循环：

<?php
$seat = 11;
$cols = 5;
$rows = ceil($seat / $cols); // <-- use ceil()
$num = 1;
//echo "<table border='1'>";
for ($tr = 1; $tr <= $rows; $tr++) {
echo "<div class='seatRow'>";
echo "<div class='seatRowNumber'>";
echo "</div>";
for ($td = 1; $td <= $cols; $td++) {
if($num > $seat) break; //<-- break the loop if you reach number of seats
//echo "<td>row: ".$tr." column: ".$td."</td>";
echo "<div id='_$num' role='checkbox' value='45' aria-checked='false' focusable='true' tabindex='-1' class=' seatNumber '>" . $num++ . "";
echo "</div>";
}
echo "</div>";
}
//echo "</table>";
?>

输出：

<div class="seatRow">
<div class="seatRowNumber"></div>
<div id="_1" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">1</div>
<div id="_2" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">2</div>
<div id="_3" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">3</div>
<div id="_4" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">4</div>
<div id="_5" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">5</div>
</div>
<div class="seatRow">
<div class="seatRowNumber"></div>
<div id="_6" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">6</div>
<div id="_7" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">7</div>
<div id="_8" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">8</div>
<div id="_9" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">9</div>
<div id="_10" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">10</div>
</div>
<div class="seatRow">
<div class="seatRowNumber"></div>
<div id="_11" role="checkbox" value="45" aria-checked="false" focusable="true" tabindex="-1" class=" seatNumber ">11</div>
</div>