#24993 [Opn]: Suggestion for DOM - creating XML documents with structure from a recordset

ID: 24993 Updated by: chregu@php.net Reported By: kris_beyers at hotmail dot com Status: Open Bug Type: Feature/Change Request Operating System: WindowsXP PHP Version: 4.3.2 New Comment: This can easily be implemented in PHP code and will not go into the extension at all Or look at XML_sql2xml in pear, it does something like that. Although not based on a DTD Previous Comments: ------------------------------------------------------------------------ [2003-08-08 21:06:00] kris_beyers at hotmail dot com Description: ------------ Hi All, It's not really a bug, but suggestion.. couldn't find a post address for that :oS I just came up a nice suggestion for the XML DOM.. Now we still program with loops to give the rows, comming from the database-table, to DOM. Whereupon DOM creates an XML document.. like this example http://forums.devshed.com/archive/5/2003/02/3/52511 I was wondering if we could DOM do the transformation from a recordset directly to XML data, using a DTD (or XSD) file for the structure. DOM itself would look for the column names(or even synonyms of column names) in the recordset itself and match them with the names found in the DTD (or XSD) file, an error will occur if one name is not found. When there are multiple rows, DOM will loop to process each row. The validation of data types should still occur only during design time. This way the loops in the serverscript are gone :o) I know Microsoft has something like that, but they don't use DTD (or XSD) or other to build a structure.. Hope you like the idea. With kind regards Kris Beyers ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=24993&edit=1