A PHP question -- inserting code from SQL

[daj]

For all you PHP gurus out there...I wish to read some data from an SQL table and have the result as part of the HTML page

Getting the data from SQL is fine, and I can then "echo" the result. However if the result contains HTML/PHP code itself I would like PHP to process it first.

Example, the returned field from SQL contains this text

Code: Select all

<b>Testing</b> <?php echo "123"; ?>

When the HTML page is shown I get

Testing Where as I want Testing 123

I thought if I used the eval() rather than echo, but no

I am sure I am missing something really simple!

(I know this is not a PHP forum, but we have some good guys on here)

[daj]

I think I have answered it myself. I did spend about 30 mins on Google this morning on this, but gave up, wrote this post, had a break and started searching again....

So I do use the eval function but I need to close my PHP tag first

Code: Select all

eval (" ?>" . $row['message'] );

Initially I did not have the " ?>", but I can see it makes sense now to close the PHP first rather than throw a mix of html & php into an alreafy open php!

[beteljuice]

Why are you using eval when there are php / sql interfaces / queries ?

[daj]

Hi 'Bet',

Can you explain further?

I used eval() as I need the PHP processor to process my SQL inserted data, and not just treat it as plain text that it throws onto the page.

is there a better way?

[beteljuice]

Not my bag, I work with flat files, but I am under the impression that there are some direct php 'interfaces' to mysql, and the ability to pass mysql command syntax.