提交时更新数据库字段

Question

当管理员在表中勾选一行或更多行并单击approve按钮时，应在数据库字段is_approved中更新该行数据(request_id是主键)，并将“pending”更改为“approved”。is_approved字段有两个枚举:pending和approved。我该怎么做呢？

<form action = "admin.php" method = "post"> 
<input type="button" name="accept" value="accept" />
<input type="hidden" name="submitted" value="TRUE" />    
</form>

PHP代码：

if(!empty($_POST['accept'])) {
    $request_id = $_POST['request_id'];

    foreach($request_id as $is_approved) {
     $query = mysql_query("UPDATE request SET is_approved = 'approved' where is_approved =$request_id");
    }
}

Answer 1

将表单更改为：

<form action = "admin.php" method = "post"> 
<input type="button" name="accept" value="accept" />
<input type="text" name="request_id[]" value=1/>
<input type="text" name="request_id[]" value=2/>
<input type="hidden" name="submitted" value="TRUE" />    
</form>

该值应为实际的request_id