Enpeiks
Enpeiks

Reputation: 101

codeigniter inside multiple checkbox

I have small problem with my PHP code. I must insert to database multiple values but I dont have any idea how I can do this.

My View:

<?php foreach($myKidsGroupID as $row): ?>
<label><input type="checkbox" name="user_my_group_msg" value="<?php echo $row->id; ?>" class="my_group_msg pull-right"><?php echo $row->firstname; ?> <?php echo $row->lastname; ?></label><br>
<?php endforeach; ?>

And my Model looks like this:

...

elseif($checked_my_group == 1) {

                    foreach ( ?? ) {
                    $new_mail = array(
                    'to_user'           =>  $this->input->post('user_my_group_msg'),
                    );

                    $this->db->insert('mailbox', $new_mail);
                }

            }
...rest code....

Inside my View I display all users as checkbox but If I select two persons I must INSERT two query to database. Anyone can help me?

Upvotes: 2

Views: 495

Answers (2)

Niraj patel
Niraj patel

Reputation: 525

try it once it will help you your View code will look as like

<?php foreach($myKidsGroupID as $row): ?>
    <label><input type="checkbox" name="user_my_group_msg" value="<?php echo $row->id; ?>" class="my_group_msg pull-right"><?php echo $row->firstname; ?> <?php echo $row->lastname; ?></label><br>
    <?php endforeach; ?>

Model will be corrected like this

<?php  
elseif(sizeof($this->input->post('user_my_group_msg'))>=1) {

    foreach ( $this->input->post('user_my_group_msg') as $value ) {
        $new_mail = array(
        'to_user'           =>  $value,
        );
        $this->db->insert('mailbox', $new_mail);
    }

}
.....rest code
        ?>

Upvotes: 0

Ijaz Ahmed Bhatti
Ijaz Ahmed Bhatti

Reputation: 729

simple thing is use serialize function don't use foreach

serialize $this->input->post('user_my_group_msg')

Upvotes: 2

Related Questions