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…

Posted in MySQL PHP

Run PHP Web Applications Without External Server

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…

Posted in AJAX Codeigniter jQuery MySQL

CodeIgniter 4 MySQL AJAX Nested Comment System

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…

Posted in Codeigniter MySQL

CodeIgniter 4 MySQL 8 CRUD Example

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…

Posted in Codeigniter MySQL

CodeIgniter 4 Error – framework needs extensions curl, intl

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…

Posted in htaccess MySQL PHP Server

How To Configure PHP, MySQL, Apache HTTP Server

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…

Posted in Codeigniter MySQL

CodeIgniter 4 Transaction Example

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.

Posted in Codeigniter MySQL

How to call Stored Procedure in CodeIgniter 4

In this tutorial I am going to show you how to build CRUD application using CodeIgniter 4, MySQL and React JS framework. CRUD is an acronym that stands for Create, Read, Update and Delete operations in a particular application. So you are basically creating a record, reading single or all records, updating the existing record…

Posted in Codeigniter MySQL React JS

React CRUD Example with CodeIgniter 4 and MySQL 8

In this tutorial I am going to show you how you can build an online visitor tracking system using PHP based framework CodeIgniter 4, MySQL 8 and AJAX technique. The similar system for tracking online visitors on web site, I built in past, using CodeIgniter 3 framework. As a web site owner you would like…

Posted in AJAX Codeigniter jQuery MySQL

Online Visitor Tracking System using CodeIgniter 4, MySQL 8 and AJAX

You might encounter the following issue while executing an SQL query qith Group By clause in MySQL database server. Error Type: mysqli_sql_exception #1055 Error Details: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘roytuts.visitors.access_date’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible…

Posted in MySQL

SELECT list is not in GROUP BY clause and contains nonaggregated column – mysqli_sql_exception #1055

In this tutorial I am going to show you an example on deploying Spring Boot application to Heroku cloud. I will create a basic CRUD application with Spring Boot Data JPA and PostgreSQL/MySQL technologies. I will first show you how to perform CRUD operations locally, then deploy the same application in the Heroku cloud with…

Posted in Cloud Heroku MySQL Spring Boot

How to deploy Spring Boot Data JPA Application to Heroku Cloud

This example will show you how to delete or eliminate duplicate records from a table in database. Keeping duplicate records in a table is unnecessary and it also grows the size of database unnecessary. Removing duplicate records from the table will free the occupied space and enhance also the performance of the query execution. Let’s…

Posted in Database MySQL

How to delete Duplicate Records from MySQL Table