Results of reading contactsbare.xml
Plain text version

Name:Mr Fred Bloggs
NicknameBloggsie
Home Address:5 Any Street, Little Town, Anyshire, as plain text. UK
Home Phoneas text
Home Faxnone
Personal Mobile444
Personal site:www.codehelp.co.uk
Business Address:Floor 24, BigShot Tower, Anycity. Anyshire, text. UK
Work Phonetext
Work Fax555
Business Mobile333
Company:Full name of company here
Gender:male
Children:Make sure this tag is one of the ones allowed to repeat in the DTD
Birthday: (YYYY-MM-DD)Add tags for year, month and day to make this more useful
Anniversary: (YYYY-MM-DD)some date long forgotten :-)
Spouse:angry
email:Either use fixed tags like this, or change to a repeating tag
email:second email line
email:third
email:fourth
Notes: comments here



SQL: Example of how to create a SQL statement from the XML data.

Replace ?????????? with insert or update etc.

?????????? contacts values (NULL, "Fred", "Bloggs", "Bloggsie", "Mr", "5 Any Street", "Little Town", "Anyshire", "as plain text", "UK", "as text", "none", "444", "www.codehelp.co.uk", "Full name of company here", "Floor 24, BigShot Tower", "Anycity", "Anyshire", "text", "UK", "text", "555", "333", "", "male", "Add tags for year, month and day to make this more useful", "some date long forgotten :-)", "angry", "Make sure this tag is one of the ones allowed to repeat in the DTD", "comments here", "Either use fixed tags like this, or change to a repeating tag", "second email line", "third", "fourth")

Using code from the MySQL pages, this data could be automatically inserted into appropriate SQL tables, direct from the XML.


Back


Neil Williams:
e-mail meinfo@codehelp.co.uk