Inserting array of data in database

Question

I have two arrays of values:

First array contain user id's:

Array ([0]=>1 [1]=>2 [2]=>3 [3]=>4 [4]=>5 [5]=>6)

Second array contain attendance status:

Array([0]=>Present [1]=>Absent [2]=>Absent [3]=>Present [4]=>Absent [5]=>Present)

I want to insert these values in the database in separate rows like this:

U_id                        Status

 1                          Present
 2                          Absent
 3                          Absent
 4                          Present
 5                          Absent
 6                          Present

Currently, I am using this code to insert values in database.

My Controller Code:

public function usr_att(){
    if(isset($_POST['submit'])){

        $uid = $_POST['uid'];
        $status= $_POST['stat'];
        $id = implode("," , $uid );
        $status = implode("," , $status );
        $data = array (
          'u_id' => $id,
          'status' => $status
        );
        $this->db->insert('attendence' , $data);
        redirect("usr/usr_list", "refresh");
    }
}

But this code inserts data like this:

U_id                Status

 1                  Present,Absent,Absent,Present,Absent,Present

How can I insert these values in separate rows using CodeIgniter?

What version of PHP are you using?

Brian Gottier
– Brian Gottier

2017-10-15 16:53:50 +00:00
Commented Oct 15, 2017 at 16:53 — Brian Gottier
– Brian Gottier, Commented Oct 15, 2017 at 16:53

Abdulla Nilam · Accepted Answer · 2017-10-15 17:13:14Z

1

Simply you can do like this

public function usr_att()
{
    if(isset($_POST['submit']))
    {
        $uid = $_POST['uid'];
        $status = $_POST['stat'];

        foreach ($uid as $key => $item) 
        {
            $data = array (
                'u_id' => $item,
                'status' => $status[$key]
            );
            $this->db->insert('attendence' , $data);
        }
        redirect("usr/usr_list", "refresh");
    }
}

answered Oct 15, 2017 at 17:13

Abdulla Nilam

39.6k18 gold badges85 silver badges114 bronze badges

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

1 Comment

sameed ul hassan Over a year ago

Thank you sir for your help its working according to my requirement.

Brian Gottier · Accepted Answer · 2017-10-15 17:00:39Z

0

For your intended purpose, once you have the values for $uid and $stat in an array, then you could do this:

<?php

// You have your u_id values in an array
$uid = array('1','2','3','4','5','6');

// You have your status values in an array
$stat = array('Present', 'Absent', 'Absent', 'Present', 'Absent', 'Present');

// As long as the number of u_id values and status values are the same
if( count($uid) == count($stat) )
{
    // Use the count of uid values and loop through
    for( $x = 0; $x <= count($uid) -1; $x++ )
    {
        // Entering each on in the database
        $this->db->insert('attendence', array(
            'u_id'   => $uid[$x],
            'status' => $stat[$x]
        ));
    }
}

answered Oct 15, 2017 at 17:00

Brian Gottier

4,6003 gold badges24 silver badges39 bronze badges

Collectives™ on Stack Overflow

Inserting array of data in database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related