Use php variable in mysql field

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!

Docs/$CompID/ and Acc/$AccID/ are examples of the type of data in $cat['dir']. When I was trying to use str_replace I changed them to Docs/{$CompID}/ and Acc/{$AccID}/... — Alan
– Alan, Commented Aug 22, 2012 at 5:17

Mihai Iorga · Accepted Answer · 2012-08-22 05:25:23Z

2

You can use eval()

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

edited Aug 22, 2012 at 5:25

answered Aug 22, 2012 at 5:18

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

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

3 Comments

Alan Over a year ago

This works if I save the variable into another one like this: $dir=$cat['dir']; eval("\$str = \"$dir\";"); echo $str; But not like this: eval("\$str = \"$cat['dir']\";"); echo $str; Any idea why?

Cole Tobin Over a year ago

Oh yah forgot my PHP quotes stuff. That's funny

Alan Over a year ago

Acc/$AccID/ is the value of $cat['dir']. Works like eval("\$str = \"$cat[dir]\";"); Thanks!!

Cole Tobin · Accepted Answer · 2012-08-22 05:16:40Z

1

If I am correct you variable would look like this: var. You can access $var with $$cat["dir"]. However, if you db variable looks like $var, just use a simple substring to remove the $.

answered Aug 22, 2012 at 5:16

Cole Tobin

9,44815 gold badges52 silver badges77 bronze badges

2 Comments

Alan Over a year ago

I tried this, but it only worked if the php variable was the only thing in the Mysql field. When there is text along with the variable in the field, it to use the entire value as a variable.

Alan Over a year ago

This is really great to know, though!! I will definitely keep this in mind, though, when the entire Mysql field is a php variable!

Collectives™ on Stack Overflow

Use php variable in mysql field

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related