Skip to main content

Posts

Showing posts from July, 2017

CSV into MYSQL

Create a controller as  csv.php <? php class csv extends CI_Controller { public $data ; public function __construct () { parent :: __construct (); $this -> load -> model ( 'csv_model' ); } function index () { $this -> load -> view ( 'uploadCsvView' , $data ); } function uploadData () { $this -> csv_model -> uploadData (); redirect ( 'csv' ); } } ?> And create a model as  csv_model.php <? php class csv_model extends CI_Model { function __construct () { parent :: __construct (); } function uploadData () { $count = 0 ; $fp = fopen ( $_FILES [ 'userfile' ][ 'tmp_name' ], 'r' ) or die ( "can't open file" ); while ( $csv_line = fgetcsv ( $fp , 1024 )) { $count ++; if ( $count == 1 )