insert multiple checkbox value using jquery and ajax but i only insert one record

Question

I have this table in my database,

Now, in the raw_selected_rubric(Level) column that is where I will insert multiple values based on how many checkbox have been check. For example,

Based on the picture I have selected the level 3 and level 4 and when I click submit only the level 3 value is inserted on my database.

Input field,

<input class="rubricChkbox" type="checkbox" value="3" />

Jquery and Ajax,

var rubricChkbox = [];
    $('.rubricChkbox').each(function(){  
            if($(this).is(":checked"))  
            {  
                 rubricChkbox.push($(this).val());  
            }  
       });  
       rubricChkbox = rubricChkbox.toString();
$.ajax({
        url: "Queries/save.php",
        type: "POST",
        data: { 
              "rubricChkbox":rubricChkbox
              },
        success: function(yey){
          console.log(yey);
          alert(yey);
        }
      });

Queries/save.php,

if(isset($_POST['rubricChkbox'])) {
$rubric_value = $_POST['rubricChkbox'];

        $sql_raw = "INSERT INTO rubric_selected (raw_selected_rubric, Saved, ID_cmat, ID_users)

        VALUES  ('$rubric_value', '1')";

        $success = mysqli_query($conn, $sql_raw); 
}

What's wrong in my code? I'm sorry I'm still learning jquery and ajax. Thank you for the help.

What I want to happen is that if I selected Level 3 and 4 it both data will be inserted like this,

ahmed abdullah · Accepted Answer · 2018-10-14 15:44:43Z

1

you need to have multiple insert statements like this for example:

if(isset($_POST['rubricChkbox'])) {
$rubric_value = $_POST['rubricChkbox'];
    foreach($rubric_value as $value){
           $sql_raw = "INSERT INTO rubric_selected (raw_selected_rubric, Saved, ID_cmat, ID_users)

            VALUES  ('$value', '1')";

            $success = mysqli_query($conn, $sql_raw);

    }
}

edited Oct 14, 2018 at 15:44

answered Oct 14, 2018 at 15:26

ahmed abdullah

514 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

jeloneedshelp Over a year ago

Hi sir, I've tried that and I'm getting an error "<b>Warning</b>: Invalid argument supplied for foreach()"

ahmed abdullah Over a year ago

you need to remove this line from your jquery : rubricChkbox = rubricChkbox.toString();

ahmed abdullah Over a year ago

from what I see all your checkboxes have the value of 3 : <input class="rubricChkbox" type="checkbox" value="3" /> you should give each a different value

jeloneedshelp Over a year ago

I have fixed that sir. It actually work but the problem about it is that if i select level 3,4,5 it will insert levels 3 and 4 except the level 5.

ahmed abdullah Over a year ago

I don't know about that probably it's an error in the html code

|

jeloneedshelp · Accepted Answer · 2018-10-14 15:55:48Z

0

Yep I've tried it sir,

if(isset($_POST['rubricChkbox'])) {
      $rubric_value = $_POST['rubricChkbox'];
      foreach($rubric_value as $value){

        $sql_raw = "INSERT INTO rubric_selected (raw_selected_rubric, Saved, ID_cmat, ID_users)

        VALUES  ('$value', '1')";

        $success = mysqli_query($conn, $sql_raw);
 }
}

answered Oct 14, 2018 at 15:55

jeloneedshelp

1433 silver badges12 bronze badges

Comments

Tyler2P · Accepted Answer · 2023-02-15 17:36:19Z

0

var Hobbies = "";
$(".chkHobbies").each(function (e) {
  if (this.checked) {
    if (Hobbies == "") {
      Hobbies = this.id;
    } else {
      Hobbies = Hobbies + ',' + this.id;
    }
  }
});

edited Feb 15, 2023 at 17:36

Tyler2P

2,37030 gold badges26 silver badges34 bronze badges

answered Feb 13, 2023 at 6:37

Abhay yadav

1

2 Comments

Abhay yadav Over a year ago

you need to have multiple insert statements like this for example:

cyberbrain Over a year ago

Please add some explanations to your solution, and not just as comment but also in the answer (edit it)

Collectives™ on Stack Overflow

insert multiple checkbox value using jquery and ajax but i only insert one record

3 Answers 3

6 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related