Storing/running php in mysql

[Ell360]

Hey,

 

I am a bit of a noob at php/mysql and trying to be clever(emphasis on trying).

 

I want to pull some php/html code from a database in mysql, whilst it does display the html, the php does not.

Can this even be done? Is it going to cause me issues later on?

 

[code=php:0]
<?php
    $query = "SELECT * FROM pages";
    $result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
$body = $row["body"];
echo $body;
    }?>

[/code]

 

Any help would really be appreciated.

 

Ell

[fortnox007]

I assume it can be done. What is your script to put stuff in the database. It could very well be that the script is stripping valuable stuff.

[AbraCadaver]

It doesn't display or it doesn't execute?

[Andy-H]

<?php
    $query = "SELECT * FROM pages";
    $result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
$body = $row["body"];
eval("$body");
    }?>

 

eval

[Ell360]

Hey,

 

Wow, thanks all for speedy replies!

 

eval() seems to have done it.

 

Thank you!

 

 

 

[fortnox007]

I assume you would never want to give others than admins access to this right? Seems kinda scary if people can upload php to execute later

[Ell360]

Yea, hopefully it should be ok when finished... *crosses fingers*  .

 

I wrote the code and then inserted it straight into mysql, I wanted to test it before I before I did anymore and found out that I couldn't do it this way.