[RESOLVED] Convert/Format email addrs - Silly little thing

[fuzzy1]

I feel silly, but this thing has been kickin my backside all day.
Should be OH SO SIMPLE. Thought I had it licked -- but nooo.

I just want to convert "Name" and "[e-mail]"
to a single string "Name<[e-mail]>"
for insertion into a single column in mysql db.

That's it. That's all....

Echoed in html the following returns TJ McDonald<[e-mail]> but inserts as TJ McDonald &lt;[e-mail]&gt; Sadly, after countless variations on the following this is as close as I've managed to get.

$cust_email ='[e-mail]';
$FULL_NAME = "TJ McDonald";
//$cust_email =$focus->billing_address_email;
	$to_add_str = htmlspecialchars("<$cust_email>", ENT_COMPAT);
	$to_addrs_emails = $FULL_NAME . '' . $to_add_str;
echo $to_addrs_emails;

[NogDog]

That's what htmlspecialchars() does: converts characters such as "<" and ">" that have special HTML significance into their HTML character entities. For storing in your database, I would not bother with the htmlspecialchars(), just build the string and then use the applicable function to make it safe for your SQL statement:

$to_addrs_emails = mysql_real_escape_string("$FULL_NAME <$cust_email>");

[fuzzy1]

This also resolved my next pending issue:
How to insert the email body text along with the rest.
I tried all freaky manor of escaping the string and then...
Ta Da! Introducing -- mysql_real_escape_string -- just what I needed!

Man I owe you a six pack AT LEAST -- TWICE EVEN!
Thanks Again NogDog,

Regards,
TJ

[NogDog]

Yuengling "Black and Tan", please. 😉