Parsing PHP from a MySQL entry

insomniac123

How do you do it? 😃

I have some code, such as

while($x<8) { $x=$x+1; etc...; }

sitting in a MySQL row entry. I need to be able to process the code from within PHP at run-time. I feel stupid for asking this because I know it would be a simple solution, but I can't seem to figure it out. Any kind soul know how to do this?

Thanks,
Andrew.

insomniac123

3 minutes after posting I find the answer 🙂

eval :rolleyes:

George_W__Bush

Can you please share with us the answer? I am also curios. Thanks!

Morg

I am also needing a solution to this problem. In my case, I'm building a database driven website using MySQL and PHP. In one of the MYSQL fields, I have the html for the content of the site, and in that HTML, I am using a php include function.

Unfortunately, it won't parse the php code. In fact, if I view source of the file from the browser, it clearly shows the php code buried in with the rest of the html.

So, how can I get PHP to parse from a MySQL table?

leatherback

Hi,

He gave the info already, it is the function eval() you ar elooking for.

Morg

DOH!

:::knocks self on noodle:::

Thanks very much! I missed that little bit. 😃

Morg

Ok, I've been trying to figure this out for the better part of a day. I've plowed over the threads I could find on the eval() function for a good hour, but I'm just not getting it.

As I understand it, once I put PHP code into a MySQL table, it comes out as a string, NOT code. Right?

So the eval function sort of "forces" the php code to be parsed?

So in my database table I have a bunch of html like this:

<p align="center">My Database Tables</p>
blah blah

<?php
require ("menu.php");
?>
<br />
<p align="center">More HTML script</p>

What this does is completely ignores the php code (it's not visible from the browser, but does show up when you View Source.)

So, do I need to eval the entire code, or just the bit that calls the require function?

The only thing I've managed to produce so far is a bunch of semicolons, quotes, and close brackets... :mad:

Thanks to any who take me by the hand on this one. I'm yanking my hair out! 😉

Morg

Chandler bing! (maybe...)

Up till now, I've been trying to make the php parse from the database file. Should I instead be placing the eval() code on the template page that the database querie gets called to??

If my logic is sound (but it's probably not) the databse sends the php code (an include function in this case) as a string to the template page. So what I need to be doing is grabbign that string, and then executing it from the template page.

So my page that displays the db query would look something like this:

<html>
<head>
<All the DB connection code here>
</head>
<body>
<?php 
eval (<? php include('pageXYZ.php'); ?>);
?>

<?php
echo "$row[content]";
?>
</body>
</html>