例如,有一位客户购买了4个产品一。它已经被插入到表格中。
产品表:
----------------------------------
Product quantity
----------------------------------
Product-One 4
当客户购买时,他们当时还没有决定要购买该产品。他们只是想和我们一起保存。第二天,当客户需要产品时,他们要求我们交付产品。
由于他们已经购买了4个PRroduct One,他们可以选择他们希望我们向他们交付多少产品。
现在我不知道如何打破数量,例如在产品一中,有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>';
}
}
一个简单的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 } %>