我使用 MYSQL 工作台作为数据库和 PHP 连接到 MYSQL 工作台，同时连接我收到以下错误。Warning: mysqli::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers in C:\Users\phpdesktop\phpdesktop-chrome-57.0-rc-php-7.1.3\www\index.php on line 3和Warning: mysqli::__construct(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers in C:\Users\phpdesktop\phpdesktop-chrome-57.0-rc-php-7.1.3\www\index.php on line 3和Warning: mysqli::query(): Couldn't fetch mysqli in C:\Users\phpdesktop\phpdesktop-chrome-57.0-rc-php-7.1.3\www\index.php on line 13以下是我的代码<?php $conn = new mysqli('localhost' , 'root' , '' , 'database_name'); if(isset($_POST['submit'])) {// insert username into the database table$Username = $conn->real_escape_string(stripslashes(trim($_POST['Username'])));$conn->query("INSERT INTO table_name (Username) VALUES ('$Username'");}?><!DOCTYPE><html><head><meta = charset=UTF-8><title>Insert Username</title></head><body><form name="username" method="post" action=""><p>Username<br><input type="text" name="Username"></p><p><input type="submit" name="submit" value="Submit"></p></form></body></html>以上是我用来将数据插入 MySQL 工作台数据库但不断收到上述错误的代码。
1 回答
牛魔王的故事
TA贡献1830条经验 获得超3个赞
您必须将以下代码添加到/etc/mysql/conf.d并重新启动 mysqld：
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
- 1 回答
- 0 关注
- 282 浏览
添加回答
举报
0/150
提交
取消