How to parse xml file into mysql table using php?

Question

PHP

I'm not good with php, so I'm asking for help.
The structure of the xml file looks like this:

<column name="id">...</column> 
  <column name="title">....</column> 
  <column name="parent">95</column> 
  <column name="id_group">50</column> 
  <column name="hide">0</column> 
  <column name="parent_field">13</column> 
  <column name="filename">...</column> 
  <column name="isfilename">1</column> 
  <column name="id_rmapo">...</column> 
  <column name="cycle_students">...</column> 
  <column name="cycle_type">..</column> 
  <column name="cycle_money" /> 
  <column name="cycle_cert">0</column> 
  <column name="cycle_employment">.</colu..mn> 
  <column name="cycle_duration">1</column> 
  <column name="cycle_from">...</column> 
  <column name="cycle_to">....</column> 
  <column name="cycle_quantity">..</column> 
  <column name="cycle_year">2017</column>

The table itself

Answer 1

An approximate algorithm that does not take into account your system, connection to the database, etc.:
This is the simplest option. If there are a lot of entries in the file, you need to collect requests for n requests in step 3 and insert them into the database in a batch. But it's out of necessity