edit an html file on a database

I'm creating a simple dynamic website that includes html files from a
database (MySql), saved as medium blob.
Everything works fine, but now i'd like to create a web interface to
edit this blobl files on the database. Is it possible? Should I use
strings instead of blobs on the database?

any idea or link to some tutorial would be great.

thanks
Snaggy

re: edit an html file on a database

"Snaggy" <l.cioria@gmail.comwrote in message
news:1161435405.359109.84780@h48g2000cwc.googlegro ups.com...I assume it is the htnl file itself that you want to edit, and not the
presentation of the html file and doing it graphically.

Why not simply have a form with a text area that you populate with the
contents of the select query. Edit that text area on the page and have a
submit button produce update into the database?

Shelly

re: edit an html file on a database

I did it! I know it's simple, but this is my first attempt with mysql.
I used blob and it worked well.

thanks

re: edit an html file on a database

It works, but I have a problem.
I submit the data through the syntax

myfile.php?textbox=..........
with myfile.php handling the database

But if the text in the textarea is too long it doesn't work. There must
be some other ways to do this.
ideas?

bye

re: edit an html file on a database

It works, but I have a problem.do not use the get method for submitting the form. Use the post method. Post
can handle more data.