Category: MySQL

Introduction In this example, I am going to discuss about how to work with Python flask caching. Flask is a Python based light-weight web frameworks. Flask framework provides an extension called Flask-Caching that adds caching supports for various backends to any flask applications. You can also develop your own caching system by extending the flask_caching.backends.base.BaseCache…

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

Introduction This tutorial will show you how to run PHP web applications without external server. So, you don’t need to use external server when you are developing or building your PHP based web applications in your development or local environment. I will show you here both how to run standalone PHP file and PHP web…

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 You might have seen the error in CodeIgniter 4: The framework needs the following extension(s) installed and loaded: curl, intl. I will show you how here to solve this problem. This problem generally you will find in PHP based CodeIgniter 4 web framework in your environment when you try to run your application using…

In this tutorial I am going to show you how to configure PHP, MySQL, Apache HTTP Server for developing PHP based web applications. You may create PHP based standalone applications or web based applications and you want to run them in development environment before deploying into the production or live environment. I will also show…

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 example I am going to show you how to call stored procedure in CodeIgniter 4. CodeIgniter 4 is a PHP based light weight web based framework for rapid application development. In this example I am going to use MySQL database server for storing data.