Introduction Here I will show you how to do benchmarking Codeigniter application. The benchmark information may help you during development for debugging and optimization for the application code. CodeIgniter has a Benchmarking class that is always active (class is initialized automatically), enabling the time difference between any two marked points to be calculated. Doc says, the benchmark is always started…

Introduction Here you will see a simple example on profiling Codeigniter application. The Codeigniter’s Profiler class displays benchmark results, queries you have run and POST data at the bottom of the page. This information may be useful in the development environment for debugging and optimization of your application.

Introduction Here in this tutorial I will show you how to configure Codeigniter 3.1 and SQLite3 in Windows environment. You can choose any database from a number of supported databases in Codeigniter framework but here I am going to use SQLite, which is in-memory database and also fit for quick PoC projects. SQLite a small, fast, self-contained, high-reliability, full-featured, SQL…

Introduction In this post we will see Datatable CRUD example using Codeigniter, MySQL and AJAX. We have seen in our previous post on DataTable using Codeigniter, MySQL and AJAX, where we have the following features: Loading data from MySQL database in HTML table Pagination – each page shows 10 records Searching Filtering Sorting

Introduction Here I am going to show you an example on Codeigniter MySQL Stored Procedure CRUD. You may also read my previous tutorial on Call Stored Procedure using Codeigniter. CRUD means, Create, Read, Update Delete operations. We can perform the similar the CRUD operations by executing individual SQL statement for each operation.

Calendar The example, Bootstrap Calendar Events Demo using Codeigniter 3, will show you how you can show different events set by users on a calendar. It helps users to track easily what all upcoming events are or past events were there by navigating through the calendar dates. Bootstrap Calendar is a reusable jQuery plugin that makes it easier to create an…

Introduction Here we will see Codeigniter REST + ReactJS CRUD example. We have seen previously Codeigniter REST API examples for GET, POST, PUT and DELETE but here we will see them together. We will use ReactJS as a front-end technology to represent our UI. In this example we will use Codeigniter version 3.1.9 and node version 6.11.3 and npm version 3.10.10. We…

Here we will see how to generate excel report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications and it’s easy to work with Codeigniter for building web applications. Why excel reporting? Most people in your organization are likely to be familiar with excel, hence it ensures a short (or nonexistent) learning curve…

Introduction Here you will see how to generate pdf report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications. PDF format reports allows professionals to edit, share, collaborate and ensure the security of the content within digital documents. Reports are mostly generated in PDF format because a PDF file is a “read only”…

Introduction Here is an example showing you how to generate HTML table from MySQL database using Codeigniter. I will write here an example to create a table using CodeIgniter 3 framework from a multi-dimensional array. The CodeIgniter’s Table class provides functions that enable you to auto-generate HTML table data from arrays or database result sets. In this example, I will…