trim the string

[smilesmita]

hi there,

i have this:
foreach($data2 as $k=>$v){

    $segs = split("_", $k);

    $cn=$segs[sizeof($segs) - 2];

echo $cn;
$cn printouts out to be like this:

#document

CustomerContext

XpciVersion

ResponseStatusCode

what i want is to get rid of #document completely from this string or may be get rid of this character "#" because of which i cannot insert in to DB and it gives error.

any idea?

[Piranha]

Look here to find out how you can get rid of the # character.

Or even better, use [man]mysql_real_escape_string[/man] (if you use a mysql database) to handle these things. You should do that to everything you insert into a database to avoid sql injection.

[smilesmita]

thanks!!! will apply the same!

[Weedpacket]

smilesmita wrote:

because of which i cannot insert in to DB and it gives error.

Not knowing which DBMS this is, I'm left wondering which ones treat '#' as being special inside strings.