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…

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…

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…

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…

Here I am going to show you how to build REST web services in PHP based Codeigniter 4 framework. CodeIgniter 4 is the upcoming version of the framework and it is still under development, intended for use with PHP 7.2 or higher version. REST is an acronym that stands for Representational State Transfer (RESTful), which…

We know that Google chart basically displays different statistical data on different chart types such as column chart, bar chart, line chart, pie chart etc. You can have a look at the URL https://developers.google.com/chart/ for more information. In my previous tutorial https://roytuts.com/google-chart-using-codeigniter/ the year value was always showing as 2k for 2010, 2011, 2012 etc. Now…

Introduction In this tutorial I will show you CodeIgniter join example. I will use CodeIgniter’s Query Builder Class to build join queries for fetching data from multiple tables. The SQL Join clause is used to combine records together from two or more tables in a database. A Join locates related column values in two or…

Introduction This tutorial will show you how to prevent SQL injection in Codeigniter application. It is very important to escape the variable you pass to the database query because, in web application security, SQL injections play an important role. SQL injection is: a malicious code injection technique that may destroy your database. one of the…

File upload example in Codeigniter 2.1.4. There is file upload class, in codeigniter, which permits you to upload the file or files. This class also permits you to set various preferences such as destination where the file will be uploaded, restrition on file types, restriction on file size, whether a file name should be encrypted…