[Resolved] Getting PHP Variables Out of SQL text string

ClevaTreva

I have the following text in a mySQL text field (an example - not real!):

The color of the apple is $applecolor and it looks good.

I connect to the db and get the field and it is in the array variable

$bodyC['bodypara']

Having defined $applecolor (say as red), I want to print or echo this into HTML. I tried this:

echo $bodyC['bodypara'];

But it doesn't change the variable name into the color, ie it prints the text literally. How do I get PHP to see the variable in the variable and interpret it?

Many thanks in advance for any help 😉

Trevor

tekky

maybe $str = ereg_replace('$applecolor', $applecolor, $str);

tomhath

Or you could "eval" the string. I didn't test this but it should be something like:

 eval ("echo \"" . $bodyC['bodypara'] . "\" ");

http://www.phpbuilder.com/manual/function.eval.php

superwormy


<?php

$var = " this is my html <?php print ("this is my php"); ?> more html! ";

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

?>

www.php.net/eval

ClevaTreva

Hi tomhath

The eval function WAS what I was looking for - just couldn't remember 😃

Originally posted by tomhath
Or you could "eval" the string. I didn't test this but it should be something like:
 eval ("echo \"" . $bodyC['bodypara'] . "\" ");
http://www.phpbuilder.com/manual/function.eval.php [/B]

The actual code needed to be:

eval ("echo \"".$bodyC['bodypara']."\";");

(spot the additional semi-colon, without which the echo doesn't work)

Great help folks, much appreciated. :p

Trevor