" ' " problem once again

[valen53]

" ' " problem, actually i have test to insert " ' " into mysql and mssql, mysql was accept " ' " , but mssql was come out error, mssql cannot recognice " \' " but mysql can be inserted.

so, anyone know about insert " ' " into mssql ?
i have try addslashes() and htmlspecialchars() also cannot work. so any other method can introduce ??
thank reply

[jassh]

hi there..

i think addslashes should work..

correct me if im wrong,
but you are trying to add data such as mc'guyver
to your mssql.. right??

in case it's a name..
you should do it like this...

$name = addslashes($name);

$query = "INSERT INTO your_table (your_data) VALUES ('$name')";

$result = mysql_db_query('your_database', $query) or die(mysql_error());

from my small time experience,
anything with a " ' " in the name will be entered with a slash
example if $name = "mc'guyver";
then in you db will look like mc/'guyver

hope that helps..

• jassh

p/s: ko budak kay el ker??

[laserlight]

I think that mssql uses an additional single quote to escape a single quote.
Anyway, if you wanted to use htmlspecialchars, then you should use:

$text = htmlspecialchars($text, ENT_QUOTES);

[rklapwijk]

or simply use this function:

$text = repchars($text);

function repchars($var) {
$name = mysql_escape_string(htmlspecialchars(stripslashes($var)));
return $var;
}

echo $text;

[valen53]

function repchars($var) {
$name = mysql_escape_string(htmlspecialchars(stripslashes($var)));
return $var;

actually the " mysql_escape_string" was function in mysql but not for mssql. mssql doesn't contain this function yet.
thank to reply.