How to display PHP code stored in MySQL Database

Question

I have mysql database with code in 1 of the fields

test test test <?php $_GET['location']; ?>  test test

I am accessing display file test.php?location=abc and displaying that record from database in the following way

 This is my <?php echo $row_display_content['location']; ?>

And the only result I have got is

This is my

have no idea how to make it works, so dynamic values may be displayed inside the text from database

correct, but I would like to display dynamic data in some of the content stored inside database — user974435
– user974435, Commented Mar 1, 2012 at 19:19
Do your dynamic content display programmatically. How do you want php interpreter to understand this This is my <?php echo test test test <?php $_GET['location']; ?> test test; ?>. That is exactly what you are doing — Yanki Twizzy
– Yanki Twizzy, Commented Mar 1, 2012 at 19:21
okay cool, so how do I do This is my <?php echo "test test test $_GET['location'] test test"; ?> — user974435
– user974435, Commented Mar 1, 2012 at 19:28

John Himmelman · Accepted Answer · 2012-03-01 19:32:02Z

4

Use the eval function. Btw, this is a terrible approach to whatever problem you're trying to solve.

http://php.net/manual/en/function.eval.php

Edit:

$code = 'test test test <?php $_GET[\'location\']; ?>  test test';

eval('?>'. $code);

edited Mar 1, 2012 at 19:32

answered Mar 1, 2012 at 19:20

John Himmelman

22.1k22 gold badges68 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user974435 Over a year ago

tried this one already and doesnt work, once you use eval you have got error

GManz Over a year ago

Agreed to this completely. There is countless ways of avoiding using eval. And if you get errors, then there is errors in the eval code rather than anything else.

John Himmelman Over a year ago

@user974435 Try... eval('?> your code <?php echo "blah"; ?>');

user974435 Over a year ago

<?php echo eval('?> $row_display_content['location']; <?php echo "blah"; ?>'); ?>

user974435 Over a year ago

Use the eval function. Btw, this is a terrible approach to whatever problem you're trying to solve. php.net/manual/en/function.eval.php Edit: $code = 'test test test <?php $_GET[\'location\']; ?> test test'; eval('?>'. $code); doesnt work ;( same result

|

Yanki Twizzy · Accepted Answer · 2012-03-01 19:46:13Z

2

Try

echo "This is my ". eval('?>' . $row_display_content[\'location\'] . '<?php ');

answered Mar 1, 2012 at 19:46

Yanki Twizzy

8,0818 gold badges44 silver badges72 bronze badges

Comments

pbond · Accepted Answer · 2012-03-01 19:22:40Z

1

Take a look at eval and you shouldn't include the php tags in your database entry. Furthermore, you should ask yourself if you actually want to store this in your database.

answered Mar 1, 2012 at 19:22

pbond

1,9674 gold badges20 silver badges35 bronze badges

2 Comments

user974435 Over a year ago

doesn't work even once I removed <?php ?> tags form DB same error

user974435 Over a year ago

this is how I used eval <?php echo eval($row_display_content['location']); ?>

Collectives™ on Stack Overflow

How to display PHP code stored in MySQL Database

3 Answers 3

6 Comments

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

2 Comments

Related