How to export data in excel and CSV Files Using CodeIgniter – onlinecode

How to export data in excel and CSV Files Using CodeIgniter – onlinecode

In this post we will give you information about How to export data in excel and CSV Files Using CodeIgniter – onlinecode. Hear we will give you detail about How to export data in excel and CSV Files Using CodeIgniter – onlinecodeAnd how to use it also give you demo for it if it is necessary.

Today, In this tutorial, we will be explaining how to export Excel and CSV File Using CodeIgniter. so let’s discuss Export Excel and CSV File.

It’s also very helpful in such as if you want to backup of data and you have data of CSV file then you can export the data into the database.

CSV extension stands for “Comma Separated Values” and contains all data in comma-separated. Normally, we have large data and need to export data into the database that time we use the following file types.

Overview

Step 1: Create a Database in tableStep 2: Connect to DatabaseStep 3: Download PhpExcel LibraryStep 4: Create ControllerStep 5: Create a ModelStep 6: Create View File

Step 1: Create a Database in tableIn this step, we have to create a table in the database, so we will create a database using the below code.

CREATE TABLE IF NOT EXISTS 'register' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'first_name' varchar(64) NOT NULL,
  'last_name' varchar(64) NOT NULL,
  'address' text NOT NULL,
  'email' varchar(64) NOT NULL,
  'mobile' varchar(12) NOT NULL,
  PRIMARY KEY ('id')
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

Step 2: Connect to DatabaseGo to the config folder and open database.php file some changes in this file like hostname, database username, database password, and database name.

$db['default'] = array(
	'dsn'	=> '',
	'hostname' => 'localhost',
	'username' => 'root',
	'password' => '',
	'database' => 'enter here database name',
	'dbdriver' => 'mysqli',
	'dbprefix' => '',
	'pconnect' => FALSE,
	'db_debug' => (ENVIRONMENT !== 'production'),
	'cache_on' => FALSE,
	'cachedir' => '',
	'char_set' => 'utf8',
	'dbcollat' => 'utf8_general_ci',
	'swap_pre' => '',
	'encrypt' => FALSE,
	'compress' => FALSE,
	'stricton' => FALSE,
	'failover' => array(),
	'save_queries' => TRUE
);

Step 3: Download PhpExcel LibraryFirst, we need to Download Download PhpExcel Library. then we will use that third party Library for Codeigniter excel export.Step 4: Create ControllerIn this step, we will create an Export.php file in the “application/controller” directory and paste the below code in this controller.application/controller/Export.php

<?php
 
defined('BASEPATH') OR exit('No direct script access allowed');
 
class Export extends CI_Controller {
    // construct
    public function __construct() {
        parent::__construct();
        // load model
        $this->load->model('Export_model');
    }    
 
    public function index() {
        $data['export_list'] = $this->export->exportList();
        $this->load->view('export_excel_file', $data);
    }
	
    public function create_excel() {
        // create file name
        $fileName = 'data-'.time().'.xlsx';  
        // load excel library
        $this->load->library('excel');
        $listInfo = $this->Export_model->getUsers();
        $objPHPExcel = new PHPExcel();
        $objPHPExcel->setActiveSheetIndex(0);
        // set Header
        $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'First Name');
        $objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Last Name');
        $objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Address');
        $objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Email');
        $objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Mobile');       
        // set Row
        $rowCount = 2;
        foreach ($listInfo as $list) {
            $objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $list->first_name);
            $objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, $list->last_name);
            $objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount, $list->address);
            $objPHPExcel->getActiveSheet()->SetCellValue('D' . $rowCount, $list->email);
            $objPHPExcel->getActiveSheet()->SetCellValue('E' . $rowCount, $list->mobile);
            $rowCount++;
        }
        $filename = "file". date("Y-m-d-H-i-s").".csv";
        header('Content-Type: application/vnd.ms-excel'); 
        header('Content-Disposition: attachment;filename="'.$filename.'"');
        header('Cache-Control: max-age=0'); 
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');  
        $objWriter->save('php://output'); 
    }     
}
?>

Step 5: Create a ModelIn this step, we will create an Export_model.php file in the “application/models” directory and paste the below code in this model.application/models/Export_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
 
    class Export_model extends CI_Model {
 
        public function __construct()
        {
            $this->load->database();
        }
        
        public function getUsers() {
            $this->db->select('*');
            $this->db->from('register');
            $query = $this->db->get();
            return $query->result_array();
        }
    }
?>

 

Step 6: Create View FileSo finally, we will create the export_excel_file.php file in the “application/views/” directory and make a form with google Recaptcha code in HTML.application/views/export_excel_file.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>How To Export Excel and CSV File Using CodeIgniter - onlinecode</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
</head>
<body>

<div  style="margin-top:50px;">
  <div >
	<div ><h2>CodeIgniter excel Export</h2></div>
	<div ><a href="<?php base_url()?>export/create_excel" >Export</a></div>
	<div ></div>
  </div>  
  <table >
    <thead>
      <tr>
        <th>Id</th>
        <th>Firstname</th>
        <th>Lastname</th>
        <th>Address</th>
        <th>Email</th>
        <th>Mobile</th>
      </tr>
    </thead>
    <tbody>
	<?php
	foreach($user_data as $row) {
	?>
      <tr>
        <td><?php echo $row['id'];?></td>
        <td><?php echo $row['first_name'];?></td>
        <td><?php echo $row['last_name'];?></td>
        <td><?php echo $row['email'];?></td>
        <td><?php echo $row['phone'];?></td>
        <td><?php echo $row['created'];?></td>
      </tr>
	<?php 
	} ?>	
    </tbody>
  </table>
</div>
</body>
</html>

Please follow and like us:

Hope this code and post will helped you for implement How to export data in excel and CSV Files Using CodeIgniter – onlinecode. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Leave a Comment

Your email address will not be published. Required fields are marked *

87  +    =  91

We're accepting well-written guest posts and this is a great opportunity to collaborate : Contact US