如何使用PHP将XML字符串中的值插入到mysql中？

I am attempting to read and parse an XML file with the following code however I'm running int several issues the first issue is that the state variable and other known populated variables are not importing into the MYSQL table, not sure why. All my tables and columns are varchar(255). I am attempting to read and parse an XML file w