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

Continue

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 the same thing here. As a prerequisite you need to go through the django setup tutorial before going down further.

Continue

Installing MySQL 8 Zip Archive in Windows

Introduction 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 is not required for your application then it would be easier to remove the zip version of MySQL installation any time. You do not need to check in the registry…

Continue

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 entire file then the preferred method would be to put the file into server’s file system and save the file path into the database. However in situations, where an application…

Continue

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 application which will help you to take backup as per your wish whenever you want to take backup. While most web hosting company do a daily backup of a customer’s…

Continue

PHP MySQL Login Logout with Remember Me

This tutorial will show you how to login to an application with remember me functionality. Sometimes we need to remember username and password for few days or years so that next time onward a user can login without entering the username and password into the input fields. The username and password fields get populated automatically from the cookie where the username and password are kept for few days or years. An http cookie is a small piece of data sent from a website and stored on the user’s computer by…

Continue

Infinite dynamic Multi-level nested category with PHP and MySQL

Introduction I am going to show you how to build infinite dynamic multi level nested category with PHP and MySQL server. Here I will show example of infinite level of categories and subcategories on the fly from a MySQL database. So I am going to give an example on infinite multi level nested category with PHP and MySQL. Related Posts: Infinite dynamic Multi-level nested category with Codeigniter and MySQL

Continue

Database connection example in PHP and MySQL

Introduction This tutorial shows database connection example in PHP and MySQL. Here we will create a PHP file with commonly used functions on how to connect to MySQL database using PHP. It is mandatory to establish database connection when you are working on a dynamic application. The database may be any one of your choice or according to the requirement of your application. Here I am going to use MySQL database to serve the purpose. I have used here mysqli_* function to show a database connection example in PHP and…

Continue