How To Configure PHP, MySQL, Apache HTTP Server

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 you how to enable mod_rewrite…

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

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 with sql_mode=only_full_group_by

Codeigniter – Select Unique Random Row Every Day From MySQL

I am going to show how to select a row from MySQL database as randomly as possible, but not repeating it. So I am going to select unique row from the MySQL database using PHP based Codeigniter framework. The original tutorial could be found as selecting a random row every day from MySQL.

How to setup Python based Django framework and MySQL Databse to execute SQL statements

Introduction Here in this tutorial I am going to show you how to setup Python based Django framework and MySQL database server to execute SQL statement in Windows environment. The MySQL server is used as a persistent system for storing data for the application. I have already discussed in my another tutorial how to setup Django, so I won’t repeat…

Installing MySQL 8 Zip Archive in Windows

MySQL In this tutorial you will see here how to install MySQL zip archive in Windows operating system. I will download MySQL community version for showing this example. You will also see how to connect to MySQL server using default user root. The advantage of installing zip archive version of MySQL server is that later if you find this server…

Save Files to MySQL using PHP

I have shown file upload example using PHP in previous tutorials¬†PHP file upload¬†but in this tutorial I will show you how to save the uploaded files to MySQL database using PHP. You may be wonder why you would need to save file content into database rather than just into the file system. In situations where PHP application needs to put…

MySQL Database Backup using PHP

In this tutorial I am going to show you how to take MySQL database backup using PHP programming language. In the world of web it is important to take backup of our site and database frequently. You never know when you would come across unexpected error that may cause your site stop working. Here I will show you in PHP…