Advertisement
GWibisono

ngak tahu deh bs ato tidak

Feb 4th, 2014
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. function trimStr($str)
  3. {
  4.   return  trim(preg_replace("/[^a-zA-Z0-9]+/", "\n", strip_tags($str) ));
  5. }
  6. function save_data_target($dataarray,$userfile,$path_file_excel){
  7.  
  8.         $user_group_id  =$this->session->userdata('user_group_id');
  9.         $cluster_id     =$this->session->userdata('cluster_id');
  10.         $region_id  =$this->session->userdata('region_id');
  11.         $created_on     = date('Y-m-d H:i:s');
  12.         $created_by =$this->session->userdata('user_id');
  13.         $session_id = $this->session->userdata('session_id');
  14.         $territory_id   =$this->session->userdata('territory_type_id');
  15.         $upload_date    = date('Y-m-d H:i:s');
  16.        
  17.         for($i=1;$i<count($dataarray);$i++){
  18.              $data = array(
  19.                 'region_name'=>$dataarray[$i]['region_name'],
  20.                 'cluster'=>$dataarray[$i]['cluster'],
  21.                 'nik'=>trimStr($dataarray[$i]['nik']),
  22.                 'name'=>$dataarray[$i]['name'],
  23.                 'kpi_code'=>$dataarray[$i]['kpi_code'],
  24.                 'kpi_description'=>$dataarray[$i]['kpi_description'],
  25.                 'type_incentive_id'=>$dataarray[$i]['type_incentive_id'],
  26.                 'type_incentive'=>$dataarray[$i]['type_incentive'],
  27.                 'chanel_code'=>$dataarray[$i]['chanel_code'],
  28.                 'type_target_id'=>$dataarray[$i]['type_target_id'],
  29.                 'type_target'=>$dataarray[$i]['type_target'],
  30.                 'target'=>$dataarray[$i]['target'],
  31.                 'month'=>$dataarray[$i]['month'],
  32.                 'year'=>$dataarray[$i]['year'],
  33.                 'upload_date'=>$upload_date,
  34.                
  35.                 'created_by'=>$this->session->userdata('user_id'),
  36.                 'territory_id'=>$territory_id,
  37.                 'created_on'=>$created_on,
  38.                 'user_group_id'=>$user_group_id,
  39.                 'cluster_id'=>$cluster_id,
  40.                 'region_id'=>$region_id,
  41.                 'session_id'=>$session_id,
  42.                 'nama_file_excel'=>$userfile,
  43.                 'path_file_excel'=>$path_file_excel
  44.             );
  45.             $this->db->insert('nama_tabel', $data);
  46.         }
  47.        
  48.     }
  49. ?>
  50.  
  51. // bagaimana cara penulisan trim() sebelum insert ke tabel ?
  52. // saya mau trim() pada kolom nik -> 'nik'=>$dataarray[$i]['nik'],
  53.  
  54. terima kasih
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement