Suppose you have an array like this:
Array ( [product_name] => Door Type 1 [product_price] => 599 [de_color_id] => 2 [designname] => Array ( [1] => Design 1 [2] => Design 2 ) [colorname] => Array ( [1] => Array ( [0] => color 11 [1] => color 12 ) [2] => Array ( [0] => color21 [1] => color22 [2] => color23 ) ) [colorprice] => Array ( [1] => Array ( [0] => 10 [1] => 15 ) [2] => Array ( [0] => 20 [1] => 25 [2] => 30 ) ) )
If you need to insert above data into 3 different tables named product_door_type, product_door_design , product_door_color :
in your controller:
public function add_finish_good() { if ($this->input->server('REQUEST_METHOD') === 'POST') { date_default_timezone_set("Asia/Kolkata"); /*Image Uploding start*/ $file_name = $this->session->userdata('id').'_'.date('Ymdhis'); if(!empty($_FILES['userfile']['name'])) { $file_ext = $this->upload_image($file_name); $product_image = 'uploads/products/'.$file_name.$file_ext; $product_image_thumb = 'uploads/products/'.$file_name.'_thumb'.$file_ext; } else { $product_image = ''; $product_image_thumb = ''; } /*Image Uploding End*/ echo "<pre>"; print_r($_POST);exit; $product_type_data = array( 'door_image' => $product_image, 'door_image_thumb' => $product_image_thumb, 'door_name' => $this->input->post('product_name'), 'base_price' => $this->input->post('product_price') ); $insert_door_type = $this->products_model->insert_door_type($product_type_data); // for insert design foreach ($this->input->post('designname') as $key => $designname) { $door_design_data = array( 'door_type_id' => $insert_door_type, 'design_name' => $designname ); $insert_door_design = $this->products_model->insert_door_design($door_design_data); // for insert color and price foreach ($this->input->post('colorname')[$key] as $key_color => $colorname) { $colorprice = $this->input->post('colorprice')[$key][$key_color]; $door_color_data = array( 'door_design_id' => $insert_door_design, 'color_name' => $colorname, 'color_price' => $colorprice ); $insert_door_color = $this->products_model->insert_door_color($door_color_data); } } if($insert_door_type && !$insert_door_design){ redirect('admin/products/finishgoods'); } if($insert_door_type && $insert_door_design){ redirect('admin/products/finishgoods'); //redirect('admin/products/add_finish_good_color?door_id='.$insert_door_type); } } $data['page'] = 'products'; $id_user = $this->session->userdata('id'); $data['user'] = $this->sales_model->get_users_sales($id_user); $this->load->view('admin/products/addfinishGood',$data); }
0 Comments