How to Import CSV Data in PHP CodeIgniter Framework

Submitted by kabiru10 on Monday, February 15, 2021 - 15:35.

Language

Importing CSV data into applications is a common practice. However, CodeIgniter Framework does not out of the box have this functionality as it does not have a library that does this. We will be using a csvimport.php library written by Bradstinson. This can be downloaded at github. This library converts CSV data to an array which can be looped through and saved into a database table.

Getting Started

First, you must download and install any local web server such as XAMPP/WAMP. After that, open the XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".

Download the latest version of CodeIgniter 3.1.11.Extract the zipped folder and copy the application folder, system folder, and index.php to the folder you will create in your site root called ciaddressimport. Go to "application/config" folder and edit the Base URL to "http://localhost/ciaddressimport/". Go to your browser and browse "http://localhost/ciaddressimport". You will now see the Codeigniter welcome page. This shows Codeigniter was successfully installed.

Download also Bootstrap for the design. Create new folder inside your "ciaddressimport" naming "assets". Extract the bootstrap and copy the folders then paste it into the "assetes" folder.

Copy the csvimport.php library downloaded from Github into "Applications/Libraries" folder. The library will be loaded in our controller.

Creation of Database

Open PHPMyAdmin and create a database called “ciaddressimport”. Also create a table with the following query.

CREATE TABLE IF NOT EXISTS `addressbook` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

You can generate some dummy data for the table at

www.generatedata.com

Database Connection

Open database.php in the config (application/config) folder and set your database parameters as follows.

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'ciaddressimport';

Note: This configuration is for Wamp, if you are using Mamp , Xampp or Lamp set yours as required.

Route Configuration

Open the routes.php in "Application/Config folder". Change the default controller from "welcom" to "csv".

$route['default_controller'] = "csv";

Autoload Configuration

Open the autoload.php in the "application/config". Then configure to load automatically the "db" library for the database connection and "URL" helper for the base URL usage. Follow the code below.

$autoload['libraries'] = array('database');

$autoload['helper'] = array('url');

Creation of CSV Model

Create a new model file in the model folder called "csv_model.php" inside "application/models". Add the following code:

<?php
 
class Csv_model extends CI_Model {
    
    function __construct() {
        parent::__construct();
        
    }
    
    function get_addressbook() {     
        $query = $this->db->get('addressbook');
        if ($query->num_rows() > 0) {
            return $query->result_array();
        } else {
            return FALSE;
        }
    }
    
    function insert_csv($data) {
        $this->db->insert('addressbook', $data);
    }
}
/*END OF FILE*/

Creation of Controller

Create a New controller called csv.php in the controllers folder and add the following code:

<?php
 
class Csv extends CI_Controller {
 
    function __construct() {
        parent::__construct();
        $this->load->model('csv_model');
        $this->load->library('csvimport');
    }
 
    function index() {
        $data['addressbook'] = $this->csv_model->get_addressbook();
        $this->load->view('csvindex', $data);
    }
 
    function importcsv() {
        $data['addressbook'] = $this->csv_model->get_addressbook();
        $data['error'] = '';    //initialize image upload error array to empty
 
        $config['upload_path'] = './uploads/';
        $config['allowed_types'] = 'csv';
        $config['max_size'] = '1000';
 
        $this->load->library('upload', $config);
 
 
        // If upload failed, display error
        if (!$this->upload->do_upload()) {
            $data['error'] = $this->upload->display_errors();
 
            $this->load->view('csvindex', $data);
        } else {
            $file_data = $this->upload->data();
            $file_path =  './uploads/'.$file_data['file_name'];
            
            if ($this->csvimport->get_array($file_path)) {
                $csv_array = $this->csvimport->get_array($file_path);
                foreach ($csv_array as $row) {
                    $insert_data = array(
                        'firstname'=>$row['firstname'],
                        'lastname'=>$row['lastname'],
                        'phone'=>$row['phone'],
                        'email'=>$row['email'],
                    );
                    $this->csv_model->insert_csv($insert_data);
                }
                $this->session->set_flashdata('success', 'Csv Data Imported Succesfully');
                redirect(base_url().'csv');
                //echo "<pre>"; print_r($insert_data);
            } else 
                $data['error'] = "Error occured";
                $this->load->view('csvindex', $data);
            }
            
        } 
 
}
/*END OF FILE*/

Creation of the Interface

Go to your views (application/views) folder and create file called csvindex.php Add the following code:

