Tag: codeigniter mysql

Introduction Here I am going to build an example on how to select multiple rows from HTML table and delete these multiple selected table rows from MySQL database using CodeIgniter 4 with the help of AJAX technique in jQuery. In this tutorial I am going to fetch all records from the MySQL database and displaying…

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…

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…

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…

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…

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….

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…