Suppress mysql errors on php

Question

I know that in general the php errors can be suppressed using error_reporting(0) or the '@'. I have many sql queries being fired in a certain section of my work, I wanted to know that does adding error_reporting(0) suppress the appearance of errors arising from mysql queries?

I read online varying answers. Some state it will help while others say it wont work like that .

I do not want to add @ individually to all the calls. I am hoping for a more general answer. — Bhumi Singhal, Feb 01 '13 at 10:31
[Possible Douplicate for this link](http://stackoverflow.com/questions/1987579/how-to-remove-warning-messages-in-php) — Orel Eraki, Feb 01 '13 at 10:32
@Ravi-I have. Its actually an admin system so never really sure what might crop up ..:) — Bhumi Singhal, Feb 01 '13 at 11:48
you can turn off error showing by htacces files also.Please try [this][1] [1]: http://stackoverflow.com/questions/1645661/turn-off-warnings-and-errors-on-php-mysql — mjdevloper, Feb 01 '13 at 12:10

score 8 · Accepted Answer · answered Feb 01 '13 at 10:34

8

Try putting this at the top of your code:

ini_set("display_errors", "off");

And yes, adding @ at the beginning of functions etc, for example:

$query = @mysql_query("text..");

Should suppress errors.

answered Feb 01 '13 at 10:34

EM-Creations

4,195
4
40
56

1

error_reporting(0) at the start of the script wont do the trick ? – Bhumi Singhal Feb 01 '13 at 10:37
1

and please explain how setting display_errors will be better than error_reporting. Thank you – Bhumi Singhal Feb 01 '13 at 10:39
1

@BhumiSinghal Several times I've tried `error_reporting(0);` and some errors still show up. Often I've been able to overcome this by also putting `ini_set("display_errors", "off");` at the top of my code. Just try it and see if it works for you. – EM-Creations Feb 01 '13 at 10:42

score 0 · Answer 2 · edited May 23 '17 at 12:08

0

If you have htaccess file then you can controll all errors by this. try this

edited May 23 '17 at 12:08

Community

1
1

answered Feb 01 '13 at 12:11

mjdevloper

1,553
8
33
69

I do have an htaccess but I am looking for the simplest possible solution ...and I guess php surely provides something to handle this :) – Bhumi Singhal Feb 01 '13 at 12:31

Suppress mysql errors on php

2 Answers2