SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Threaded View

  1. #1
    SitePoint Wizard gold trophysilver trophy
    Join Date
    Nov 2000
    Location
    Switzerland
    Posts
    2,479
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    adodb Database Description to XML Schema

    Just wondering if anyone has any experience of adodb, in particular how good it is as describing databases, such as the data type of a column.

    Using the MySQL functions, you have mysql_fetch_field() which returns an object describing the column.

    The reason why? Well been toying with XML Schemas and was wondering idily; "How hard would it be to examine a table or database and create an XML schema from it?"

    Once you have a schema from a database, you have something to generate things like HTML forms on the fly, with the help of a little XSL. You also have a basis for building a navigation system for your data, generating XML from the queries, slapping XSL over the top.

    All it would take is a cunning mechanism for defining XSL Templates (any ideas?) and PHP will rule the world! mwhuhahaahahahaha!
    Attached Images Attached Images


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •