我需要创建一个表以注册机器安全设备上的维护。
我有一个DB的表格,其中包含与他们自己的安全设备相关的所有机器的列表。
每个安全设备都可以"确定"不正常","派对好的"或" na"
我已经使用HTML/PHP创建了一个网页,在其中维护器选择了他正在执行的维护的机器,它将出现他必须控制和注册设备状态的安全设备列表(好的,不好...)。
<html>
<? include 'home.php' ?>
<body>
<div>
<form action="insert_controllo.php" method="POST">
<table>
<th>Macchina</th>
<th>Dispositivo</th>
<th>Descrizione</th>
<th>OK</th>
<th>NOK</th>
<th>PARZ</th>
<th>NA</th>
<th>Note</th>
<? while($row = mysql_fetch_array($risultato)){
echo "<tr><td> <input class='hide' type= 'text' name='macc' value ='".$row['macc']."' readonly>
</td><td> <input class='hide' type= 'text' name='iddispssic' value ='".$row['iddispsic']."' readonly>
</td><td> <input class='hide' type= 'text' name='descgen' value ='".$row['descgen']."' readonly>
</td><td> <input type= 'checkbox' name='chk1[]' value ='OK'>
</td><td> <input type= 'checkbox' name='chk1[]' value ='NOK'>
</td><td> <input type= 'checkbox' name='chk1[]' value ='PARZ'>
</td><td> <input type= 'checkbox' name='chk1[]' value ='NA'>
</td><td> <input type='text' name='note' placeholder = 'Note'>
</td></tr>";
}?>
</table>
<button class="bottone" name='submit' type='submit'>Concludi</button>
</form>
</div>
</body>
</html>
我的问题是,在邮政转储中,我仅收到表的第一行
<!-- POST: Array
(
[macc] => 09
[iddispssic] => 2
[descgen] => Ripari Fissi
[chk1] => Array
(
[0] => NOK
)
[note] =>
[submit] =>
)
-->
我不知道如何在DB中插入选中的复选框
有人可以帮我吗?
我想在db中插入类似这样的东西
Machine-SafetyDevice-State(OK,NOTOK,...) - 描述(每行有一个输入类型文本要添加注释)-DateTime
您必须更改输入的名称才能创建元素数组(您可以为另一个元素更改"元素"名称)。
$count = 0;
while($row = mysql_fetch_array($risultato)){
echo '<tr><td> <input class="hide" type= "text" name="elements['.$count.'][macc]" value ="'.$row["macc"].'" readonly>
</td><td> <input class="hide" type= "text" name="elements['.$count.'][iddispssic]" value ="'.$row["iddispsic"].'" readonly>
</td><td> <input class="hide" type= "text" name="elements['.$count.'][descgen]" value ="'.$row["descgen"].'" readonly>
</td><td> <input type= "checkbox" name="elements['.$count.'][chk1][]" value ="OK">
</td><td> <input type= "checkbox" name="elements['.$count.'][chk1][]" value ="NOK">
</td><td> <input type= "checkbox" name="elements['.$count.'][chk1][]" value ="PARZ">
</td><td> <input type= "checkbox" name="elements['.$count.'][chk1][]" value ="NA">
</td><td> <input type="text" name="elements['.$count.'][note]" placeholder = "Note">
</td></tr>';
$count ++;
}
如果仅允许使用一个状态,则必须更改复选框以放置一个单选按钮,例如:
$count = 0;
while($row = mysql_fetch_array($risultato)){
echo '<tr><td> <input class="hide" type= "text" name="element['.$count.'][macc]" value ="'.$row["macc"].'" readonly>
</td><td> <input class="hide" type= "text" name="element['.$count.'][iddispssic]" value ="'.$row["iddispsic"].'" readonly>
</td><td> <input class="hide" type= "text" name="element['.$count.'][descgen]" value ="'.$row["descgen"].'" readonly>
</td><td> <input type= "radio" name="element['.$count.'][chk1]" value ="OK">
</td><td> <input type= "radio" name="element['.$count.'][chk1]" value ="NOK">
</td><td> <input type= "radio" name="element['.$count.'][chk1]" value ="PARZ">
</td><td> <input type= "radio" name="element['.$count.'][chk1]" value ="NA" checked>
</td><td> <input type="text" name="element['.$count.'][note]" placeholder = "Note">
</td></tr>';
$count ++;
}
在" insert_controllo.php"中,您可以以这种方式读取数据:
if(isset($_POST['elements'])){
for($i=0; $i<count($_POST['elements']); $i++){
// the query. For example 'UPDATE TABLENAME SET chk1 = "'.$_POST['elements']['chk1'].'" WHERE macc = "'.$_POST['elements']['macc'].'" ';
}
}
}