SHOW:
|
|
- or go back to the newest paste.
| 1 | - | <? |
| 1 | + | <?php |
| 2 | function trimStr($str) | |
| 3 | {
| |
| 4 | - | $user_group_id = $this->session->userdata('user_group_id');
|
| 4 | + | return trim(preg_replace("/[^a-zA-Z0-9]+/", "\n", strip_tags($str) ));
|
| 5 | - | $cluster_id = $this->session->userdata('cluster_id');
|
| 5 | + | } |
| 6 | - | $region_id = $this->session->userdata('region_id');
|
| 6 | + | |
| 7 | - | $created_on = date('Y-m-d H:i:s');
|
| 7 | + | |
| 8 | - | $created_by = $this->session->userdata('user_id');
|
| 8 | + | $user_group_id =$this->session->userdata('user_group_id');
|
| 9 | - | $session_id = $this->session->userdata('session_id');
|
| 9 | + | $cluster_id =$this->session->userdata('cluster_id');
|
| 10 | - | $territory_id = $this->session->userdata('territory_type_id');
|
| 10 | + | $region_id =$this->session->userdata('region_id');
|
| 11 | - | $upload_date = date('Y-m-d H:i:s');
|
| 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 | - | 'nik'=>$dataarray[$i]['nik'], |
| 17 | + | |
| 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 | - | 'user_group_id'=>0, |
| 34 | + | |
| 35 | - | 'cluster_id'=>1, |
| 35 | + | |
| 36 | - | 'region_id'=>1, |
| 36 | + | |
| 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 |