I have exported an XML from phpmyAdmin. I want to imported it back to MySQL by using PHP code. How can i do it? And here is Exported XML
<?xml version="1.0" encoding="utf-8"?>
<!--
- phpMyAdmin XML Dump
- version 4.1.14
- http://www.phpmyadmin.net
-
- Host: 127.0.0.1
- Generation Time: Dec 30, 2015 at 03:18 AM
- Server version: 5.6.17
- PHP Version: 5.5.12
-->
<pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
<!--
- Structure schemas
-->
<pma:structure_schemas>
<pma:database name="projectx" collation="latin1_swedish_ci" charset="latin1">
<pma:table name="i_tariff_block">
CREATE TABLE `i_tariff_block` (
`Client_Name` char(255) NOT NULL DEFAULT '',
`Document_No` char(10) NOT NULL DEFAULT '',
`Doc_Type` char(10) NOT NULL DEFAULT '',
`Line_No` int(3) NOT NULL DEFAULT '0',
`Block_Tariff` decimal(14,2) DEFAULT NULL,
`Consumption` decimal(14,2) DEFAULT NULL,
`Rate` decimal(14,2) DEFAULT NULL,
`Amount` decimal(14,2) DEFAULT NULL,
`Create_Date` date DEFAULT NULL,
`Create_Time` time DEFAULT NULL,
`Create_By` char(10) DEFAULT NULL,
`Change_Date` date DEFAULT NULL,
`Change_Time` time DEFAULT NULL,
`Change_By` char(10) DEFAULT NULL,
PRIMARY KEY (`Client_Name`,`Document_No`,`Doc_Type`,`Line_No`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</pma:table>
</pma:database>
</pma:structure_schemas>
<!--
- Database: 'projectx'
-->
<database name="projectx">
<!-- Table i_tariff_block -->
<table name="i_tariff_block">
<column name="Client_Name">ABA10</column>
<column name="Document_No">2841033814</column>
<column name="Doc_Type">I</column>
<column name="Line_No">1</column>
<column name="Block_Tariff">200.00</column>
<column name="Consumption">200.00</column>
<column name="Rate">0.00</column>
<column name="Amount">44.00</column>
<column name="Create_Date">NULL</column>
<column name="Create_Time">NULL</column>
<column name="Create_By">NULL</column>
<column name="Change_Date">NULL</column>
<column name="Change_Time">NULL</column>
<column name="Change_By">NULL</column>
</table>
</database>
</pma_xml_export>