can we store php code in Mysql

[Anon]

The idea is to store php code in the Mysql database, so we can have as little php code outside the db.

Question is ,can this be done?
and how do we retrieve this code from the db so that it will be executed?

Thanks all

[Anon]

I'm doing the same thing right now. Its very easy. Depending on what kind of code you want to store you could either use a "blob" field or a "text" field.

To retrieve all you would do is perform a "select" statement. It would probably be a good idea to use an auto_increment id-like field but that's all your call.

With some PHP and HTML you could even read your files in from an HTML form.

[tasistro]

Just to finish off...

after all the select sql and mysql_fetch_array etc..

eval($sql_row["mycode"]);

Saludos
Gerardo

PS, very bad for security... imagine if you dbase crashes and the result get corrupted.....