How to retrieve strings from database containing forward slash using mysql query?

Question

I have a database with a field containing a string and a forward slash in it (ie. "some string / with a slash in it"). At the moment of executing a query and extracting the row, the forward slash seems to be gone. Why is this? and How can I get that slash in the query?

I looked around and all I could find was this mysql_real_escape_string() function. But I believe this is for inserting not extracting.

PD: I have the feeling that no forward slash is allowed in databases for some reason. Why?

Thank you

Must be something in php or your code. The database itself definitely allows a / in the data. — user330315
– user330315, Commented Jan 25, 2012 at 8:13
It seems more likely that you failed to insert the string with a slash than that you cannot extract it with one. — Ilion
– Ilion, Commented Jan 25, 2012 at 8:34

user254875486 · Accepted Answer · 2012-11-14 08:41:54Z

1

you might have a stripslashes() call on the string before inserting or after retriving the record

edited Nov 14, 2012 at 8:41

user254875486

11.3k7 gold badges39 silver badges65 bronze badges

answered Jan 25, 2012 at 9:47

robertboloc

1694 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

allegjdm93 Over a year ago

Thank you guys. I figured it out. I had the code 'if( isset( $data['description'] ) ) $this->description = preg_replace ("/[^\.\,\-\_\'\"\@\?\!\:\$ a-zA-Z0-9()]/","", $data['description'] );' when writing the constructor for the class which was escaping the forward slashes.

Collectives™ on Stack Overflow

How to retrieve strings from database containing forward slash using mysql query?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related