如何同时将复选框值和文本字段数据发布到mysql数据库中

Question

I need help posting data from HTML forms to a MySql database, especially checkboxes, I don't have a problem connecting to the database but I have a problem posting checkbox values and text field data at the same time, please assist me with the PHP code.

I have the following code.

<form action="action_page.php">
<fieldset>
<legend>Personal information:</legend>
First name:<br>
<input type="text" name="firstname" value="Mickey">
<br>
Last name:<br>
<input type="text" name="lastname" value="Mouse">
<br><br>
</fieldset>
<fieldset>
<legend>Course:</legend>
<input type="checkbox" name="french" value="French"> French
<br>
<input type="checkbox" name="german" value="German"> German 
<br>
<input type="checkbox" name="spanish" value="Spanish"> Spanish 
</fieldset>
<input type="submit" value="Submit">
</form>

Answer 1

Post data are available in a global variable called $_POST.

To get values from a HTML form, after submit you just have to use this variable.

If for example french check-box is checked you will have:

$_POST['french'] = "french"

You have to see whether the user has checked that check-box or not. So just use isset() function:

if (isset($_POST['french'])) {
    //french check-box is checked.
} else {
    //french check-box is not checked.
}

And for text-fields you will have:

$_POST['firstname'] = "Mickey"

Also you have to change <form action="action_page.php"> to <form action="action_page.php" method="POST"> because HTML uses GET method by default.