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

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

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.

Posted in Codeigniter MySQL

Codeigniter – Select Unique Random Row Every Day From MySQL

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…

Posted in Django

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

Here we will see how to connect to MySQL database server using Python in different ways. We need to install mysql-connector-python module to connect to MySQL database from Python programming language. We will create the connection objects in different ways and using this connection object we will be able to connect to MySQL server.

Posted in MySQL Python

How to connect to MySQL database using Python in different ways

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…

Posted in MySQL

Installing MySQL 8 Zip Archive in Windows

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…

Posted in File Upload jQuery MySQL PHP

Save Files to MySQL 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…

Posted in PHP

MySQL Database Backup using PHP

This tutorial will show you how to login to an application with remember me functionality. Sometimes you 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…

Posted in MySQL PHP

PHP MySQL Login Logout with Remember Me

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…

Posted in MySQL PHP

Infinite dynamic Multi-level nested category with PHP and MySQL

Introduction This tutorial shows database connection example in PHP and MySQL. Here I 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…

Posted in MySQL PHP

Database Connection Example In PHP and MySQL