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 Apache POI is the most popular library when comes to manipulate word, excel, ppt based documents. In this example I am going to show you how to read large excel file using Apache POI library. Your large excel file may contain various kind of information, such as, Human Resource data, Sales data, Credit Cards,…

Posted in Excel File Java

How To Read Large Excel File Using Apache POI

Introduction Here I am going to show you how to use AJAX in Django framework and how to upload files using Django jQuery and AJAX. This example can be used to upload both single and multiple files to the server. Only thing is you need to select single file if you want to upload only…

Posted in AJAX Django File Upload jQuery

How to upload Files using Django jQuery and AJAX

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