Codeigniter 4 MySQL AJAX CRUD Example

Codeigniter 4 CRUD In this tutorial I am going to show how to build CRUD (Create Read Update Delete) application using Codeigniter 4 and MySQL database using basic AJAX (Asynchronous JavaScript and XML) technique. I won’t use AJAX technique for all four operations, i.e., fetching (Read), saving (Create), updating and deleting. Out of these four operations, I will use AJAX…

CodeIgniter 4 Filters Example

Introduction In this tutorial, I will discuss about how to work with CodeIgniter 4 filters. These filters are controller filters. Controller Filters allow you to perform actions either before or after the controllers execute. Unlike events, you can choose the specific URIs in which the filters will be applied to. Incoming filters may modify the Request while after filters can…

CodeIgniter 4 MySQL Login Logout Example

Introduction This tutorial is about CodeIgniter 4 MySQL Login Logout example with MySQL database version 8. I will use CodeIgniter’s session library to store logged in user’s data. The session data get destroyed as soon as user logs out of the application. I am also going to create a custom config to use a key or variable across the application….

CodeIgniter 4 Generate PDF Report

Introduction The tutorial, CodeIgniter 4 Generate PDF Report will show you how to fetch data from MySQL database and generate PDF document using CodeIgniter 4 framework. Here I am going to use how to use TCPDF third party library with CodeIgniter 4 framework to put data into pdf document. CodeIgniter framework does not provide any built-in facility to generate pdf…

CodeIgniter 4 Generate HTML Table Data

Introduction The tutorial, CodeIgniter 4 Generate HTML Table will show you how to fetch data from MySQL database and generate HTML data using CodeIgniter 4 framework. You generally iterate through a list of records and put them into an HTML table for displaying to end users. But here I am going to show you how to use CodeIgniter 4 framework…

How To Prevent SQL Injections In CodeIgniter 4

Introduction It is necessary to prevent malicious code injection in your application and one of the injections is SQL injection. Here I am going to show you how to prevent SQL injections in CodeIgniter 4 based applications. A SQL injection attack consists of insertion of a SQL statement into your application via user input data. This malicious input is sent…

CodeIgniter 4 MySQL AJAX Nested Comment System

The example CodeIgniter 4 MySQL AJAX nested comment system will show you how to build a threaded comment system using PHP based web framework CodeIgniter 4, MySQL 8 and jQuery with AJAX technique. This nested comment system is also called hierarchical comment system. This threaded or nested comment system in PHP AJAX accepts reply up to maximum of five level…

CodeIgniter 4 MySQL 8 CRUD Example

Introduction Codeigniter 4 MySQL 8 CRUD example will show you how you can build an application that performs CRUD operations using PHP based framework Codeigniter. CRUD is an acronym that stands for Create Read Update and Delete operations. It’s almost in every application that has user management system will need basic CRUD operations. Related Posts CRUD Example using Codeigniter 4…

CodeIgniter 4 Transaction Example

Introduction Here I am going to show you an example on CodeIgniter 4 transaction using MySQL database server. You know that transaction is an important part of persistence storage system because you may save, update or delete data from persistence storage any time. When you perform execution of multiple statement across different database or tables or any external system then…

Sort MySQL Table Data in Ascending or Descending Order in CodeIgniter 4

In this tutorial I am going to show you how to sort MySQL table data in ascending or descending order to display them on HTML table on user interface (UI) using Codeigniter 4. I had also shown similar example using CodeIgniter 3. So when a user wants to see the data on UI either in ascending or descending order then…