How to insert a dynamic form values into database in php

Question

how to insert form values(dynamic checkbox,input) dynamically into database This my view file:

<form action="<?php base_url('controller/insert'); ?>"> 
    <table>
        <thead>
            <tr> 
                <th>Menu Id</th> 
                <th>Menu Name</th> 
                <th>Yes/No</th> 
            </tr> 
        </thead>
        <tbody>
            <?php foreach($result as $res) { ?>
                <tr> 
                    <td><input type="text" name="menu_id[]" value="<?= $res->menu_id ?>"></td> 
                    <td><input type="text" name="menu_name[]" value="<?= $res->menu_name ?>"></td> 
                    <td><input type="checkbox" name="yes[]" value="<?= $res->menu_id ?>"></td> 
                </tr> 
            <?php } ?>
        </tbody>
    </table>
</form>

this my controller function:

<?php
    $fields = array(
        'menu_id'   => $this->input->post('menu_id'),
        'menu_name' =>  $this->input->post('menu_name'),
        'yes'       =>$this->input->post('yes')
    );
    $this->db->insert('menu_table',$fields);
?>

when i print this array $fields it displays as:

Array ( [0] => 2 [1] => 3 ) Array ( [0] => Plant [1] => Line ) Array ( [0] => on [1] => on ).

this my form:the menuid and menu desc and checkbox displaying dynamically.i need to insert into table as same as the form below displays.

Do you get an error? Are wrong values inserted? Is anything inserted? — user8034901
– user8034901, Commented Jul 23, 2018 at 7:42
you have to loop through your post value then insert the data since all form values are in arrays — Pradeep
– Pradeep, Commented Jul 23, 2018 at 7:43
no, i'm not getting any error,but i want to insert into db like the image mentioned above — sunshine
– sunshine, Commented Jul 23, 2018 at 7:46

Alex · Accepted Answer · 2018-07-24 18:55:03Z

3

You need to loop through the arrays. You can use the menu id as the key as it is sequential e.g. the first of menu_id corresponds with the first of menu_name:

$menu_id = $this->input->post('menu_id');
$menu_name = $this->input->post('menu_name');
$yes = $this->input->post('yes');

$yes = is_null($yes) ? array() : array_flip($yes);

if (is_null($menu_id) || is_null($menu_name)) {
    show_error('Parameters missing');
}

// should really be in a model
foreach ($menu_id as $key => $value) {
    $data['menu_id'] = $value;
    $data['menu_name'] = $menu_name[$key];
    $data['yes'] = isset($yes[$value]) ? 'true' : 'false';
    $this->db->insert('menu_table',$data);
}

edited Jul 24, 2018 at 18:55

answered Jul 23, 2018 at 7:52

Alex

9,2958 gold badges43 silver badges90 bronze badges

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

8 Comments

Alex Over a year ago

can you check something for me? your checkboxes are returning 'on' in your example. as you may know if a checkboxes isn't checked then it doesn't submit anything hence it might mess up the order and be incorrectly assigned in my answer. according to your value it should return the value of the menu_id? but it doesnt???

Alex Over a year ago

in any case if you can get the checkboxes to report the menu_id when checked you can simply modify my code as follows: $yes = array_flip($this->input->post('yes'));

sunshine Over a year ago

but warning error occurs Message: array_flip() expects parameter 1 to be array, null given

Alex Over a year ago

my bad $yes = $this->input->post('yes'); $yes = is_null($yes) ? array() : array_flip($yes);

sunshine Over a year ago

but if the checkbox isn't checked it stores false into table.(i replyed :can you check something for me?)

|

Collectives™ on Stack Overflow

How to insert a dynamic form values into database in php

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related