php - Dynamically created multi select box values not inserted correctly

Answer

id | resn | name

Answer

1 | 1 | Test 2 | 2 | aaa 3 | 3 | bbb

Answer

|||

Answer

-- id | resnid | service

Answer

-- 1 | 1 | 1 2 | 1 | 2 3 | 2 | 3 4 | 2 | 4 5 | 2 | 5 6 | 3 | 6|||

Answer

-- id | resnid | service

Answer

-- 1 | 1 | 1 2 | 1 | 2 3 | 1 | 3 4 | 1 | 4 5 | 1 | 5 6 | 1 | 6 7 | 2 | 1 8 | 2 | 2 9 | 2 | 3 10 | 2 | 4 11 | 2 | 5 12 | 2 | 6|||reson[]|||name[]

Answer

Solution:

You should explicitly set the key for each field. The key forreson andname should match the key forservice. Here is an example for the names to use.

reson[0]
name[0]
service[0][]

reson[1]
name[1]
service[1][]

reson[2]
name[2]
service[2][]
Copy code

Theservice field has an additional[] because it sends multiple values for each row.

Since you said that you are creating the rows dynamically, you could easily use a loop counter to create these names. Like this:

<?php for($i=0; $i<3; $i++) { ?>

  <select data-live-search="true" name="reson[<?php echo $i; ?>]" required="required">
    ...
  </select>
  <select data-live-search="true" name="service[<?php echo $i; ?>][]" id="service" multiple="multiple">
    ...
  </select>
  <input type="text" name="name[<?php echo $i; ?>]" placeholder="Name" />

<?php } ?>
Copy code

And then your PHP code would have to be like this:

<?php
foreach ($reson as $id => $value) {
    $reson = ($reson[$id]);
    $namep = ($name[$id]);
    $rsid = $ob->insert_data('tbl_reson',array("reson" => $reson, "name" => $namep), true);
    foreach ($service[$id] as $ii => $valu) {
        $r_service = $val;
        $ob->insert_data('tbl_service',array("reson_id" => $rsid, "service" => $r_service));
    }
}
?>
Copy code

Response to your comment below

You said that you are using the following Javascript code to create new rows:

var i=$('.div').length+1; $('#lobrows').append('
    <select class="form-control selectpicker" data-live-search="true" multiple="multiple" name="service['+i+'][]" id="service'+i+'">
    <option>--Select--</option>
    <?php for($k=0; $k<=10;$k++){?><option value="Reason <?php echo $k;?>">Reason <?php echo $k;?></option>
    <?php }?></select>
');
Copy code

You should make sure that you are also adding thename andreson in the same row. They should all use the samei value for their names. Like this:

var i=$('.div').length+1; $('#lobrows').append('
  <select data-live-search="true" name="reson['+i+']" required="required">
  </select>
  <select data-live-search="true" multiple="multiple" name="service['+i+'][]" id="service'+i+'">
  <option>--Select--</option>
  <?php for($k=0; $k<=10;$k++){?><option value="Reason <?php echo $k;?>">Reason <?php echo $k;?></option>
  <?php }?></select>
  <input type="text" name="name['+i+']" placeholder="Name" />
');
Copy code

Answer

Solution:

i think you have problem in foreach in foreach so after one record is inserted in first table other foreach is insert all record in second table with only first reson_id please try following code.

<?php
 extract($_POST);
 foreach ($reson as $id => $value) {
 $resona = ($reson[$id]);
 $namep = ($name[$id]);
 $rsid = $ob->insert_data('tbl_reson',array("reson" => $resona, "name" => $namep), true);
 $r_service = ($service[$id]);
 $ob->insert_data('tbl_service',array("reson_id" => $rsid, "service" => $r_service));
 }
?>
Copy code

Answer

Solution:

1. Do the firstINSERT
2. Perform$id = ... SELECT LAST_INSERT_ID(); (by whatever "ob" does.)
3. Use$id in the secondINSERT.

Answer

Solution:

Try this code :

extract($_POST);
   $rsid = array();
    foreach ($reson as $id => $value) {
        if(is_array($value)){
            foreach($value as $key => $val)
            {
                $resona = ($val);
                $namep = ($name[$id]);
                $rsid[] = $ob->insert_data('tbl_reson',array("reson" => $resona, "name" => $namep), true);
            }
        }
        else
        {
            $resona = ($value);
            $namep = ($name[$id]);
            $rsid[] = $ob->insert_data('tbl_reson',array("reson" => $resona, "name" => $namep), true);
        }
    }
    foreach ($service as $ii => $valu) {
        if(is_array($valu)){
            foreach($valu as $key => $val)
            {
                $r_service = ($val);
                foreach($rsid as $reson_id)
                    $ob->insert_data('tbl_service',array("reson_id" => $reson_id, "service" => $r_service));
            }
        }
        else
        {
            $r_service = ($valu);
            foreach($rsid as $reson_id)
                $ob->insert_data('tbl_service',array("reson_id" => $reson_id, "service" => $r_service));
        }


    }
Copy code