77
votes

Possible Duplicate:
Reference - What does this symbol mean in PHP?

I was wondering what @ means in PHP language. I have seen people using

$connect = @mysql_query('sql query here');

Not sure why. Could someone explain it for me?

5
it's a bad, bad thing. Never use it and eliminate every one you find.Your Common Sense
Don't say "never". I can think of a particular example with ldap when testing a user's credentials. If the credentials fail, an error is printed and cannot be trapped with a try/catch. The only thing you can do is test the result. While typically I'd agree with you, there ARE exceptions.Brad

5 Answers

71
votes

The @ operator tells PHP to suppress error messages, so that they will not be shown.

For instance, using:

$result = mysql_query("this is an invalid query");

would result in a warning being shown, telling you that the MySQL query is invalid, while

$result = @mysql_query("this is still an invalid query");

would not.

Note, however, that this is very bad programming practice as it does not make error disappear, it just hides them, and it makes debugging a heck of a lot worse since you can't see what's actually wrong with your code.

Instead of using @, you should disable error_reporting and display_errors just display_errors in php.ini

15
votes

The @ sign tells PHP to ignore error messages.

PHP Error Control Operators

1
votes

The @ is a way to tell that you don't want to print error messages. It's a bad practice because you might have an error and never see it because you just "hid" it.

PHP supports one error control operator: the at sign (@). When prepended to an expression in PHP, any error messages that might be generated by that expression will be ignored.


Resources :

0
votes

@ Operator = Indicates that if there is any kind of error occur, then don't display the message in the user's browser. There are people who test this and didn't see the difference even they put the @ or not they still don't see any error in the browser, well just to add up, the reason why this happen is because of the setting in the php.ini file for error output is turn off.

Different hosting company have different setting so to make sure that you don't want to see any ugly script error for the users or hackers(for them to give a clue to infiltrate you site) you can always use the @ operator.

Hope this help.