我正在尝试以表格格式从数据库中获取数据。我将计数变量作为行数和 5 列。当我执行此查询时,所有结果都在多行和单列中获取。这是我的代码:
<?php
include("connect.php");
$all_product = mysqli_query($connect, "SELECT * FROM product WHERE user_id='$fetch_user_id'");
echo '<table style="background-color:white; margin-left:50px; margin-right:50px;">';
$count = mysqli_num_rows($all_product);
$count = ($count / 5) + 1;
for ($i = 0; $i < $count; $i++) {
echo "<tr[$i]>";
for ($m = 0; $m < 5; $m++) {
echo "<td[$m]>";
while ($all = mysqli_fetch_array($all_product)) {
echo '<img src="' . $all['image'] . '" width="150px" height="150px" />
<div class="search_details">
<figcaption>' . $all['name'] . '</figcaption>
<figcaption>by ' . $all['brand'] . '</figcaption><figcaption>₨' . $all['price'] . '</figcaption>
<figcaption>Save: ₨' . $local_price . ', (' . $all['discount'] . '%)</figcaption><figcaption>In stock:' . $all['stock'] . '</figcaption></div>';
}
echo "</td[$m]>";
}
echo "</tr[$i]>";
}
echo "</table>";
?>
有什么帮助吗?我哪里做错了?提前谢谢你
我希望这有帮助:
<?php
$all_product = mysqli_query($connect, "SELECT * FROM product WHERE user_id='$fetch_user_id'");
$i= 0;
$m=5;
echo '<table width="100%" margin-left="30px" style="background-color:white;">';
while ($all = mysqli_fetch_array($all_product)) {
if($i%5==0) {
echo "<tr>";
}
echo '<td style="width:20%">';
echo '<img src="'.$all['image'].'" width="150px" height="150px" />
<div class="search_details">
<figcaption>'.$all['name'].'</figcaption>
<figcaption>by '.$all['brand'].'</figcaption><figcaption>₨'.$all['price'].'</figcaption>
<figcaption>Save: ₨'.$local_price.', ('.$all['discount'].'%)</figcaption><figcaption>In stock: '.$all['stock'] .'</figcaption></div>';
echo "</td>";
if($i%$m==$m - 1){
echo "</tr>";
}
$i++;
}
echo "</table>";
?>