使用mysqli_select_db和mysqli_connect时出错 [英] Error when using mysqli_select_db and mysqli_connect

问题描述

我将切换到mysqli，因为不再支持mysql_*函数.当我尝试连接到数据库时，出现错误.这是我的代码.

I am switching to mysqli, because mysql_* functions are not supported anymore. When I try to connect to my database, I get an error. Here is my code.

<?php

//ob
//ob_start();

//session
session_start();

//connect to database
$error = "Could not connect to database";
mysqli_connect('','************','**********') or die($error);
mysqli_select_db('********************') or die($error);

$session_username = $_SESSION['username'];
$session_coin = $_SESSION['coins'];

?>

错误:

无法连接到数据库

Could not connect to database

尝试使用mysqli正确吗?

Is that correct when trying to use mysqli?

推荐答案

否，这不是使用mysqli进行连接的正确方法.

No, this is not the correct way to connect using mysqli.

正确的方法是这样:

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli('localhost', 'username', 'password', 'test_db');
$mysqli->set_charset('utf8mb4'); // always set the charset

三个步骤:

1. 启用错误报告.
2. 创建mysqli类的实例.
3. 设置正确的字符集.

这篇关于使用mysqli_select_db和mysqli_connect时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！