auto replace variables from DB

shelbytll

Hi,
I tried the following:

$HISNAME = "Admin";
$rs=$cn->Execute("select Message from msg");
print $rs->fields[0];

Actual Output:
Hi $HISNAME, how are you?

Desired Output:

Hi Admin, how are you?

What i was tring to do is to store the variable into a table and hopefully get replaced when it printed out. However, it doesn't. Is there any function I could use for example stripslashes() or htmlentities() or something similiar. OR i have to do it manually? Means str_replace("\$HISNAME",$HISNAME,$rs->fields[0]);

Mordecai

Try using something like [HISNAME] instead. However, when you escape the dollar sign, it should work. Does it not? If not, what error do you get, if anything?

jayant

u can do what said.

use:

eval("\$mystr = ".$rs->fields[0]);
echo $mystr;

shelbytll

Hi,
the point is, I do not want to do it manually.
Currently, I'm doing it this way and it works fine:

$message = $rs->fields[0];
$message = str_replace("\$HISNAME",$HISNAME,$message);
$message = str_replace("\$HISPWD",$HISPWD,$message);
$message = str_replace("\$HISUSERID",$HISUSERID,$message);

I was hoping there is a short cut that auto read those variables that were previously gotten from the FORM.

jayant

Originally posted by shelbytll
Hi,
the point is, I do not want to do it manually.
Currently, I'm doing it this way and it works fine:

$message = $rs->fields[0];
$message = str_replace("\$HISNAME",$HISNAME,$message);
$message = str_replace("\$HISPWD",$HISPWD,$message);
$message = str_replace("\$HISUSERID",$HISUSERID,$message);

the point is, I have food in front of me. I don't want it eat it myself. I want it automatically go into my stomach.
thats a height of laziness. 😃

Originally posted by shelbytll
I was hoping there is a short cut that auto read those variables that were previously gotten from the FORM.

remember, there r no shortcuts in life.

shelbytll

😃 😃 😃