php - 更新无线电类型的多条记录
问题描述
我想更新无线电类型的多条记录(字段“状态”)。下面是代码。但是你可以在这里看到结果:http: //lamoncheri.com/admin/dapur.php ?id=21 它只识别一条记录的状态。
<?php
$i = 1;
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"> <input name="nama_menu[]" type="text" id="nama_menu" value="<?php echo $rows['nama_menu']; ?>" readonly style="width: 484px; font-size:medium"> </td>
<td align="center"> <input name="qty[]" type="int" id="qty" value="<?php echo $rows['qty']; ?>" readonly style="width: 484px; font-size:medium"> </td>
<td> <input type="radio" name="status[]" id='status' value="order" <?php if ($rows['status'] == "order"){echo "checked";} ?> class ="auto-style5" required>Order<br>
<input type="radio" name="status[]" id='status' value="process" <?php if ($rows['status'] == "process"){echo "checked";} ?> class ="auto-style5" required>Process<br>
<input type="radio" name="status[]" id='status' value="finish" <?php if ($rows['status'] == "finish"){echo "checked";} ?> class ="auto-style5" required> Finish<br>
</td>
<td style="align:center; color:white"><input name="id[]" type="text" id="id" value="<?php echo $rows['id']; ?>" readonly style="border:0; color:white; width: 10px"> </td>
</tr>
<tr>
<td colspan="4" align="center"> </td>
</tr>
<?php
$i++;
}
?>
解决方案
名字放了这样的东西
<?php
$i = 1;
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"> <input name="nama_menu<?php echo $i; ?>[]" type="text" id="nama_menu" value="<?php echo $rows['nama_menu']; ?>" readonly style="width: 484px; font-size:medium"> </td>
<td align="center"> <input name="qty<?php echo $i; ?>[]" type="int" id="qty" value="<?php echo $rows['qty']; ?>" readonly style="width: 484px; font-size:medium"> </td>
<td> <input type="radio" name="status<?php echo $i; ?>[]" id='status' value="order" <?php if ($rows['status'] == "order"){echo "checked";} ?> class ="auto-style5" required>Order<br>
<input type="radio" name="status<?php echo $i; ?>[]" id='status' value="process" <?php if ($rows['status'] == "process"){echo "checked";} ?> class ="auto-style5" required>Process<br>
<input type="radio" name="status<?php echo $i; ?>[]" id='status' value="finish" <?php if ($rows['status'] == "finish"){echo "checked";} ?> class ="auto-style5" required> Finish<br>
</td>
<td style="align:center; color:white"><input name="id<?php echo $i; ?>[]" type="text" id="id" value="<?php echo $rows['id']; ?>" readonly style="border:0; color:white; width: 10px"> </td>
</tr>
<tr>
<td colspan="4" align="center"> </td>
</tr>
<?php
$i++;
}
?>
推荐阅读
- excel - 从自动更新的 Excel 数据创建日历
- java - 休眠一对多关系java.sql.SQLIntegrityConstraintViolationException:列'person_id'不能为空
- matlab - 1./diag(A) 是什么意思?
- android - 一旦我在 datepicker 中选择日期然后我再次打开 datepicker 它显示当前日期未选择日期
- c# - 在 .NET Core 2.1 中重新加载 Serilog JSON 配置
- apache-spark - 加入两个具有复杂嵌套结构的 Spark DStream
- javascript - Inconsistency when converting DateTime to JavaScript
- uml - “dataType”实例可以作为序列图生命线出现吗?
- excel - Excel VBA - 循环多个文件夹中的文件,复制范围,粘贴到此工作簿中
- javascript - 如果得到相同的数据,停止发送请求