How do I add on multiple $_POST['row'] and variables?

Question

I am struggling to find out the syntactically correct way in which to add on more variables and rows to these statements:

/* WANT TO ADD ON FIVE MORE $_POST[''] */

if(isset($_POST['check_prof']) && $_POST['check_prof'] == 'checked') {
$check_prof = "checked";
}else{
$check_prof = "unchecked";
} 

/* SAME HERE, WANT TO ADD THE OTHER FIVE IN HERE AS WELL */

$query = "UPDATE `Users` SET `check_prof` = '" . $check_prof . "' WHERE `id` = '" . $auth->id . "' LIMIT 1";
    mysql_query($query,$connection);
    $auth->refresh();
    }

Answer 1

Assuming I'm understanding what you mean, try this:

<?php
$arr = array('check_prof' => 'unchecked',
            'check_student' => 'unchecked');
foreach($arr as $field => $checked) {
    if (isset($_POST[$field]) && $_POST[$field] == 'checked') {
        $arr[$field] = 'checked';
    }
    // I don't know where $auth is coming from
    $query = "UPDATE `Users` SET `$field` = '" . $arr[$field] . "' WHERE `id` = '" . $auth->id . "' LIMIT 1";
    mysql_query($query,$connection);
    $auth->refresh();
}
?>

You would simply need to add fields as needed to $arr for it to loop through.