How to deal with ' in oralce SQL?

$text="abcd ' ded";
insert into table_name(tt) values('$text😉;

But It is wrong! and I how to deal with this.
because the $text include ' .

Can you help me?

$text="abcd ' ded";
insert into table_name(tt) values('$text😉;

But It is wrong! and I how to deal with this.
because the $text include ' .

Can you help me?

use addslashes function.
check out php manual on section L.String Function.

this function will make your
$text = "abcd \' ded"

note: check the StripSlashed function too.

Alternatively, try:

$text="abcd ' ded";
$text= str_replace("'", "''", $text);
insert into table_name(tt) values('$text');

This will replace all the occurances of ' with two '' which will be interpreted by oracle as one. Hope that helps!

Chris King