Checkbox and MySQL database with PHP

Question

I've got a problem. I don't know how to put the value of my checkbox in my MySQL database with PHP. So :

<input type="checkbox" name="checkiard" value="IARD">

How to put the value "IARD" in my database ONLY if the checkbox is check ? Thank you guys.

after posting form you can access the value of this checkobx using $_POST['checkiard'] and can insert it into database — usman ikram, Oct 23 '17 at 20:22
You can do this in two ways. One is make an ajax call after check the input and the other is submit the form by check the input, then use $_POST['checkiard'] to get the value of this input. — fatih, Oct 23 '17 at 20:28
Ok, but there is more : ` IARD
vie place` I've got a lot of checkbox, I want just insert the value **only** if a checkbox is check... And that for all my checkbox ! — Alessio Cammarata, Oct 23 '17 at 20:30
Possible duplicate of [How do I insert multiple checkbox values into a table?](https://stackoverflow.com/questions/20176673/how-do-i-insert-multiple-checkbox-values-into-a-table) — Shanteshwar Inde, Jan 11 '19 at 09:14

Rajan Benipuri · Accepted Answer · 2017-10-23T22:06:56.147

0

You can access the value of checkbox as any other input types. Its simply

  if(isset($_POST['checkiard'])) {
  $optionArray = implode(",", $_POST["checkiard"]);
  }

Try this.

If you have more than one checkbox then you markup should be something like this

<input type="checkbox" name="checkiard[]" value="IARD-1">
<input type="checkbox" name="checkiard[]" value="IARD-2">
<input type="checkbox" name="checkiard[]" value="IARD-3">

you must keep the name same for all the checkbox.

edited Oct 23 '17 at 22:06

answered Oct 23 '17 at 20:36

Rajan Benipuri

1,772
1
9
21

So I try your solution, but there's a problem : the latest value only is put in the database... If I check IARD-1, IARD-2 and IARD-3, only IARD-3 is put in the database... – Alessio Cammarata Oct 23 '17 at 21:21
Alright, so you need multiple checkbox to be selected. Then you will have to use array of values. Please check my updated code and let me know. – Rajan Benipuri Oct 23 '17 at 21:29
It doesn't work... Can I send you a pic of my code and can you tell me where is the problem ? – Alessio Cammarata Oct 23 '17 at 21:39
How exactly you want to access the values. its better to edit your question and add your php code as well – Rajan Benipuri Oct 23 '17 at 21:43
look my answer (sorry I'm beginner in this website) – Alessio Cammarata Oct 23 '17 at 21:49
try the updated code. Also, can you insert your other values in the database? – Rajan Benipuri Oct 23 '17 at 22:07
OMG IT WORK !! Thank you so much ! You are a boss ! :D +1 – Alessio Cammarata Oct 23 '17 at 22:11

Checkbox and MySQL database with PHP

1 Answers1