I thought this would be a neat project to learn some PHP. I have a mysql table from a 3rd party app that I would like to create a custom web front end for a moble device to view.
It is a Appointment Schedule MYSQL Table with text string fields and a single XML arrays field. I can now parse the Text string field for a fetch_assoc() into a table. Further Ican seprately use simpleXML() to parse the XML into a table.
The problem is I would like to combine to inforamtion (string\XML fields) into one table to display a daily schedule with a color coded type.
I have a few ideas, but thought you all here might have a suggestion which is better.
My first thought would be to create an XML doc then populate it with the string fields data and add the XML array tags too. Then create the table from the xmldoc.
Other ideas would basically create the table and create a class object to prase the XML for each row in the table. However I would suspect this would be slow.
(Sometimes typing out the options make one sound better, so thanks for allowing me to aks the question.)
