How to import YML format data into mysql database Where to dig?

Question

PHP

I am starting to learn PHP. Faced such task.
There is .YML format data that is available at a specific link.
And there is a ready-made database with cells and so on.
I need to set up a data parser from YML with a link to a database.
Where to dig? Where to start? Maybe someone has a ready-made version as an example, it would be great.
Thanks in advance to everyone for your attention!

Answer 1

First, learn to decompose tasks.
Otherwise, you will have questions like tell me how to get to the store for booze on a Toyota.
When you go to the store, it doesn’t matter what brand your car is.
When you need to add data to the database, it doesn’t matter where you got
it from. When you need to read data from a file, it doesn’t matter what happens to them later.
Therefore, break the task into three parts
- getting a file from a link
- reading a YML file into an array
- writing data from an array to a database
For all three information on the Internet - a wagon.
And do not look for an example sucked from the finger, "tell me how to wear adidas sweatpants bought from my hands in a stall from a Chinese after lunch on Friday."yes just like any other