processing mySQL results as PHP

[Anon]

My site currently queries a SQL database which contains the page content - this makes it easy to edit the page with a web browser (which all my users can do) however, I want to include PHP scripts in the pages. If I include php code (e.g. <?php echo $variable; ?> in the field that is stored in the database it is output exactly like that to the browser. What I want to be able to do is to process the data output from the database query as if it was a php script. I realise the security implementations but only a few trusted individuals can edit the database.... I am not JUST echoing variables I need complex "IF" statements in there too and possibly database queries... I know I could make it echo variables using regular expressions... like eregi_replace.

Yours,
Ross McKillop

[Anon]

You could try using the eval() function to have your string evaluated asif it is php.

[Anon]

Thanks - I really should have read the manual pages - D'Oh - RTFM TO MYSELF!!!!

"eval() evaluates the string given in code_str as PHP code. Among other things, this can be useful for storing code in a database text field for later execution. "

which is exactly what I need - but I am from the world of perl (sorry) where eval usually has some connection with maths so I didn't bother looking at it.. Thanks Vincent

Yours,
Ross McKillop
[e-mail]