Roy Tutorials

Introduction In this shell programming example, I am going to show you how to delete backup files automatically using shell script cron job. So, I will create a shell script in Unix programming and setup a cron job to automate the delete process. This automatic job will save your manual efforts of deleting files from the folders. You don’t need…

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 REST API Client In this tutorial I will show you how to call or consume external REST APIs in CodeIgniter 4 framework. REST is an acronym that stands for Representational State Transfer. I had shown how to build REST API CRUD Example earlier but here I am going to show an example on CodeIgniter 4 consume REST APIs….

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

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…

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…

Introduction In this tutorial I am going to explain how to load third party libraries (or library) in CodeIgniter 4 framework. The third-party libraries are placed under app/ThirdParty folder in CodeIgniter 4 framework. You may need to use third party libraries while you are building applications using CodeIgniter 4 framework. For example, you may want to purify HTML output, you…

Web Site Backup Here I am going to show you how to setup auto backup web site files using shell script cron job. In the world of web, it is recommended that you take care of your web site files by taking backups of them frequently. If anything goes wrong so that you can take an appropriate action on your…

Introduction In the tutorial, Spring NamedParameterJdbcTemplate and MapSqlParameterSource Example, I had shown how to save new record in the database and how to fetch record from database. Here I am going to show you how to mock Spring JdbcNamedParameterTemplate SqlParameterSource with Junit Mockito. I am going to use Junit 5 framework for this example. I am also using Mockito framework…

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…