Jump to content

[SOLVED] extra backlashes on table output


cedtech31

Recommended Posts

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

 

Link to comment
https://forums.phpfreaks.com/topic/44672-solved-extra-backlashes-on-table-output/
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.