How to insert string with dollar sign ($) into mysql table?

[colap]

$_SERVER['argv'][1'] = "$GGGabcd";
$query = "insert into table1 (str) VALUES(' " . $_SERVER['argv'][1] . " ')";

 

It's a string that starts with a dollar sign. So how can i insert this string into mysql table with php?

How can i escape or something to add that string with $ (dollar) ?

[trq]

There is nothing special about a $ sign. Do you have an actual problem?

[DavidAM]

mySql does not treat the $-sign specially. However, if you happen to have a PHP variable named $GGGabcd (you should change the name to something meaningful), PHP will interpret the variable when you include it in a double-quoted string. Use single quotes:

 

$_SERVER['argv']['1'] = '$GGGabcd';

 

[salathe]

…if you happen to have a PHP variable named $GGGabcd…

 

Variable interpolation will still occur regardless of whether the variable exists or not.

 

---

php-coder, as DavidAM showed you should be using single-quotes around that string (or backslash-escaping the dollar).

[DavidAM]

@salathe: I did not realize that. I almost never use double-quoted strings. But I see you are correct, this code produces an "Undefined variable" notice. Yet another reason to avoid double-quoted strings. And to make sure error reporting is on during development.

[colap]

There is nothing special about a $ sign. Do you have an actual problem?

PHP interprets the string starting with dollar sign as variable. So it doesn't insert that string into mysql table.

[trq]

yeah, I missed the fact that you had it within double quotes.