where_in condition in Codeigniter
The where_in method allows you to specify multiple values in a WHERE clause. Generates a WHERE field IN (‘item’, ‘item’) SQL query joined with AND if appropriate Let’s create a where_in method in codeigniter
Category: Codeigniter
How to get latitude and longitude from google map using Codeigniter
In this article, you’ll know how to get latitude and longitude from address using Google Maps API in Codeigniter. Here we’ll combine all code into a Codeigniter function and you only need to use this function to find latitude and longitude from an address. You can need first create API PHP Code And if you […]
DATE_FORMAT in CodeIgniter
The date_format() function returns a date formatted according to the specified format. Let’s create a date_format() in where condition using CodeIgniter.
How to integrate jQuery Fullcalendar using Codeigniter and MySQL
Today, I would like to share with you integration of jQuery full calendar events using Codeigniter and MySQL. Fullcalendar is jquery library that provide us to display calendar with events and more. Fullcalendar js provide year, month, week and day calendar for displaying. If you are working on event management, task management or any thing […]
How to get Average value in MySQL table column using Codeigniter
Codeigniter provides the select_avg method to get the average value in the MySQL table column. Writes a “SELECT AVG(field)” portion for your query. As with select_max(), You can optionally include a second parameter to rename the resulting field. Let’s create a select_avg method in codeigniter
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 […]
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 […]