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

Web/сайты Прочее

Был(а) онлайн: 14.10.18 17:17
Umen 24 года

1.0 Был(а) онлайн: 14.10.18 17:17

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

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

• 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
----------------------
<!ELEMENT Catalog ( Category* ) >
<!ELEMENT Category ( Name, Site*, Category* ) >
<!ELEMENT Commission ( #PCDATA ) >
<!ELEMENT Description ( #PCDATA ) >
<!ELEMENT EarnedPerSale ( #PCDATA ) >
<!ELEMENT Gravity ( #PCDATA ) >
<!ELEMENT Id ( #PCDATA ) >
<!ELEMENT Name ( #PCDATA ) >
<!ELEMENT PercentPerSale ( #PCDATA ) >
<!ELEMENT PopularityRank ( #PCDATA ) >
<!ELEMENT Referred ( #PCDATA ) >
<!ELEMENT Site ( Commission? | Description+ | EarnedPerSale? | Gravity? | Id+ | PercentPerSale? | PopularityRank+ | Referred? | Title+ )* >
<!ELEMENT Title ( #PCDATA ) >
----------------------------
полное задание + пример xml высылается

Точка старта
http://www.phpclasses.org/browse/file/2610.html

Чтобы добавить заявку к этому заказу, нужно войти или зарегистрироваться

Мой блок

14.10.18 17:17
Umen 24