Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function trimStr($str)
- {
- return trim(preg_replace("/[^a-zA-Z0-9]+/", "\n", strip_tags($str) ));
- }
- function save_data_target($dataarray,$userfile,$path_file_excel){
- $user_group_id =$this->session->userdata('user_group_id');
- $cluster_id =$this->session->userdata('cluster_id');
- $region_id =$this->session->userdata('region_id');
- $created_on = date('Y-m-d H:i:s');
- $created_by =$this->session->userdata('user_id');
- $session_id = $this->session->userdata('session_id');
- $territory_id =$this->session->userdata('territory_type_id');
- $upload_date = date('Y-m-d H:i:s');
- for($i=1;$i<count($dataarray);$i++){
- $data = array(
- 'region_name'=>$dataarray[$i]['region_name'],
- 'cluster'=>$dataarray[$i]['cluster'],
- 'nik'=>trimStr($dataarray[$i]['nik']),
- 'name'=>$dataarray[$i]['name'],
- 'kpi_code'=>$dataarray[$i]['kpi_code'],
- 'kpi_description'=>$dataarray[$i]['kpi_description'],
- 'type_incentive_id'=>$dataarray[$i]['type_incentive_id'],
- 'type_incentive'=>$dataarray[$i]['type_incentive'],
- 'chanel_code'=>$dataarray[$i]['chanel_code'],
- 'type_target_id'=>$dataarray[$i]['type_target_id'],
- 'type_target'=>$dataarray[$i]['type_target'],
- 'target'=>$dataarray[$i]['target'],
- 'month'=>$dataarray[$i]['month'],
- 'year'=>$dataarray[$i]['year'],
- 'upload_date'=>$upload_date,
- 'created_by'=>$this->session->userdata('user_id'),
- 'territory_id'=>$territory_id,
- 'created_on'=>$created_on,
- 'user_group_id'=>$user_group_id,
- 'cluster_id'=>$cluster_id,
- 'region_id'=>$region_id,
- 'session_id'=>$session_id,
- 'nama_file_excel'=>$userfile,
- 'path_file_excel'=>$path_file_excel
- );
- $this->db->insert('nama_tabel', $data);
- }
- }
- ?>
- // bagaimana cara penulisan trim() sebelum insert ke tabel ?
- // saya mau trim() pada kolom nik -> 'nik'=>$dataarray[$i]['nik'],
- terima kasih
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement