Данные в xml+dtd+php=таблица в MySQL

ПРосьба писать кандидатов только с отпытом.

Шаги для реализации

• Decompression of file at URL if required

• Parsing of XML feed to deterrmine structure

• Displays XML structure with snippets of data from each entity

• Creates list of fields with Unique matching names of XML Entities aligned with

XML structure as shown

• Always adds Date, DateStamp, and LineNumber Fields to List

• Column Names can be edited

• Onchange of any name field--

• Validates name is Unique and complies with MySQL guidelines for Column

Names

• Only Column Names that are checked are carried over to the next page

Structure Page Features:

• Creates Suggested TableName using Name of Datafeed

• Creates Suggested structure for Columns based on sample parse of XML

• Creates list of fields with Unique matching names of XML Entities

• Data Type choices are Option Lists with only MySql Data Types included

• Suggests Primary Key if data suggests-- or selects LineNumber as Primary if data

does not suggest, and adds LineNumber Column if not already included

• Onchange of any name field--

• Validates name is Unique and complies with MySQL guidelines for Column

Names

• Onchange of any attribute field--

• Validates attribute complies with MySQL guidelines for Data Type referenced

• $useDB Option List Includes Databases currently available for Modification

• On Create--Validate Everything Again! No Mistakes allowed.

• Form MySQL query for table creation and submit. There should be No Error messages.

Пример dtd

----------------------