Resolved Question
Show me another »How can I save a URL with backslashes in mySql database?
I have this problem in storing URL in mySql. I tried to put the URL which came from the file chooser into a String variable. When I printed it, it seemed to be ok but when I saved it in the database, all the backslashes were gone. What should I do? Please help me. Thanks in advance.
Best Answer - Chosen by Voters
Escape them by *adding* a backslash:
C:\\Documents and Settings\\blah\\blah blah
C:\\Documents and Settings\\blah\\blah blah
67% 2 Votes
- Action Bar:
- 0 stars - mark this as Interesting!
- Comment (0)
There are currently no comments for this question.
* You must be logged into Answers to add comments. Sign in or Register.
Other Answers (3)
- Use these three Php functions:
addslashes, stripslashes and str_replace
Use stripslashes first ( "\\\" -> "\\" )
To remove escaped backslashes, use str_replace("\\" ,"", $string);
Check viewing your table contents directly, then their output into a text on screen.0% 0 Votes - check your table, if you are storing URLs, you will probably want to use something like varchar (50)
You may be using a table that doesn't accept those characters.33% 1 Vote - Use mysql_real_escape_string() function clean strings of SQL syntax before inserting them into my database.0% 0 Votes
Answers International
- Argentina
- Australia
- Brazil
- Canada
- China
- France
- Germany
- Hong Kong
- India
- Indonesia
- Italy
- Japan
- Malaysia
- Mexico
- New Zealand
- Philippines
- Quebec
- Singapore
- South Korea
- Spain
- Taiwan
- Thailand
- United Kingdom
- United States
- Vietnam
- en Español
Yahoo! does not evaluate or guarantee the accuracy of any Yahoo! Answers content. Click here for the Full Disclaimer.
Help us improve Yahoo! Answers. Send Feedback
Copyright © 2011 Yahoo! Inc. All Rights Reserved.