How to import data from csv file to MySQL with PHP

Playing with csv files to migrate data is one of the essential skill you must develop if you are a web programmer. Ini this tutorial, i will share to you how you can upload data from csv files into MySQL database using PHP code.

Kindly download below source code and test it on your own!

Comments

Post a Comment

Popular posts from this blog

How to learn data structure effectively

Step 1 : Learn the theory and fundamentals Understand top fundamental topics covered in data structures such as: Algorithms, Arrays, Collections, Complexity Analysis, Graphs, Hashtables, Heaps, Linked Lists, Queues, Recursion, Search, Sort, Stacks, Trees You can checkout these websites to help cover fundamentals: www.geeks4geeks.com  - explains all the high level fundamentals www.beehyve.io/data-structures  — student crowdsourced resources and community for any topic in CS including Data Structures Time complexity resources [BeeHyve]Time Complexity Cheat Sheet https://visualgo.net/en  - has visualizations of a lot of helpful algorithms Here are more schools that have DS classes which you may find helpful: CS 226 Algorithms and Data Structures Brown CS 16 Introduction to Algorithms and Data Structures Stanford CS 166 Data Structures CMU CSE 15-211 Fundamental Data Structures and Algorithms University of Washington at St. Louis CSE 241 Algorithms and Data Struct
Read more

How to resolve some issue while Installing Moodle Ubuntu 16.04 using Xampp

How to resolve moodle fresh installation issue :  mysql_full_unicode_support#File_format and mysql_full_unicode_support#Large_prefix 1. Go to /opt/lampp/etc then edit my.cnf to add below code [client] default-character-set = utf8mb4 [mysqld] innodb_file_format = Barracuda innodb_file_per_table = 1 innodb_large_prefix character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci skip-character-set-client-handshake [mysql] default-character-set = utf8mb4    2. Restart Xampp      
Read more

How to change phpmyadmin URL in Xampp Ubuntu and how to solve 'New Security Concept while accessing Phpmyadmin - Xampp' ?

Image
How to change Xampp phpmyadmin URL ini Ubuntu 1. Open file  httpd-xampp.conf   which is located in directory  /opt/lampp/etc/extra/ with your text editor or type in your terminal: sudo nano /opt/lampp/etc/extra/httpd-xampp.conf 2. Change line Alias with your desired path. In below sample, I change my phpadmin url to: localhost/myanothersql How to solve 'New Security Concept' while accessing Phpmyadmin - Xampp ubuntu: Type in your terminal : sudo nano /opt/lampp/etc/extra/httpd-xampp.conf edit line : Require local to Require all granted
Read more