Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function upload_csv_test()
- {
- $adminid = $this->session->userdata('aid');
- if(empty($adminid))
- {
- redirect('admin/index');
- }
- else
- {
- $file_path = "/var/www/html/asset/test_csv/5Lac.csv";
- $sub = $this->Admin_model->add_csv_data($file_path);
- }
- }
- public function add_csv_data($file_path)
- {
- $this->db->query("LOAD DATA LOCAL INFILE '".$file_path."'
- INTO TABLE test_csv
- FIELDS TERMINATED BY ','
- LINES TERMINATED BY '\n'
- IGNORE 1 LINES
- (cid,latitude,longitude,Email,Jurisdiction_Parish,Jurisdiction_Ward,Jurisdiction_Precinct,Personal_FirstName,
- Personal_MiddleName,Personal_LastName,Personal_NameSuffix,Residence_HouseNumber,Residence_HouseFraction,Residence_StreetDirection,
- Residence_StreetName,Residence_ApartmentNumber,Residence_City,Residence_State,Residence_ZipCode5,Residence_ZipCode4,Mail_Address1,
- Mail_Address2,Mail_City,Mail_State,Mail_ZipCode5,Mail_ZipCode4,Mail_Country,Personal_Sex,Personal_Race,Registration_PoliticalPartyCode,
- Personal_Age,Registration_VoterStatus,Registration_Date,Registration_Number,Personal_Phone,LastVoted,Residence_WalkListOrder,
- Favorability,Yard_Sign,Comments,Personal_NameOrder,voted,Rating,Custom_Variable1,Custom_Variable2,Custom_Variable3)
- ");
- }
Add Comment
Please, Sign In to add comment