Ezilon.com - Target Your Audience, be Seen in Your Region

XML to MySql table

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.

They have: 18 posts

Joined: Mar 2006

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"?>
http://www.altova.com) -->
<?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

Subscribe to this feed: Syndicate content