Array save in database instead of value in CodeIgniter

Question

I have a model function like following. When I click submit, all the data gets saved in the database, but the image field value is stored as Array,Array,Array.

How to solve this issue? I am a beginner with PHP and CodeIgniter.

public function create_post($post_image){
    $slug = url_title($this->input->post('title'));
    $image = implode(',',$post_image);

    $data = array(
        'title' => $this->input->post('title'),
        'slug' => $slug,
        'body' => $this->input->post('body'),
        'category_id' => $this->input->post('category_id'),
        'user_id' => $this->session->userdata('user_id'),
        'post_image' => $image
    );

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

@Harun Anwar, comment all codes and just add print_r($post_image) and see what is showing... then copy those code and add it here. so we can find solution for you.. — Anfath Hifans
– Anfath Hifans, Commented Apr 16, 2018 at 11:07
Do some debugging. Find out what the value of $post_image is. — jjok
– jjok, Commented Apr 16, 2018 at 11:07
I got following after print_r($post_image); Array ( [images] => Array ( [name] => Array ( [0] => img.jpg ) [type] => Array ( [0] => image/jpeg ) [tmp_name] => Array ( [0] => D:\xampp\tmp\php7052.tmp ) [error] => Array ( [0] => 0 ) [size] => Array ( [0] => 622030 ) ) ) — Harun Anwar
– Harun Anwar, Commented Apr 16, 2018 at 11:20

Sambhaji Katrajkar · Accepted Answer · 2018-04-16 12:06:54Z

0

Try following code :

public function create_post($post_image){
                    $slug = url_title($this->input->post('title'));
                    $image = implode(',',$post_image);

        $data = array(
            'title' => $this->input->post('title'),
            'slug' => $slug,
            'body' => $this->input->post('body'),
            'category_id' => $this->input->post('category_id'),
            'user_id' => $this->session->userdata('user_id'),
            'post_image' => $image['images']['name'][0]
        );
        return $this->db->insert('posts', $data);
    }

But firstly make sure you are getting values in $post_image variable.

answered Apr 16, 2018 at 12:06

Sambhaji Katrajkar

4072 silver badges10 bronze badges

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

Comments

Anfath Hifans · Accepted Answer · 2018-04-17 08:31:34Z

0

replace your function with following codes.

public function create_post($post_image){
    extract($this->input->post());
    $slug = url_title($title);
    $user_id = $this->session->userdata('user_id');
    $post_image = $post_image['images']['name'][0]; 

    $this->db->insert('posts', compact('title','slug','body','category_id','user_id','post_image'));
    return ($this->db->trans_status()) ? $this->db->insert_id() : false;
}

answered Apr 17, 2018 at 8:31

Anfath Hifans

1,5981 gold badge12 silver badges20 bronze badges

Collectives™ on Stack Overflow

Array save in database instead of value in CodeIgniter

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related