乱码如下:
解决方式
查看数据库编码方式:
//查询
show variables like 'character%';
//设置
set character_set_server = 'utf8';
设置HTML页面编码
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
PHP文件编码设置
//消息头部
header("Content-Type:text/html; charset=utf-8");
//数据库连接方式
$conn = new mysqli($servername,$username,$password,$dbname);
mysqli_set_charset($conn,'UTF8');
//注意,下面这种方式不行!!!
$conn = new mysqli($servername,$username,$password,$dbname);
mysqli_query(“set names utf8”);