How To Import Excel and CSV File Using CodeIgniter – onlinecode
In this post we will give you information about How To Import Excel and CSV File Using CodeIgniter – onlinecode. Hear we will give you detail about How To Import Excel and CSV File 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 import Excel and CSV File Using CodeIgniter. so let’s discuss Import 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 import 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 import 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 PhpExcel Library. then we will use that third party Library for Codeigniter excel import.Step 4: Create ControllerIn this step, we will create an Import.php file in the “application/controller” directory and paste the below code in this controller.application/controller/Import.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Import extends CI_Controller {
function __construct() {
parent::__construct();
$this->load->database();
$this->load->model('import_model');
}
public function index(){
$query = $this->db->query('SELECT * from register ORDER BY id desc');
$records = $query->result_array();
$data['user_data'] = $records;
$this->load->view('excel_file_upload',$data);
}
public function uploadData()
{
if ($this->input->post('submit'))
{
$path = 'uploads/';
require_once APPPATH . "/third_party/PHPExcel.php";
$config['upload_path'] = $path;
$config['allowed_types'] = 'xlsx|xls';
$config['remove_spaces'] = TRUE;
$this->load->library('upload', $config);
$this->upload->initialize($config);
if (!$this->upload->do_upload('uploadFile')) {
$error = array('error' => $this->upload->display_errors());
} else {
$data = array('upload_data' => $this->upload->data());
}
if(empty($error)){
if (!empty($data['upload_data']['file_name'])) {
$import_xls_file = $data['upload_data']['file_name'];
} else {
$import_xls_file = 0;
}
$inputFileName = $path . $import_xls_file;
try {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
$flag = true;
$i=0;
foreach ($allDataInSheet as $value) {
if($flag){
$flag =false;
continue;
}
$inserdata[$i]['first_name'] = $value['A'];
$inserdata[$i]['last_name'] = $value['B'];
$inserdata[$i]['address'] = $value['C'];
$inserdata[$i]['email'] = $value['D'];
$inserdata[$i]['mobile'] = $value['E'];
$i++;
}
$result = $this->import_model->importdata($inserdata);
if($result){
echo "Imported successfully";
}else{
echo "ERROR !";
}
} catch (Exception $e) {
die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME)
. '": ' .$e->getMessage());
}
}else{
echo $error['error'];
}
$this->load->view('excel_file_upload');
}
}
?>Step 5: Create a ModelIn this step, we will create an Import_model.php file in the “application/models” directory and paste the below code in this model.application/models/Import_model.php
<?php
if (!defined('BASEPATH'))
exit('No direct script access allowed');
class Import_model extends CI_Model {
public function importData($data) {
$res = $this->db->insert_batch('register',$data);
if($res){
return TRUE;
}else{
return FALSE;
}
}
}
?>
Step 6: Create View FileSo finally, we will create the excel_file_upload.php file in the “application/views/” directory and make a form with google Recaptcha code in HTML.application/views/excel_file_upload.php
<!DOCTYPE html>
<html lang="en">
<head>
<title>How To Import 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 Import</h2></div>
<div > </div>
<div ><button type="button" data-toggle="modal" data-target="#importModal">Import</button></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>
<!-- Modal -->
<div id="importModal" role="dialog">
<div >
<!-- Modal content-->
<div >
<div >
<button type="button" data-dismiss="modal">×</button>
<h4 >Upload Csv file</h4>
</div>
<div >
<form action="<?php echo base_url();?>import/uploadData" method="post" enctype="multipart/form-data">
<div >
<div >
<input type="file" name="uploadFile" id="uploadFile" data-icon="false">
</div>
</div>
<div >
<input type="submit" value="Upload file" id="upload_btn">
</div>
</form>
</div>
<div >
<button type="button" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</body>
</html>Hope this code and post will helped you for implement How To Import Excel and CSV File 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