[SOLVED] problem with addslashes() and mysql_real_escape_string()

[niranjnn01]

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

[Jabop]

Post your code

[niranjnn01]

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

[PFMaBiSmAd]

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.)

[rawb]

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.

[niranjnn01]

"addslashes accepts a string where explode returns an array."

 

Hello Rawb,

 

your observations were correct... It helped me solve the problem.

 

Thank you,

Rakesh