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 Here we will see how to create CRUD example using SQL scripts in PHP and SQLite3. We can easily execute SQL statement in PHP to perform CRUD operations but when you have lots of SQL statements to create tables then you will find easier to execute SQL scripts rather than executing individual SQL statements one by one in PHP…

Introduction In this tutorial I am going to show you how to configure PHP 7 and SQLite3 in Windows environment. By default SQLite3 extension comes with PHP 5.3.0 or higher version of PHP. So you don’t need to download it. SQLite3 is not enabled by default in Windows environment. So you must enable it before you use it. Why do…

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.

Introduction Here you will see how to read last n lines from a file in PHP, where n could be replaced by any positive integer number, such as, 1, 2, 5, 10 etc. Generally most of the times you may use to read the file in forward direction, i.e., from the beginning of the file and apply some business processing…

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…