how to insert array data in single column in mysql using codeigniter

Question

I'm trying to insert array data into database using codeigniter. when I print that values using print_r() fun.

It shows correct result, but when I click on save button it inserts blank values in table.

I just want to store multiple medicine names in prescription table for particular prescription_id i am trying to insert data using insert_batch function but it saves blank records

this is my model code:

public function add_prescription($data) {

    $data['medicine_name'] = $data['medicine_nm[]'];
    print_r($data['medicine_name']);

    $this->db->insert_batch('pre',$data);
     return $this->db->insert_id($pre_id);
  }

controller code--

public function prescription($patient_id = NULL, $app_date = NULL, $hour = NULL , $min = NULL) {

    //Check if user has logged in 
    if (!$this->session->userdata('user_name') || $this->session->userdata('user_name') == '') {
        redirect('login/index/');

    } else {

        if ($this->form_validation->run() === FALSE) {
          $data['medicine_nm[]']=$this->input->post('medicine_nm[]');   
           $this->patient_model->add_prescription($data);
        }
    }
}

show us your code. what you have tried so far ?

Bhavin
– Bhavin

2016-09-17 08:50:41 +00:00
Commented Sep 17, 2016 at 8:50 — Bhavin
– Bhavin, Commented Sep 17, 2016 at 8:50
Hey where is ur insert_batch function ??

Shibon
– Shibon

2016-09-17 09:59:14 +00:00
Commented Sep 17, 2016 at 9:59 — Shibon
– Shibon, Commented Sep 17, 2016 at 9:59
Proof read your question before submit

user4419336
– user4419336

2016-09-17 10:14:38 +00:00
Commented Sep 17, 2016 at 10:14 — user4419336
– user4419336, Commented Sep 17, 2016 at 10:14

Zeeshan · Accepted Answer · 2016-09-17 08:58:44Z

5

You need to json_encode that array and then insert it into the database like

$data = json_encode($array);

$this->db->insert('column_name',$data);

And while fetching you need to decode it

$data = json_decode($column_result);

Hope this helps you.

answered Sep 17, 2016 at 8:58

Zeeshan

8016 silver badges15 bronze badges

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

4 Comments

Zeeshan Over a year ago

You need to tell us if it didn't worked & what error you are getting

Ganesh Aher Over a year ago

it gives blank view page and database column is empty

Zeeshan Over a year ago

We are not returning to view page here so you need to handle it by passing insert id if you want but debug your issue tell me what it gives you in $data,if you print_r($data); just above model call in controller

Zeeshan Over a year ago

Also can you tell what is $pre_id in your model code

GGsThePlayDude · Accepted Answer · 2016-09-17 09:10:39Z

1

try this

public function add_prescription($name) {


$data = array(
 'medicine_name' => $name
  );

  $query = $this->db->insert('table_name',$data);

  return $query->result_array();
 }

Hope this will help you

answered Sep 17, 2016 at 9:10

GGsThePlayDude

571 silver badge8 bronze badges

7 Comments

parth Over a year ago

you can't save the array in database directly, you need to data encode to json format.

GGsThePlayDude Over a year ago

well i am using codeigniter as my framework for about a year, and this works fine for me! i am not using that encode to json format thing, i am just using what is in the manual

Ganesh Aher Over a year ago

Yes, I tried that also, it generates 500 error. @ GGsThePlayDude

Ganesh Aher Over a year ago

public function prescription($patient_id = NULL, $app_date = NULL, $hour = NULL , $min = NULL) { //Check if user has logged in if (!$this->session->userdata('user_name') || $this->session->userdata('user_name') == '') { redirect('login/index/'); } else { if ($this->form_validation->run() === FALSE) { $data['medicine_nm[]']=$this->input->post('medicine_nm[]'); $this->patient_model->add_prescription($data); } }

Ganesh Aher Over a year ago

when i use your code print_r will give this output:- Array ( [medicine_name] => Array ( [0] => sss [1] => vvv ) ) But records not inserted in table @ GGsThePlayDude

|

Collectives™ on Stack Overflow

how to insert array data in single column in mysql using codeigniter

2 Answers 2

4 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related