使用PHP将中文字符插入mysql数据库

Question

I would like to ask why the code shown below, cannot insert the chinese character $split 5 to the MySQL db. I have created a db using utf8_general_ci and table as well.

 $mysqli = new mysqli($GLOBALS["mysql_host"], $GLOBALS["mysql_user"], $GLOBALS["mysql_passwd"], $GLOBALS["mysql_database"]);
$stmt = mysql_query("SET character_set_results 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8");
$stmt = $mysqli->prepare("INSERT INTO cell (`add`) VALUES (?)");
$stmt->bind_param("s", $split[5]);
$stmt->execute();
$stmt->close();
$mysqli->close();

Answer 1

First, there is a typo. You've used mysql_query() instead of mysqli_query()

---

Following the mysqli documentation in PHP, mysqli_set_cahrset() is the way to go:

$mysqli->set_charset ('utf8');

So I would add the line above and remove the mysql_query('SET ...'); statement