php - 提交时更新数据库字段

Question

当管理员在表中勾选一行或多行并单击批准按钮时，该行数据(request_id 是主键)应在数据库字段 is_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