niranjnn01 Posted July 25, 2008 Share Posted July 25, 2008 Hello, I am having a problem with addslashes() and mysql_real_escape_string() . When i use addslashes, the value i get entered into the database is a A, whereas, when i use mysql_real_escape_string(), The database entry is blank... any idea why this is happening like this? Thanks Rakesh Link to comment https://forums.phpfreaks.com/topic/116591-solved-problem-with-addslashes-and-mysql_real_escape_string/ Share on other sites More sharing options...
Jabop Posted July 25, 2008 Share Posted July 25, 2008 Post your code Link to comment https://forums.phpfreaks.com/topic/116591-solved-problem-with-addslashes-and-mysql_real_escape_string/#findComment-599502 Share on other sites More sharing options...
niranjnn01 Posted July 25, 2008 Author Share Posted July 25, 2008 Hello, My code is $file_name = addslashes ( explode('.jpg',$_FILES['photoupload']['name']) ); and I am accessing the value as $file_name[0] The input will be smthing like -----> 'test Link to comment https://forums.phpfreaks.com/topic/116591-solved-problem-with-addslashes-and-mysql_real_escape_string/#findComment-599542 Share on other sites More sharing options...
PFMaBiSmAd Posted July 26, 2008 Share Posted July 26, 2008 You are probably calling the mysql_real_escape_string() function before a connection has been made to a database server and it is returning a null value, which you then put into your query and the query is failing due to the resulting syntax error, but your query has no error checking, error reporting, or error recovery logic to get it to tell you what is occurring, but I could be wrong as you did not bother to post the code you want help with (the one line you posted is pointless as that does not show where or how it is being used in the code.) Link to comment https://forums.phpfreaks.com/topic/116591-solved-problem-with-addslashes-and-mysql_real_escape_string/#findComment-600039 Share on other sites More sharing options...
rawb Posted July 26, 2008 Share Posted July 26, 2008 You are probably calling the mysql_real_escape_string() function before a connection has been made to a database server and it is returning a null value, which you then put into your query and the query is failing due to the resulting syntax error, but your query has no error checking, error reporting, or error recovery logic to get it to tell you what is occurring, but I could be wrong as you did not bother to post the code you want help with (the one line you posted is pointless as that does not show where or how it is being used in the code.) Additionally, addslashes accepts a string where explode returns an array. Link to comment https://forums.phpfreaks.com/topic/116591-solved-problem-with-addslashes-and-mysql_real_escape_string/#findComment-600042 Share on other sites More sharing options...
niranjnn01 Posted July 26, 2008 Author Share Posted July 26, 2008 "addslashes accepts a string where explode returns an array." Hello Rawb, your observations were correct... It helped me solve the problem. Thank you, Rakesh Link to comment https://forums.phpfreaks.com/topic/116591-solved-problem-with-addslashes-and-mysql_real_escape_string/#findComment-600146 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.