Current location: Hot Scripts Forums » Programming Languages » PHP » Need help inserting XML file into MySQL database


Need help inserting XML file into MySQL database

Reply
  #1 (permalink)  
Old 11-06-05, 12:26 PM
expert01 expert01 is offline
New Member
 
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Need help inserting XML file into MySQL database

I have been working with PHP and MySQL for a while, but I've never dealed with XML files. I've been looking for a parser that might do what I'm looking for, but no luck .

Here's the XML file sample I'm working with: http://docs.tms.tribune.com/tech/tms...old_sample.xml

There's a PDF on the XTVD schema: http://docs.tms.tribune.com/tech/tms...Definition.pdf

And an XSD: http://docs.tms.tribune.com/tech/xml...ge/tmsxtvd.xsd


All I'm really looking for is maybe a sample script that parses a script and puts all the information into an array.

(data is from labs.zap2it.com)
Reply With Quote
  #2 (permalink)  
Old 11-07-05, 03:46 AM
nugensoftware's Avatar
nugensoftware nugensoftware is offline
Newbie Coder
 
Join Date: Oct 2005
Location: United States
Posts: 96
Thanks: 0
Thanked 0 Times in 0 Posts
XML Parser Functions
http://us3.php.net/xml

There are a number of examples. The link in my signature is to a news aggregator I wrote in PHP with these functions. After working with it, its actually really simple to use once you understand a few of the key functions.

Anyways - hope that helps, I would post my scripts but it has tons of other stuff going on inside of it that is unrelated.
__________________
Nugen Software Inc.
Lead Developer
www.nugensoftware.com

PHP HELP | MySQL HELP | xmlSYNC
Reply With Quote
  #3 (permalink)  
Old 11-07-05, 10:53 AM
End User's Avatar
End User End User is offline
Level II Curmudgeon
 
Join Date: Dec 2004
Posts: 3,027
Thanks: 14
Thanked 35 Times in 33 Posts
This might work for what you need:

http://freshmeat.net/releases/211258/
__________________
I don't live on the edge, but sometimes I go there to visit.
-------------------------------------------------------------------------
Sanitize Your Data | Oracle Date & Substring Functions | Code Snippet Library | [url=http://www.codmb.com/Call Of Duty[/url]
Reply With Quote
  #4 (permalink)  
Old 11-07-05, 11:25 PM
expert01 expert01 is offline
New Member
 
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Thank you, these should help me
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Flat file vs mysql database Imusion PHP 5 06-13-06 12:10 PM
MySQL database file location jeephp PHP 4 10-29-05 07:40 AM
inserting and retrieving date and time from mysql database stealth04 PHP 5 07-29-04 11:19 AM
Excel document containing records, need to save as a text file to upload to mysql bearslife PHP 1 06-05-04 03:24 AM
how to import a png file from mysql database. rani PHP 1 01-16-04 03:34 AM


All times are GMT -5. The time now is 06:18 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.