Render CSV and Insert Data into Database Using PHP

Veröffentlicht am: 01 Januar 1970
auf dem Kanal: Dev Drawer

506

Become a Patreon to show support and get exclusive access to content: / 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

`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````
Subscribe: https://bit.ly/2Wbsnj9
`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

Join us on our blog for video recaps and other tutorials: https://thedevdrawer.com
Become a fan on Twitter: / thedevdrawer

Applications Used
Visual Studio Code v1.43: https://code.visualstudio.com/
WAMP v3.2.0: http://www.wampserver.com/en/
#php #phptutorial #development #code #programming #webdesign Gear I Use

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.
View Project on GitHub: https://github.com/thedevdrawer

Auf dieser Seite können Sie das Online-Video Render CSV and Insert Data into Database Using PHP mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Dev Drawer 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 506 Mal angesehen und es wurde von 16 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!