mysql_real_escape_string not working on linux server but its working for my localhost

Question

$intro=mysql_real_escape_string($_POST["intro"]);
$description=mysql_real_escape_string($_POST["description"]);

If i post the any special character value it is not stored properly.

Answer 1

• try : on top of your script in the linux server (better before anything else)

  error_reporting(E_ALL); ini_set('display_errors', '1');

• look in the 'page source code' if a php error is present.

Maybe on the linux yoou need to specify the connection :

$intro = mysql_real_escape_string($_POST["intro"], $my_mysql_connection);
$description = mysql_real_escape_string($_POST["description"], $my_mysql_connection);

• follow Jay Blanchard suggestion.

Is possible that the php on the linux is running magic_quotes_gpc enabled... Please look in

echo php_info();

if php version < 5.3 and magic_quotes_gpc enabled, try this on top of page:

function stripslashes_recurr($o)
{   $o = is_array($o) ? array_map('stripslashes_recurr', $o) : stripslashes($o);
    return $o;
}

$magic_quotes_gpc = get_magic_quotes_gpc() ? true : false;  
ini_set('magic_quotes_runtime', 0);                             
ini_set('magic_quotes_sybase', 0);
if($magic_quotes_gpc) $_POST = stripslashes_recurr($_POST);