How to import excel, read data from excel file using a PHPExcel in Codeigniter

In this tutorial, we will learn how to import or read an Excel sheet of data and insert it into the database using PHPExcel in Codeigniter Library. For that, we will create a Database to insert excel data into a table, a form to make a view to upload an excel sheet, and also create […]

Like Query in Codeigniter

This tutorial shows you how to write like query in Codeigniter. Like clause is used in ‘SELECT Query’ to search for the matching pattern in columns. The operator is part of the where clause and employs wildcard character (%) to search for the matching string. Let’s create a like method in codeigniter If you use […]

How to Login with Facebook in CodeIgniter

Integrate Facebook login is the most used feature for today’s web application. Login with Facebook feature helps users to log into the web application easily. In this tutorial, we’re going to explain how to integrate Facebook login in CodeIgniter using Facebook PHP SDK with Facebook Graph API. Step 1: Config (application/config/autoload.php) Step 2: Config (application/config/facebook.php) […]

How to create flash messages in Codeigniter

Let me explain about the CodeIgniter session flash message. It’s a temporarily stored value working as a session. This coding used to set success messages and failure messages through your controller. Let start to learn how to create a CodeIgniter session flash message. Flash session set code work with your controller functions. Session response code […]

Multi-Select Dropdown with Checkbox using jQuery

In this article, we’ll make the multi-select dropdown more user-friendly and provide a simple way to implement multiple select or multi-select dropdown lists with a checkbox using jQuery. jQuery MultiSelect is a jQuery plugin that turns a multiselect list into a nice dropdown list with checkboxes. This plugin is easy to use and very useful […]

How to Create Dynamic Excel File Using PHPExcel Library in Codeigniter

In this tutorial, we will learn how to create an excel file in PHP Codeigniter with help of the PHP excel library. The data of Excel will come through the MySQL database. Extract the zip file using winzip or winrar and save the phpexcel folder under the codeigniter application directory (application/third_party/(save paste your phpexcel folder […]