error inserting an array in codeigniter

Question

when I insert an array in the db, I get the error "unidentified index" in some of the variables even though they all have their corresponding values. Tried using print_r, and it returned an array with values, but when I try to insert the array, the values become null. I dont understand why and I can't see the error in my code.

here's my controller

public function test()
{

    if($this->session->userdata('logged_in'))
    {
        $session_data = $this->session->userdata('logged_in');
        $user_id = $session_data['user_id'];

        $table_id = $this->input->post('table');
        $start = $this->input->post('start');
        $end = $this->input->post('end');

        $query = $this->process_resto_list->test($table_id);


        if ($query->num_rows() > 0)
        {
           $row = $query->row(); 

           $resto_id    = $row->resto_id;
           $table_number= $row->table_number;
           $table_size  = $row->table_size;
        }
        //$resto_id = $session_data['user_id'];

        $values = array(
                'resto_id'              => $resto_id,
                'diner_id'              => $user_id,
                'date'                  => $this->input->post('date'),
                'start_time'            => $start,
                'end_time'              => $end,
                'table_number'          => $table_number,
                'number_of_people'      => $table_size,
        );

        if($this->process_resto_list->insert_reservation($values))
            redirect('reservation_test/reservation', 'location');
        //print_r($values);
    }

Here's my model

public function insert_reservation($values)
{
    date_default_timezone_set("Asia/Manila");
        $data = array(

                'resto_id'              => $values['resto_id'],
                'diner_id'              => $values['user_id'],
                'date'                  => date('Y-m-d'),
                'start_time'            => $values['start'],
                'end_time'              => $values['end'],
                'table_number'          => $values['table_number'],
                'number_of_people'      => $values['table_size'],

            );

            return $this->db->insert('resto_reservations', $data);
}

When using print_r here's the result of the array

Array ( [resto_id] => 9 [diner_id] => 14 [date] => [start_time] => 11:00 [end_time] => 13:00 [table_number] => 6 [number_of_people] => 4 )

Please help me point out the error. Thank you

A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: models/process_resto_list.php Line Number: 72 @Bulk — user3400419
– user3400419, Commented Jan 19, 2015 at 17:25
and this error Error Number: 1048 Column 'diner_id' cannot be null INSERT INTO resto_reservations (resto_id, diner_id, date, start_time, end_time, table_number, number_of_people) VALUES ('9', NULL, '2015-01-20', NULL, NULL, '6', NULL) Filename: C:\xampp\htdocs\forktal\system\database\DB_driver.php Line Number: 330 @Bulk — user3400419
– user3400419, Commented Jan 19, 2015 at 17:26

Dan Smith · Accepted Answer · 2015-01-19 17:31:09Z

1

In your model. Change values as follows

$data = array(

            'resto_id'              => $values['resto_id'],
            'diner_id'              => $values['diner_id'],
            'date'                  => date('Y-m-d'),
            'start_time'            => $values['start_time'],
            'end_time'              => $values['end_time'],
            'table_number'          => $values['table_number'],
            'number_of_people'      => $values['number_of_people'],

        );

edited Jan 19, 2015 at 17:31

Dan Smith

5,67534 silver badges33 bronze badges

answered Jan 19, 2015 at 17:28

Amol Bharmoria

2394 silver badges23 bronze badges

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

2 Comments

user3400419 Over a year ago

Right!!! so stupid of me! I am literally angry at myself right now for not noticing that error. Thank you so much @AmBhar

Amol Bharmoria Over a year ago

@user3400419 Glad to know your problem is solved. :)

user3400419 · Accepted Answer · 2015-01-20 00:59:45Z

0

I just replaced my model with this. Thanks everyone!

$data = array(

            'resto_id'              => $values['resto_id'],
            'diner_id'              => $values['diner_id'],
            'date'                  => date('Y-m-d'),
            'start_time'            => $values['start_time'],
            'end_time'              => $values['end_time'],
            'table_number'          => $values['table_number'],
            'number_of_people'      => $values['number_of_people'],

        );

answered Jan 20, 2015 at 0:59

user3400419

291 silver badge6 bronze badges

Collectives™ on Stack Overflow

error inserting an array in codeigniter

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related