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

Introduction This example will show you how to insert CSV data into MySQL database table directly. So we are going to create insert SQL statement for inserting data individually or we 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 of the file is data record. Each record consists of one or more fields separated by commas. Each line of data record is terminated by new line.

Continue

Infinite dynamic Multi-level nested category with Codeigniter and MySQL

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 framework. Prerequisites Codeigniter 3.1.11, PHP 7.4.3, MySQL 8.0.17, Apache 2.4

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

Read weather information using yahoo API in PHP, MySQL

Many times we see websites that read weather from an RSS feed on another site, here I will show you how to read weather onto your site from Yahoo. Here we will create example on read weather information using yahoo API in php mysql. How to get the XML from To read the weather from Yahoo API, you need to send a request as follows: http://weather.yahooapis.com/forecastrss?p=INXX0028&u=f where p is the location code. In this tutorial I am using “Calcutta/Kolkata, India”, and as you can see the location code or zip…

Continue