php - 使用数组获取提交表单操作

Question

我有一个基于数据库mysql的表单，就像这样

<form name="" id="form1" method="GET" action="submit.php"></form> 
<?php 
include 'connection.php';
$myquery="SELECT * FROM `tbl` " ;
$params=mysql_query($myquery) or die (mysql_error()); 
while ($param=mysql_fetch_assoc($params))
{?> 

   <input name="<?php echo $param['id'] ?>" value="<?php echo $param['child_id'] ?>" />
   <input type="checkbox" name="checkbox<?php echo $param['id'] ?>" value="Yes" form="form1" />  
   <input class="form-control text-center" form="form1" name="desc<?php echo $param['id'] ?>" value="<?php echo $param['desc'] ?>"/>
   <input class="form-control text-center" form="form1" name="value <?php echo $param['id'] ?>" value="<?php echo $param['value'] ?>"/>
   <select class="form-control" form="form1" id="" name="select<?php echo $param['id'] ?>">          
      <option value=""></option>
      <option value="OK">OK</option>
      <option value="NOK">NOK</option>
   </select>
<?php } ?>
 <button type="submit" class="btn  btn-success btn-s-md btn-rounded" form="form1"><i class="icon-save"></i>Save</button>

我如何使用此表单提交(更新)到mysql数据库，我是php新手。谢谢

Answer 1

所以是的，您必须在这一端添加应答器表单。然后我建议你用你的id添加一个隐藏值。

<input type="hidden" name"id" value="<?php echo  $param['id'] ; ?>">

在页面中提交广告后submit.php，

<?php
include 'connection.php';
if (isset($_POST["id"])){ 
$id=$_POST["id"];#so you can recover your id
$myquery="UPDATE ... " ;
mysql_query($myquery) or die (mysql_error());
echo "update success";# you can add whatever you want here 
}?>