<!DOCTYPE HTML>
<html>
    <head>
        <meta charset="utf-8">
        <title>Adddress Book Project</title>
        <link href="<?php echo base_url(); ?>assets/bootstrap/css/bootstrap.css" type="text/css" rel="stylesheet" />
        <link href="<?php echo base_url(); ?>assets/css/styles.css" type="text/css" rel="stylesheet" />
 
        <script src="<?php echo base_url(); ?>assets/js/jquery.js" type="text/javascript"></script>
        <script src="<?php echo base_url(); ?>assets/bootstrap/js/bootstrap.min.js"></script>
    </head>
 
    <body>
 
        <div class="navbar navbar-inverse navbar-fixed-top">
            <div class="navbar-inner">
                <div class="container">
                    <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </a>
                    <a class="brand" href="#">My Address book</a>
                    <div class="nav-collapse collapse">
                        <ul class="nav">
                            <li class="active"><a href="<?php echo base_url(); ?>"><i class="icon-home"></i>Home</a></li>
                            <li><a href="#about">About</a></li>
                        </ul>
                    </div><!--/.nav-collapse -->
                </div>
            </div>
        </div>
 
        <div class="container" style="margin-top:50px">    
             <br>
             
             <?php if (isset($error)): ?>
                <div class="alert alert-error"><?php echo $error; ?></div>
            <?php endif; ?>
            <?php if ($this->session->flashdata('success') == TRUE): ?>
                <div class="alert alert-success"><?php echo $this->session->flashdata('success'); ?></div>
            <?php endif; ?>
             
            <h2>CI Addressbook Import</h2>
                <form method="post" action="<?php echo base_url() ?>csv/importcsv" enctype="multipart/form-data">
                    <input type="file" name="userfile" ><br><br>
                    <input type="submit" name="submit" value="UPLOAD" class="btn btn-primary">
                </form>
            
            <br><br>
            <table class="table table-striped table-hover table-bordered">
                <caption>Address Book List</caption>
                <thead>
                    <tr>
                        <th>First Name</th>
                        <th>Last Name</th>
                        <th>Phone</th>
                        <th>Email</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if ($addressbook == FALSE): ?>
                        <tr><td colspan="4">There are currently No Addresses</td></tr>
                    <?php else: ?>
                        <?php foreach ($addressbook as $row): ?>
                            <tr>
                                <td><?php echo $row['firstname']; ?></td>
                                <td><?php echo $row['lastname']; ?></td>
                                <td><?php echo $row['phone']; ?></td>
                                <td><?php echo $row['email']; ?></td>
                            </tr>
                        <?php endforeach; ?>
                    <?php endif; ?>
                </tbody>
            </table>
 
 
            <hr>
            <footer>
                <p>&copy;My Address Book</p>
            </footer>
 
        </div>
 
 
 
    </body>
</html>

Demo

Explanations

In the model file ci_model.php, on lines 10-17, we queried our address book table to get all address book records. The data retrieved will be displayed in the csvindex.php view. Lines 19-21 contains the query that inserts each row of records into the table.

In the controller file csv.php, on lines 7-8, we loaded the csvimport.php library and csv_model.php model in the CSV class constructor. On lines 11-14, we created a default index method that fetches the address from the database and sends it to the csvindex.php view. On lines 16-53, The "csvimport" method handles the CSV import functionality. First, we initialize the upload error to an empty string, Next, we set some configuration parameters for the file that is uploaded which included the upload location, the allowed file type which is CSV, and the maximum size of an uploaded file. Then we try to upload the file and if it fails we set the error message and call the csvindex.php view to show the error. However, if the upload was successful, we get the file path of the file uploaded, we then call the get_array method of the csvimport library and assign it to a variable called $csv_array. But if the get_array method failed, we show appropriate error in the csvindex.php view. We then loop through the $csv_array variable using the foreach loop. While looping through the $csv_array data, we insert the records one at a time into the addressbook table by calling the insert_csv method of the csv_model class. Once the loop is complete, we then set a session message called "success" and redirect the user to the home page. This success message is then displayed in the home page and the new records inserted are displayed in the table.

Note: The csvimport.php library assumes the first row of your csv file is the column name

In the csvindex.php view, on lines 37 to 39 we check if there is an error message, then we display the error. We also check if there is a session message called "success", then we display the success message. Lines 45-48 displays the upload form. As you can see we set the enctype="multipart/form-data" because it contains file upload. On lines 62-73, we loop through the "addressbook" data and display all the records.

That's the end of this tutorial. I hope this tutorial will help you with what you are looking for.

Enjoy Coding :)

Explore more on this website for more Tutorials and Free Project Source Codes.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

where is the importcsv

