Sorry I am new to this but I have uploaded a excel spreadsheet into phpmyadmin to create tables and then I have done a XML dump of the data base. I know want to use that XML file and implement it into Google maps API but im struggling here.. Any suggestions would be great!
This is how my XML file looks:
<pre><?xml version="1.0" encoding="UTF-8"?> <!-- - phpMyAdmin XML Dump - version 4.1.14.8 - http://www.phpmyadmin.net - - Host: infongd5473 - Generation Time: Nov 08, 2015 at 09:43 PM - Server version: 5.5.46-0+deb7u1 - PHP Version: 5.4.45-0+deb7u2 --> -<pma_xml_export xmlns:pma="http://www.phpmyadmin.net/some_doc_url/" version="1.0"> <!-- - Structure schemas --> -<pma:structure_schemas> -<pma:database charset="latin1" collation="latin1_swedish_ci" name="db599909206"> <pma:table name="transport_questions"> CREATE TABLE `transport_questions` ( `Question` varchar(72) CHARACTER SET utf8 NOT NULL, `Year` varchar(72) CHARACTER SET utf8 NOT NULL, `Area` varchar(72) CHARACTER SET utf8 NOT NULL, `Percentage` varchar(72) CHARACTER SET utf8 NOT NULL, `Latitude` varchar(72) CHARACTER SET utf8 NOT NULL, `Longitude` varchar(72) CHARACTER SET utf8 NOT NULL, `Location` varchar(72) CHARACTER SET utf8 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; </pma:table> </pma:database> </pma:structure_schemas> <!-- - Database: 'db599909206' --> -<database name="db599909206"> <!-- Table transport_questions --> -<table name="transport_questions"> <column name="Question">% respondents who go to work (as driver) by car</column> <column name="Year">2013</column> <column name="Area">Ashley</column> <column name="Percentage">25.3</column> <column name="Latitude">51.46619</column> <column name="Longitude">-2.583456</column> <column name="Location">(51.46619 -2.583456)</column> </table> -<table name="transport_questions"> <column name="Question">% respondents who go to work (as passenger) by car</column> <column name="Year">2013</column> <column name="Area">Ashley</column> <column name="Percentage">3.7</column> <column name="Latitude">51.46619</column> <column name="Longitude">-2.583456</column> <column name="Location">(51.46619 -2.583456)</column> </table> -<table name="transport_questions"> <column name="Question">% respondents who go to work by another mode</column> <column name="Year">2013</column> <column name="Area">Ashley</column> <column name="Percentage">0</column> <column name="Latitude">51.46619</column> <column name="Longitude">-2.583456</column> <column name="Location">(51.46619 -2.583456)</column> </table> -<table name="transport_questions"> <column name="Question">% respondents who go to work by bus</column> <column name="Year">2013</column> <column name="Area">Ashley</column> <column name="Percentage">10.9</column> <column name="Latitude">51.46619</column> <column name="Longitude">-2.583456</column> <column name="Location">(51.46619 -2.583456)</column> </table> -<table name="transport_questions"> <column name="Question">% respondents who go to work by car</column> <column name="Year">2013</column> <column name="Area">Ashley</column> <column name="Percentage">29</column> <column name="Latitude">51.46619</column> <column name="Longitude">-2.583456</column> <column name="Location">(51.46619 -2.583456)</column> </table> <code>
No comments:
Post a Comment