5

How do you prevent a connection error if, for example, the database name is invalid, for the given code below?

$mysql = new mysqli('localhost', 'user', 'pass', 'wrongdatabase');

if($mysql->connect_errno)
    die($mysql->connect_error);

The if statement will output the right error message, but there will still be a warning sent from the first line, which says

Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (42000/1049): Unknown database 'wrongdatabase' in C:\wamp\www\example.php on line 14

I know with PDO you would simply wrap it in a try/catch block, but how to do it with MySQLi?

reformed
  • 4,205
  • 10
  • 58
  • 83

1 Answers1

5

The answer here was incorrect and outdated. A more recent answer to this question can be found here

Your Common Sense
  • 154,967
  • 38
  • 205
  • 325
  • 1
    Sorry to bring up such an old post. Instead of creating a topic.. Just wanted to ask whether this is still recommended to catch errors thrown by connecting to `mysqli` databases? – Daryl Gill Jul 07 '14 at 01:59
  • I do not agree with this recommendation. In my opinion, we should avoid `@` like fire. I see no reason to silence the warning on mysqli constructor just to trigger an error in the next line. Could you revisit this answer? Maybe it needs to be updated? – Dharman Jun 12 '20 at 15:57
  • @Dharman thank you for bringing it up. A pity, this answer is accepted hence I couldn't simply delete it and close the question as a dupe. Nevertheless I will close it anyway and yes, will revise as well. – Your Common Sense Jun 12 '20 at 16:00