insert data from foreach PHP containing an array

Question

I am using the codeigniter framework, and I am running to a bit of a problem trying to save data from a form.

How do I insert a new row for each user_answer containing the other information?

Thanks!

This is my foreach loop in the controller and the call to the model

foreach($_POST as $key => $val)  
        {  
            $data[$key] = $this->input->post($key);  
        } 
$this->quiz_model->save_answers($data);

This is the model

function save_answers($data)
    {
            foreach ($data['user_answer'] as $key) {
                    $this->db->insert('answer', $data);
            }       
    }

Table is setup as

answer_id (auto increment)
quiz_id
question_id
user_id
user_answer

Var dumps

data => array(3) { ["user_id"]=> string(9) "anonymous" ["quiz_id"]=> string(2) "24" ["question_id"]=> string(2) "18" ["user_answer"]=> array(3) { [0]=> string(1) "a" [1]=> string(1) "b" [2]=> string(1) "c" } }

data['user_answers'] => array(3) { [0]=> string(1) "a" [1]=> string(1) "b" [2]=> string(1) "c" }

error

Error Number: 1054

Unknown column 'Array' in 'field list'

INSERT INTO `answer` (`user_id`, `quiz_id`, `question_id`, `user_answer`) VALUES ('anonymous', '24', Array)

First I would use prepared statements, something codeigniter doesn't have. I would recommend you use mysqli in your model. You are vulnerable to sql injections. — Robert
– Robert, Commented Sep 4, 2017 at 3:54
@Robert Rocha as long as he is using db->insert his "All values are escaped automatically producing safer queries." Also, you can use PDO and mysqli queries. Per the codeigniter docuentation — Brad
– Brad, Commented Sep 5, 2017 at 3:44

chad · Accepted Answer · 2017-09-03 05:17:34Z

2

You should create new set of data per user_answer. Try this:

function save_answers($data)
{
        foreach ($data['user_answer'] as $key) {
                $new_data = array('user_id' => $data['user_id'], 'quiz_id' => $data['quiz_id'], 'question_id' => $data['question_id'], 'user_answer' => $key)
                $this->db->insert('answer', $new_data);
        }       
}

edited Sep 3, 2017 at 5:17

answered Sep 3, 2017 at 4:49

chad

8381 gold badge5 silver badges16 bronze badges

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

1 Comment

JonYork Over a year ago

That was exactly what the doctor ordered!

B. Desai · Accepted Answer · 2017-09-03 04:49:07Z

0

You have issue in foreach loop. Change your save_answers method to :

function save_answers($data)
{
        foreach ($data['user_answer'] as $key=>$value) { //<------------change here
                $data_insert = array('user_id'=>$data['user_id'],'quiz_id'=>$date['quiz_id'],'question_id'=>$data['question_id'],'user_answer'=>$value); //create new array
                $this->db->insert('answer', $data_insert);//<------------change here
        }       
}

answered Sep 3, 2017 at 4:49

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

Collectives™ on Stack Overflow

insert data from foreach PHP containing an array

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