删除页面中显示的mysqli_connect警告

Question

$mysqlServer = "***";
$mysqlDb = "***";
$mysqlUser = "***";
$mysqlPass = "***";

$conn = mysqli_connect($mysqlServer, $mysqlUser, $mysqlPass) or die("failed to connect to db");
mysqli_select_db($conn, $mysqlDb) or die("failed to connect select db");

我有这个代码，它的工作没有任何问题。但是，如果我尝试输入错误的sql服务器或测试它来执行错误。这将显示：

Warning: mysqli_connect(): (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
failed to connect select db

如果在连接sql服务器时出现问题，我不希望显示警告。我只想显示我自己的错误。

Answer 1

2种可能的选择：

• 将error_reporing级别设置为在mysqli_connect之前不显示警告http://php.net/manual/en/function.error-reporting.php
• put a @ sign，这将抑制警告消息

Answer 2

将@符号放在每个函数前面会隐藏错误

$conn = @mysqli_connect($mysqlServer, $mysqlUser, $mysqlPass) or die("failed to connect to db");

Answer 3

试试这个：

$conn = mysqli_connect($mysqlServer, $mysqlUser, $mysqlPass, $mysqlDb);

使用connect作为第四个参数传递DB名称。