使用 PHP 中的表格格式按尺寸购物

Question

我希望我的网站在单击桌面用户表格单元格中的任何尺寸选项时搜索属于特定尺寸的任何产品，但我遇到两个挑战

1. 我的水平单元循环应该从左到右递增，如下所示 28D、28DD、28E、28F、28FF、28G ...28K，然后移动到第二行 30D --- 30k，但它重复每个值 12 次水平像这样28D，28D，28D 12次，然后移动到第二行28DD，再次重复12次。请问我的四循环可能有什么问题？

2. 我不知道如何在表格单元格周围放置锚标记以及如何在表格单元格中放置 name = size 属性以使其链接 sizeresult.php。它将由选择查询处理，这是我的代码：

                <div class="table-responsive"><!-- table-responsive begin -->

                     <table class="table table-striped table-hover"  border="0" width="100%" cellpadding="5" cellspacing="5">

                         <thead>

                             <tr>

                                 <th class="success">

                                 <h4 class="text-center white-text">D</h4>

                                 </th>

                                 <th class="info">

                                 <h4 class="text-center white-text">DD</h4>

                                 </th>

                                 th class="danger">

                                 <h4 class="text-center white-text">E</h4>

                                 </th>

                                 <th class="success">

                                 <h4 class="text-center white-text">F</h4>

                                 </th>

                                 <th class="info">

                                 <h4 class="text-center white-text">FF</h4>

                                 </th>

                                 <th class="danger">

                                 <h4 class="text-center white-text">G</h4>

sizeresult.php 代码是这样的：

$size_name=$_POST['尺寸'];

$run_products = mysqli_query($dbc,"SELECT * FROM products INNER JOIN SIZES USING (size_id) WHEREsizes.size ='%$size_name%'");

Answer 1

我做了以下更改$count变量和for循环完全创建了代码块，按照您在问题中解释的方式格式化项目列表，每行按 12 个分组。根据您使用锚标记的请求，我添加了锚标记，以便当用户单击它时，它将被带到 sizeresult.php 页面并处理查询。我通过将以下代码放在 sizeresult.php 中查询的正上方来确保 post 和 get 请求不会冲突if(isset($_GET['size'])){ $size_name=$_GET['size'] } else if(isset($_POST['size'])){ $size_name=$_POST['size']; }您的主页中的以下内容<div class="table-responsive"><!-- table-responsive begin -->&nbsp; &nbsp; <table class="table table-striped table-hover"&nbsp; border="0" width="100%" cellpadding="5" cellspacing="5">&nbsp; &nbsp; &nbsp; &nbsp; <thead>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <tr>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="success">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">D</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="info">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">DD</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="danger">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">E</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="success">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">F</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="info">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">FF</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="danger">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">G</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="success">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">GG</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="info">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">H</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="danger">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">HH</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="success">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">J</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="info">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">JJ</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <th class="danger">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="text-center white-text">K</h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </th>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </tr>&nbsp; &nbsp; &nbsp; &nbsp; </thead>&nbsp; &nbsp; &nbsp; &nbsp; <tbody>&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; <tr>&nbsp; &nbsp; &nbsp; &nbsp; <?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //$count = 12; // Number of possible cells to add at once://you don't need this too.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $i=1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $get_sizes = "select * from sizes";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $run_sizes = mysqli_query($dbc,$get_sizes);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($row_sizes=mysqli_fetch_array($run_sizes)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $size_id = $row_sizes['size_id'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $size_name = $row_sizes['size'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($i==12){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<td align='center'><a href='product-card.php?size=$size_name' type='button' style='text-decoration:none; color:black;' class='btn btn-block'>$size_name</a></td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $i=1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "</tr><tr>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<td align='center'><a href='product-card.php?size=$size_name' type='button' style='text-decoration:none; color:black;' class='btn btn-block'>$size_name</a></td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $i++;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } // End of while loop.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </tr>&nbsp; &nbsp; &nbsp; &nbsp; </tbody>&nbsp; &nbsp; </table>&nbsp;</div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<!-- table-responsive end -->&nbsp;<!-- </form> you can remove this FORM tag if you want -->