MySQL error message along with PHP error message

Question

<?php
    //database connectivity
    $connect_error='Sorry We could not able to connect to the database';
    mysql_connect('localhost','root','') or die($connect_error);
    mysql_select_db('beehive_intwebpage') or die ($connect_error);
?>

We have this in setup this in our localhost. When there no connection with the database we get the error along with the error message.

Warning: mysql_connect(): No connection could be made because the target machine actively refused it. in D:\core\database\connect.php on line 3
Sorry We could not able to connect to the database

How to show only the message and not the default sql error.

Thanks!

Possible duplicate of mysql_connect(): No connection could be made because the target machine actively refused it — e4c5
– e4c5, Commented Aug 12, 2016 at 7:17

UeliDeSchwert · Accepted Answer · 2016-08-12 07:54:34Z

1

First: Don't use mysql_*-methods anymore, they're deprecated. Instead use mysqli or PDO.

For your error, disabling the error-reporting according to this documentation should help.

Just add error_reporting(0); to the beginning of your file.

edited Aug 12, 2016 at 7:54

answered Aug 12, 2016 at 7:10

UeliDeSchwert

1,15610 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tamil Over a year ago

Its PDO not DBO. Update it

UeliDeSchwert Over a year ago

Darn, war wrong in my memories. Thanks for pointing this out @Tamil

StackB00m · Accepted Answer · 2016-08-12 07:10:52Z

0

Hey default errors are caused due to php itself, you can turn them off in the php configuration file and you have to turn them off really because watching errors give an attacker knowledge of how your site works and your sites internal structure. So just turn off the error_reporting in php configuration

answered Aug 12, 2016 at 7:10

StackB00m

5021 gold badge5 silver badges16 bronze badges

4 Comments

Dexter Over a year ago

Thanks! I keep it open because we need to see other errors. By turning off, other errors won't show up right.

StackB00m Over a year ago

yes if you turn off other erros wont show! you can do one thing for sure, while testing you code you can keep it on, but while implementing it on server and giving it to users please turn off !

N.B. Over a year ago

Wait.. your solution is to turn errors off instead of handle them? And this guy even listens to you? Ever heard of @ in php?

StackB00m Over a year ago

so you are suggesting he goes and keeps @ at all the statements that cause errors lol; i am suggesting using try catch blogs to handle errors you are suggesting using @ at all the errors! what if you couldnt find all the error statements because you are giving well inputs, but when some user gives unvalid inputs and see's ur sites error message exposing your sites internal structure lol

Collectives™ on Stack Overflow

MySQL error message along with PHP error message

2 Answers 2

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related