如何获取数组中的值以及如何使用codeigniter在数据库中插入

Question

Here i have one array, in this array i have one more array name studentAbsentId, now i want insert the studentAbsentId in database, like here studentAbsentId 2 and studentAbsentId 2 is absent so i need to insert the two rows

My updated code print_r($params);

 Array
(
    [studentAbsentId] => Array
        (
            [0] => 2
            [1] => 3
        )

    [schoolId] => 2
    [classId] => 1
    [sectionId] => 1
    [studentAbsentDate] => 2017-04-18
    [reg_date] => 2017-04-18 05:20:17
    [created_by] => 1
)

Now i want to take only studentAbsentId,how can do?

expected results

2

3

Answer 1

Try this it helps :)

<?php

$params=array(
        'studentAbsentId' => array
            ( 2,3
            ),
        'studentAbsentDate' => '2017-04-18',
        'reg_date' => '2017-04-18 04:41:21',
        'created_by' => '1',
    );


foreach($params['studentAbsentId'] as $ff)
{
        $atnEntry = array(
        "studentAbsentId" => $ff,
        "studentAbsentDate" =>$params['studentAbsentDate'],
        "morning" => "1"

        );

        $this->db->insert("student_absent_list" , $atnEntry);
}        
        $return = array("status" => "Success" );
        echo json_encode($return);  

?>