javascript - 将一条记录中的数量(数量)打散，设置为数组，供选项选择

Question

例如，有一位客户购买了 4 个 Product-One。它已经被插入到表中。

产品表:

   ----------------------------------
   Product             quantity             
   ----------------------------------
   Product-One           4

当客户购买该产品时，他们当时还没有决定要购买该产品。他们只是想和我们一起保存。第二天，当客户需要产品时，他们要求我们交付产品。

由于他们购买了 4 个产品一，他们可以选择希望我们向他们提供多少产品。

现在我不知道如何分解数量，例如在产品中 - 数量为 4 的人在下拉选择中变为 1,2,3,4。

   <select>
        <option>1</option>
        <option>2</option>
        <option>3</option>
        <option>4</option>
   <select>

请大家帮帮我。这对我来说越来越复杂了。 :/

这是我的模糊 php 代码:

                    <table id="canvasEstockTable">
                        <tr>
                            <td>Product</td>
                            <td>Quantity</td>
                            <td>Pick</td>
                        </tr>

            <?php           
            $resultsTicket = $mysqli->query("SELECT * FROM order_history WHERE member_name = '$member_name' ORDER BY id ASC");
                if ($resultsTicket > 0) {
                    while($obj = $resultsTicket->fetch_object()) {

                echo'       <tr>
                            <td>$obj->product_name</td>
                            <td>$obj->quantity</td>
                            <td>
                                <select name="quantity" required>
                                    <option value="">Choose Quantity</option>

                                    //IT SHOULD BE LOOPING AUTOMATICALLY HERE//
                                    <option value="{$Quantity_1}">'.{$Quantity_1}.'</option>
                                    <option value="{$Quantity_2}">'.{$Quantity_2}.'</option>
                                    <option value="{$Quantity_3}">'.{$Quantity_3}.'</option>
                                    <option value="{$Quantity_4}">'.{$Quantity_4}.'</option>
                                </select>
                            </td>
                        </tr>';

                    }
                }
            ?>

                    </table>

---

---

[在这里更新]

            <?php           
            $resultsTicket = $mysqli->query("SELECT * FROM orders_history WHERE customer_name = '$member_name' ORDER BY id ASC");
                if ($resultsTicket > 0) {
                    while($obj = $resultsTicket->fetch_object()) {

                echo'       <tr>
                            <td>'.$obj->items.'</td>
                            <td>'.$obj->quantity.'</td>
                            <td>

                                <select name="quantity" required>

                                    <option value="">Choose Quantity</option>

                                        for ($q = 1; $q <= $obj->quantity; $q++) {
                                            <option value="'.$q.'">'.$q.'</option>                                          
                                        } 

                                </select>

                            </td>
                        </tr>';

                    }
                }

Answer 1

一个简单的for循环:

<?php           
$resultsTicket = $mysqli->query("SELECT * FROM order_history WHERE member_name = '$member_name' ORDER BY id ASC");
if ($resultsTicket > 0) {
   while($obj = $resultsTicket->fetch_object()) {
   ?>
   <tr>
     <select name="quantity" required>
       <option value="">Choose Quantity</option>
        <?php
        for ($q = 1; $q <= $obj->quantity; $q++) {
        ?>
           <option value="<?=$q?>">Quantity <?=$q?></option>
        <?php } ?>
     </select>
   </tr>
<?php } %>