Introduction This example will show you how to insert CSV data into MySQL database table directly. So I am going to create insert SQL statement for inserting data individually or I will also load the csv data directly into the MySQL table. CSV means Comma Separated Value, so it’s a plain text data. Each line…

Posted in MySQL Python

How to insert CSV data into MySQL database using Python in different ways

Introduction Here I will show you how to create infinite multi-level nested categories with Codeigniter and MySQL. In my previous tutorial¬†Infinite dynamic Multi-level nested category with PHP and MySQL , I wrote how to build a nested multilevel categories. So I am again going to write the same tutorial but this time with Codeigniter 3…

Posted in Codeigniter PHP

Infinite dynamic Multi-level nested category with Codeigniter and MySQL

This tutorial shows how to select items randomly from each category in MySQL. So here I will select exactly one item randomly from each category. People who need sometimes to select photo from each photo category and display them on the page for animation purpose will be benefited. In this example I have used two…

Posted in MySQL

Select only one random item from each category in 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…

Posted in MySQL PHP

Infinite dynamic Multi-level nested category with PHP and MySQL