embed variable in longtext data [duplicate]

Question

Is it possible to embed variable in a longtext field?

For instance:

description(field): The date is $date_var

in PHP:

$date_var = date('m/d/Y');
echo $row['description'];

Output:

The date is 10/13/2012

Please advise.

Answer 1

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

$str = "The date is %s"

echo sprintf($str, date('m/y/d'));

Or use str_replace/preg_replace. Don't use eval, especially on some data from a DB.