using variables stored in mysql text

Question

i have a situation where i need to be able to store variables from mysql. the pages i am creating are dynamic and contain different user data, what im chasing is the following

//stored in user database
$firstname = "BOB"
$lastname = "MARLEY"

//how i want th content from a mysql database to display in html
hello my name is BOB MARLEY

//how it displays at the moment
hello my name is $firstname $lastname

i cant seem to work it out at all

this is my current database code

<?php
        $firstname= "BOB";
        $lastnamename= "marley";
    $get_content= mysqli_query($con,"SELECT * FROM tbl_forms_content WHERE forms_content_formid='1' LIMIT 1 ");
    while($found_content = mysqli_fetch_array($get_content))
    { 
        echo $found_content['forms_content_content'];
    }   
?>

any help is greatly apreciated

for a start it should be $found_content['firstname'] assuming thats already in the db? — user557846
– user557846, Commented Jan 11, 2015 at 23:03
Why do you set firstname and lastnamename in the while loop rather than using the db results? — JAL
– JAL, Commented Jan 11, 2015 at 23:04

MrMarlow · Accepted Answer · 2015-01-12 08:26:17Z

2

The simplest way would be to str_replace them out;

echo str_replace(array('$firstname', '$lastname'), array($firstname, $lastname), $found_content['forms_content_content']);

Can see a working example here; http://codepad.org/xFEowbMZ

edited Jan 12, 2015 at 8:26

answered Jan 11, 2015 at 23:24

MrMarlow

8564 silver badges17 bronze badges

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

1 Comment

ecnepsnai Over a year ago

Way better solution than using eval() +1

Barmar · Accepted Answer · 2015-01-11 23:18:23Z

0

The right solution is to use a template library. To do what you're trying, you need to use eval:

$firstname= "BOB";
$lastname= "marley";
while($found_content = mysqli_fetch_array($get_content))
{ 
    eval ('echo "' . $found_content['forms_content_content'] . '";');
}

This is very dangerous. If the database contains values that can be set by the user, they could execute any PHP code from it.

edited Jan 11, 2015 at 23:18

answered Jan 11, 2015 at 23:07

Barmar

789k57 gold badges554 silver badges669 bronze badges

6 Comments

deceze Over a year ago

I don't think eval can be used without (). Though it would look a lot better.

Barmar Over a year ago

It needed a semicolon in the argument to eval(), try it now.

Nathan Over a year ago

yep thats working now, :-) obviously this isnt really recommend but this is for some dynamic pdf forms, is there any other solutions to get the same result

user557846 Over a year ago

firstname db field, lastname db field

Nathan Over a year ago

when running this in php works fine when running inside fpdf it just executes and doesnt display the pdf document just html

|

Collectives™ on Stack Overflow

using variables stored in mysql text

2 Answers 2

1 Comment

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related