什么';当连接到数据库时,mysqli出了问题


What's wrong with mysqli when connecting to database?

这是我的connect.php:

$mysql_hostname = "localhost";
$mysql_username = "root";
$mysql_password = "xxxxxxxx";
$mysql_database = "marrybrown_clean";
$bd = mysqli_connect ($mysql_hostname, $mysql_username, $mysql_password) or die ('Could not connect database!');
mysqli_select_db ($mysql_database, $bd) or die (" Could not select database!");

我得到以下错误:

**Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:'xampp'htdocs'marrybrown_clean'connect.php on line 7
Could not select database!**

如何修复?

此行

mysqli_select_db ($mysql_database, $bd)

应该是

mysqli_select_db ($bd, $mysql_database)

链路($bd)在mysqli函数中处于第一位。

mysqli_select_db要求第一个参数为mysqli_connect();所以应该如下。

mysqli_select_db ($bd, $mysql_database)

mysqli_selct_db中的第一个参数是连接参数,唯一错误的是交换了变量

所以这行:

mysqli_select_db ($mysql_database, $bd);

需要替换为

mysqli_select_db ($bd, $mysql_database);

你也可以这样做:

$mysqli = mysqli_connect
    ($mysql_hostname,$mysql_username,$mysql_password,$mysql_database) 
    or die('Could not connect to database!');

我建议您在连接时选择数据库:

$mysqli = mysqli_connect
    ($mysql_hostname,$mysql_username,$mysql_password,$mysql_database) 
    or die('Could not connect to database!');

您也可以使用面向对象的样式:

$mysqli = new mysqli
    ($mysql_hostname,$mysql_username,$mysql_password,$mysql_database);

尝试

mysqli_select_db ($bd,$mysql_database) 

喜欢在http://php.net/manual/fr/mysqli.select-db.php