Insert multiple checkbox values in a single column. I have multiple checkboxes like language (‘English, Spanish, Bengali, Hindi, etc…), when the user selects multiple languages it will save in the database in a single table column. How can I insert multiple checkbox values in a single column?
This is my form:
<form method="post"> English: <input type="checkbox" name="language" value="English"> Spanish: <input type="checkbox" name="language" value="Spanish"> Hindi: <input type="checkbox" name="language" value="Hindi"> Bengali: <input type="checkbox" name="language" value="Bengali"> </form>
Add [] this after the input checkboxes names for insert multiple checkbox values in a single column
<form method="post"> English: <input type="checkbox" name="language[]" value="English"> Spanish: <input type="checkbox" name="language[]" value="Spanish"> Hindi: <input type="checkbox" name="language[]" value="Hindi"> Bengali: <input type="checkbox" name="language[]" value="Bengali"> </form>
Now try it:
<?php $languageVariable=implode(',', $_POST['language']); mysqli_query($bd_connect,"INSERT INTO `table name`(`languages`)VALUES('".$languageVariable."')"); ?>
Question and answer is powered by AnsPress.io