Resolving PHP in a database entry

toddthalimer

Hi all-

I was wondering if anyone had experience with this scenario:

I have a PHP page that upon execution retrieves a text entry from a MySQL database. In the entry I have embedded PHP that I would also like resolved (blah blah <?php functionCall() ?> blah blah), however since the page had already been executed, I get the embedded PHP written out to the screen. Is there anyway to have that PHP executed and included into the page?

I understand this would require two PHP executions, one for the page to get the DB entry, and one to resolve the PHP in the DB entry, but how would one go about that?

Thanks!
Todd.

bastien

use the file functions to open and write to a new page, creating a new php page on the fly
use the [man]eval/man function to eval the data, could also try output buffering

hth

Norman_Graham

Yes, I've been pondering this one. One further question, however: when you use the eval() function, do you have to ereg/preg to isolate the <?php codecodecode ?> bit or can you just write the entire database entry to a variable and eval() will operate on the bit that is actually php code? It would be nice if the latter were the case.

I'd be very grateful for an answer to this one. I find the eval() explanation at phpnet somewhat obtuse.

Thanks

Norman

superwormy

The documentation for eval() in the manual SUCKS. I think this might be what you need:


<?php

$mycode = " <html><body> text text text <?php print ('hello world!'); ?> more text more text more text </body></html>";

eval ("?>" . $mycode . "<?php");

?>