PHP object to insert XML into a MySQL database

PHP object to insert XML into a MySQL database I require a PHP class/object to be written. I want to pass it a database object/instance, table name, an ASCII string which would contain an XML file, and a child element name. The class would then take the XML field values from within the element specified and insert them into the specified SQL table. The XML format may change, so it is important that the object processes whatever fields it can, and doesn’t stop working when it gets to a field name in the XML which does not have a corresponding database table or field. It should NOT create any new fields in the database – but output an error and continue processing whatever fields it can. An XML element may contain more than one entry (i.e. ‘Person’ in the example below). The class should loop over all the ‘Person’ elements, creating a new row for each person. Where a child element contains repeated values (i.e. ‘emails’ in the example below), then these should be recorded in a second table which is called the same name as passed to the object, but with -emails appended to the name. i.e. $XML_file: <?xml version="1.0" encoding="utf-8"?> <Version>123</Version> <Color>Blue</Color> <PeopleArray> <Person> <Name>Fred</Name> <Surname>Bloggs</Surname> <emails> <email>fred@[login to view URL]</email> <email>fred@[login to view URL]</email> </emails> </Person> <Person> <Name>Jo</Name> <Surname>Smith</Surname> <emails></emails> </Person> <Person> <Name>Mike</Name> <Surname>Jones</Surname> <emails> <email>mike@[login to view URL]</email> <email>mike@[login to view URL]</email> <email>mike@[login to view URL]</email> </emails> <phones> <phonenumber>123456</phonenumber> <phonenumber>987654</phonenumber> </phones> </Person> </PeopleArray> Input: $example = new ProcessXML($dbObj, Customers, $XML_file, PeopleArray) $result = $example->execute(); echo ‘Warnings’.$result Output: Inserts the following data into a table called ‘Customers’ with the following field names: UniqueID, Name, Surname 1, Fred, Bloggs 2, Jo, Smith 3, Mike, Jones Inserts the following data into a table called ‘Customers-emails’ with the following field names: UniqueID, email 1, fred@[login to view URL] 1, fred@[login to view URL] 3, mike@[login to view URL] 3, mike@[login to view URL] 3, mike@[login to view URL] Inserts the following data into a table called ‘Customers-phones’ with the following field names: UniqueID, phonenumber 3, 123456 3, 987654 If errors occur, i.e., a field didn’t exist in the table, then a descriptive warning should be returned. Must be written using the following software versions: • MySQL v 5.7 • PHP v7.1 (use PDO to query the SQL database, not MySQLi) No deprecated features/functions to be used. Code to be well commented in English. Variable and object names to be relevant and in English.