XML to MySql table
Hello, in my last post I asked how to show XML/XSLT in PHP which was very simple:-
<?php
header("Content-type: text/xml");
readfile("birds.xml");
?>This isn't that useful, what i now realise is that i want to put the XML file into a MySql table (without the use of Navicat or something similar). I assume this can be done without the use of XSLT and the XML data can be directly inserted into a table. Can anyone help?
Thankyou
Don
'You'll just have to turn this opportunity YES'
The XML:-
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="birds.xsl" ?>
Golden oriole
Oriolus oriolus
Summer
9-42
85
Sparrowhawk
Accipiter nisus
Resident
34,500
0
Siskin
Carduelis spinus
Resident/Winter
310,000
0
Hoopoe
Upupa epops
Passage
Occasional
100