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 Quote Link to comment Share on other sites More sharing options...
Jabop Posted July 25, 2008 Share Posted July 25, 2008 Post your code Quote Link to comment 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 Quote Link to comment 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.) Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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.