在mysql字段中使用php变量

Question

I have a field in a Mysql table which contains php variable, which is used to determine the directory where a file is stored (ex. Docs/$CompID/ and Acc/$AccID/). The problem is that when I retrieve the value, the php variable name is display instead of the value.

I tried placing quotes around the value -

Both in the Mysql table (Docs/$CompID/" and Docs/".$CompID."/)

and when the php variable is displayed (echo"$dir")

I also tried doing str_replace, putting { } around the variable so that I can identify it in the string:

$start=strrpos($cat['dir'],'{');
$stop=strrpos($cat['dir'],'}');
$rep=substr($cat['dir'],$start+1,$stop-1);
$dir=str_replace("{".$rep."}",$rep,$cat['dir']);

All of these just displayed the php variable name. Any help would be appreciated!

Answer 1

You can use eval()

$AccID = 'me';
eval("\$str = \"Acc/$AccID/\";");
echo $str;