Render CSV and Insert Data into Database Using PHP - #26
2 minutes
18:14 minutes
Become a Patreon to show support and get exclusive access to content: https://www.patreon.com/devdrawer
One question I am often asked is how do I get a large data set from a CSV file to a MySQL database? In this quickie tutorial, I show you how to save down a CSV into a PHP array that you can use to upload to a MySQL database using PHP OOP.
With a few lines of code, you can take massive datasets and turn them into organized database tables.
0:00 Intro
01:28 What is a CSV file
03:33 Setup Your Server to Handle Exports from a Mac
04:16 Getting Started with fgetcsv
06:02 Viewing Your CSV as an Array
06:28 Removing Column Names
07:55 Creating Your Own Array Keys
11:14 Setting Up the MySQLi OOP Functionality
13:01 Creating the OOP Loop for Your Database
16:47 Upcoming: Export for a MySQLi Database to CSV
Applications Used
Visual Studio Code v1.43: https://code.visualstudio.com/
WAMP v3.2.0: http://www.wampserver.com/en/
Computer Hardware:
Windows 10 Pro: https://amzn.to/3q5TyZw (Amazon)
Samsung 500GB External SSD: https://amzn.to/2ViAAAF (Amazon)
Samsung 970 EVO Plus SSD 1TB - M.2 NVMe: https://amzn.to/36jDwDy (Amazon)
Rosewill Hive-750S R750W PSU: https://amzn.to/36jiDbs (Amazon)
Phanteks Eclipse Tempered Glass Case: https://amzn.to/39qou0B (Amazon)
MSI Arsenal Gaming AMD Ryzen Motherboard: https://amzn.to/36hpAKm (Amazon)
MSI Gaming GeForce RTX 2060 Super 8GB: https://amzn.to/36hMyRm (Amazon)
LG 34UM69G-B 34-Inch 21:9 UltraWide IPS Monitor: https://amzn.to/2HSRxyI (Amazon)
Corsair 64GB (4 x 16GB) DDR4 Memory: https://amzn.to/3mlmQkI (Amazon)
AMD Ryzen 7 2700X Processor: https://amzn.to/3qdQIBF (Amazon)
Dell XPS 15 9500 15.6" Laptop / Windows: https://amzn.to/3fKEz2w (Amazon)
Lenovo ThinkPad T15 15.6" Laptop / Linux: https://amzn.to/2Jnmn33 (Amazon)
Camera:
Fujifilm X-T3: https://amzn.to/3llKBb5 (Amazon)
Fujinon XF18-55mmF2.8-4: https://amzn.to/3mfTkNb (Amazon)
Audio:
Audio Technica AT2020: https://amzn.to/2VgxU6K (Amazon)
Blue Snowball iCE: https://amzn.to/3lo1jGC (Amazon)
DISCLAIMERS:
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Like what you see, support the channel.
Get Merch Buy Me A Coffee Join Patreon Watch on YouTube View Projects on GitHub
