Skip to main content

Render CSV and Insert Data into Database Using PHP - #26

Published: August 03, 2020 | DevDrawer

Estimated Reading Time
2 minutes
Video Duration
18:14 minutes

Become a Patreon to show support and get exclusive access to content:

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:

WAMP v3.2.0:

Computer Hardware:

Windows 10 Pro: (Amazon)

Samsung 500GB External SSD: (Amazon)

Samsung 970 EVO Plus SSD 1TB - M.2 NVMe: (Amazon)

Rosewill Hive-750S R750W PSU: (Amazon)

Phanteks Eclipse Tempered Glass Case: (Amazon)

MSI Arsenal Gaming AMD Ryzen Motherboard: (Amazon)

MSI Gaming GeForce RTX 2060 Super 8GB: (Amazon)

LG 34UM69G-B 34-Inch 21:9 UltraWide IPS Monitor: (Amazon)

Corsair 64GB (4 x 16GB) DDR4 Memory: (Amazon)

AMD Ryzen 7 2700X Processor: (Amazon)

Dell XPS 15 9500 15.6" Laptop / Windows: (Amazon)

Lenovo ThinkPad T15 15.6" Laptop / Linux: (Amazon)


Fujifilm X-T3: (Amazon)

Fujinon XF18-55mmF2.8-4: (Amazon)


Audio Technica AT2020: (Amazon)

Blue Snowball iCE: (Amazon)


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 and affiliated sites.