inserting data error

qadeer_ahmad

i have string value ...

$name="Jessica D'Orazio";

as a " ' "present in string i want to inster this value give error.. i can not change this value cos it variable it may contain one or more " ' " in stirng so is there any way i check these and replace with the value which insert easily.....

laserlight

Escape the single quote with addslashes(), or double it.

LarsLai

hi!
i do not not really understand what is your problem??
do you want to change the ' into any other char? then use

str_replace()

if that is not your problem please describe it more accurate.

qadeer_ahmad

thanks to all

i make a function which solve the problem function is

function sreplace($string)
{
$patterns = "/'/";
$replacements = "''";
$string2= preg_replace($patterns, $replacements, $string);
return $string2;
}

$st="The 'quick brown fo'x jumped over' the la'zy do'g.";
$result=sreplace($st);
print $result;

Weedpacket

This could also have been achieved by writing

$st="The 'quick brown fo'x jumped over' the la'zy do'g.";
$result=str_replace("'", "''", $st);
print $result;

as suggested by LarsLi.

qadeer_ahmad

Thanks Weedpacket,,

It's more easy to use.......