$_post

[dole.doug]

hi there

On my local serve i was using mysql_real_escape_string($_POST['my_variable_name']) and now this doesn;t work on a public server. The $_POST['my_variable_name'] works.

Which is the cause?
I was supposing is from the magic_quates, and for that i've added this in the .htaccess file, but still doesn't work.

php_flag magic_quotes_gpc off

what to do?

[Stormrider]

Does the function exist? Have you installed the mysql extension?

[dole.doug]

Yes...the mysql extension is enabled and works

The script works without mysql_real_escape_string()

[Stormrider]

What error are you getting?

[dole.doug]

no errors

[corbyboy]

Try printing out the raw output from $_POST, then applying the function and then printing out the result.

[guido2004]

Then what does "doesn't work" mean? Could you explain the actual result of your script, and what it should do instead?

[dole.doug]

    include_once('connections.php');

    @$name = $_POST['name'];
    @$obs = mysql_real_escape_string($_POST['obs']);


        $sqlInsert = "INSERT INTO `test_table` (`user_name`, `obs`)
                            VALUES ('$name', '$obs'); ";
        
        print_r( $sqlInsert) ;
        
        $sqlResul = mysql_query($sqlInsert) or die(mysql_error()); 

and the output is:

INSERT INTO `test_table` (`user_name`, `obs`) VALUES ('testname', ''); 

even the obs variable from the form is not empty.

when i use:
@$obs = $_POST['obs'];
the script works as espected

[Stormrider]

Well remove the @ for a start, you shouldn't use that. If you suppress errors, you aren't going to find out about potential problems.

You might get an error output when you do that, which will help us further.

[dole.doug]

Well remove the @ for a start, you shouldn't use that. If you suppress errors, you aren't going to find out about potential problems.

You might get an error output when you do that, which will help us further.

many thx

that was....the connection to mysql wasn't good

[Stormrider]

A perfect example of why you should never suppress errors with @

[guido2004]

A perfect example of why you should never suppress errors with @

Yes. Errors must be resolved, or managed. Never suppressed (never say never?! ).