cedtech31 Posted March 28, 2007 Share Posted March 28, 2007 I have an issue that when I extract data from mysql table it's including backlashes with quotes. Example if I enter "james" in the table when I extract the data I get "\james"\ Is there a function to correct this issue? This is a remote server and I don't have access to the PHP.ini file I am using the code below to enter a value into the table trim(mysql_real_escape_string($value)) I am using the follow code to retrieve the data <?php echo $row['value_name']; ?> Both codes are incomplete but these are the lines that I think are affecting the output. Any thoughts or ideas are welcome Quote Link to comment https://forums.phpfreaks.com/topic/44672-solved-extra-backlashes-on-table-output/ Share on other sites More sharing options...
papaface Posted March 28, 2007 Share Posted March 28, 2007 stripslashes($string); Quote Link to comment https://forums.phpfreaks.com/topic/44672-solved-extra-backlashes-on-table-output/#findComment-216915 Share on other sites More sharing options...
per1os Posted March 28, 2007 Share Posted March 28, 2007 stripslashes() function will work, but should be unnecessary if entered properly. Use this function instead of mysql_real_escape: function myEscape($string) { return (get_magic_quotes_gpc())?trim($string):mysql_real_escape_string(trim($string)); } That way if the string is already escaped due to magic quotes it will not double the slashes Quote Link to comment https://forums.phpfreaks.com/topic/44672-solved-extra-backlashes-on-table-output/#findComment-216919 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.