include PHP script from MyQSL database

December 1st, 2008, 12:38 pm

So here's the thing.
I've put my php script into a database as 'longtext' and I want it to be compiled by PHP. Right now it just shows me the script as simple non-compilated text. For example:

Line number On/Off

Code: Select all

1. <?
2. // script to get a row from db with html and php script
3. // the variable that is holding it is $f and it contains something like:
4. // <b><? echo $a; ?></b>
5. $a = 'hello there';
6.  
7. echo $f;
8.  
9. ?>

The output should be

Line number On/Off

Code: Select all

1. <b>hello there</b>

Is that possible to do? Or is there any other way of doing it?

.. or should I simply put that scripts in .php files and use include() ?

December 1st, 2008, 12:51 pm

Oh man ... use include()...

Just the way of thinking to utilize DB engine to store scripts is unappropriated from conceptual POV ...

[joebert]

December 1st, 2008, 1:39 pm

File includes/requires is the way I would go.

Something like XCache can cache the opcode for the file includes, whereas even if you use memcached to reduce the load on the database, you'ld still have to exec() the script every time.

December 1st, 2008, 1:48 pm

Ok, I guess I'll do it with include, thanks for advices.

December 14th, 2008, 10:21 pm

You can also use the eval() function in php to evaluate code.

http://us.php.net/eval