Storing HTML data in SQL database

[Anon]

Hi.

I was just wondering - what is the best way to store HTML "objects" in MySQL database?

For example: I have following HTML objects:
- Table
- Image
- Text
- etc.

Every object has it’s own unique ID code. So that if I want to put image to table’s cell, I just put images ID there. Or if I want to put some other table in that cell I just put tables ID there. And so on. Pretty cool I think.

But let’s talk about my problem now: Tables (or any other HTML objects) contain many properties – it can have tens or hundreds rows and columns, each cell can have different properties (bgcolor, align, valign, rowspans) and so on.

HOW to store HTML data in SQL table so that I could easily modify that data with PHP scripts?

Pretty hard-core stuff 🙂)

Best regards,
m.

[melvyn]

Any reason you would want to?

This is exactly where XML/XSL is made for. MySQL really doesn't allow for this, since it can't work with subselects, which is pretty much what you would need.

Alternatively, you might look at some native XML databases.

As long as you write strict than strict HTML it will probably work.