where is the importcsv library, i tries running the codes with my "modifications" but it just showed 404 page not found, and that page is the importcsv

csvimport not found

okay so i have downloaded from git the csvimport library and copy and pasted in my application/libraries folder but 404 not found error is still showing, kindly help on this coz im stuck thanks in advance

Error

Just rename file to Csvimport and it's ready to use... ;)

The upload path does not appear to be valid.

The upload path does not appear to be valid. this error keeps occuring when i hit upload button,

Import CSV with multiple tables

I wonder, is it possible to import csv, that is exported sql database with multiple tables, and put it on mysql as multiple tables too? I’ve seen several tutorials and it’s just imports csv with one table. thanks for reply..

Got error

Message: Undefined offset: 1 Filename: libraries/Csvimport.php Line Number: 146

Image Upload

In this template made for csv import here i got a problem... I used an image tag in php file.. but it dosent load the image in the view .. strangely i removed al js and css still the image dosent load.. for checking path i made an html file and it loaded the image... can you please answer my query????

help me

the upload path does not appear to be valid controller : var $upload_dir="template/images/product/"; if($this->form_validation->run() == false) { $this->load->vars($data); $this->load->view('administrator/admin_template'); } else { $config['upload_path']=$this->upload_dir; $config['allowed_types']= 'gif|png|jpg'; $config['max_size']='2048'; $this->load->library('upload',$config); if(!$this->upload->do_upload('img')) { $data['error']=$this->upload->display_errors(); $this->load->vars($data); $this->load->view('administrator/admin_template'); } else { $img=$this->upload->data(); $images=$this->upload_dir.$img['file_name']; $this->product_model-> addProduct($Name,$Mo_ta,$Noi_dung,$Trang_thai,$category2,$Tinh_nang,$Gia,$images); $this->session->set_flashdata('message','Thêm sản phẩm '.$Name.' thành công!'); redirect(base_url().'administrator/product','refresh'); } }

Error uploading file

Hello I tried this code in my machine. I got error during uploading csv file, it says The filetype you are attempting to upload is not allowed. How can i fix this ??

Hello Error Solve pls help me

Got error Message: Undefined offset: 1 Filename: libraries/Csvimport.php Line Number: 146 reply

Unable to load the requested class: excel

error(Unable to load the requested class: excel) or csv i tried by changing the above code for excel from csv. For csv also not working. what to do????? help

Well Done

Thank you very much. With a few changes I was able to upload my database with base information. I included Ion Auth code to validate it was the administrator doing the task.

The upload path does not appear to be valid.

Hi. Can you please help me? How do I set the path to my adminer.php database? Thanks a lot for your help :)

codeigniter

do i really need to change the path in the routes ?

Vertical Bar separator

Missing Loader in functions: $this->load->library('session');

class Csv extends CI_Controller { function __construct() { parent::__construct(); $this->load->model('csv_model'); $this->load->library('csvimport'); } function index() { $this->load->library('session'); $data['addressbook'] = $this->csv_model->get_addressbook(); $this->load->view('csvindex', $data); } function importcsv() { $data['addressbook'] = $this->csv_model->get_addressbook(); $data['error'] = ''; //initialize image upload error array to empty $config['upload_path'] = './uploads/'; $config['allowed_types'] = 'csv'; $config['max_size'] = '1000'; $this->load->library('session'); $this->load->library('upload', $config); // If upload failed, display error if (!$this->upload->do_upload()) { $data['error'] = $this->upload->display_errors(); $this->load->view('csvindex', $data); } else { $file_data = $this->upload->data(); $file_path = './uploads/'.$file_data['file_name']; if ($this->csvimport->get_array($file_path)) { $csv_array = $this->csvimport->get_array($file_path); foreach ($csv_array as $row) { $insert_data = array( 'firstname'=>$row['firstname'], 'lastname'=>$row['lastname'], 'phone'=>$row['phone'], 'email'=>$row['email'], ); $this->csv_model->insert_csv($insert_data); } $this->session->set_flashdata('success', 'Csv Data Imported Succesfully'); redirect(base_url().'csv'); //echo "

"; print_r($insert_data);
            } else
                $data['error'] = "Error occured";
            $this->load->view('csvindex', $data);
        }

    }

The filetype you are attempting to upload is not allowed.

The filetype you are attempting to upload is not allowed... Code is not Working. can you help ..

Csv Data Imported Succesfully

Csv Data Imported Succesfully Thank you ..

The filetype you are attempting to upload is not allowed..

The filetype you are attempting to upload is not allowed... Code is not Working. can you help .

csv