php mysql insert into utf-8 [closed]

2020-02-08 04:10发布

I'm going to insert into some articles in mysql using PHP.

This is phpMyAdmin information:

Server: localhost via TCP/IP
Server version: 5.0.85-community-nt
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

Here is my table information:

Table   Action  Records 1  Type  Collation  Size  Overhead  
article       10 InnoDB utf8_unicode_ci 16.0 KiB - 
1 table(s)  Sum 10 InnoDB utf8_unicode_ci 16.0 KiB 0 B

I add

<?php header('Content-type:text/html; charset=utf-8'); ?>

in the top of my php code, add mysql_query("set names 'utf-8'"); before mysql_select_db("data",$db1);

but the data in the mysql is still like

piÃ¹ freddi

How do I show the data correctly?

标签： php mysql utf-8 insert

3条回答

兄弟一词,经得起流年.

2楼-- · 2020-02-08 04:59

Get rid of the hyphen. It should be:

mysql_query("SET NAMES utf8");

0人赞添加讨论(0) 举报

仙女界的扛把子

3楼-- · 2020-02-08 05:00

You have to specify the character encoding on the client as well, use

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

0人赞添加讨论(0) 举报

姐就是有狂的资本

4楼-- · 2020-02-08 05:02

Use following code for inserting

mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
mysql_query($qry);

This is worked fine in my case

0人赞添加讨论(0) 举报

php mysql insert into utf-8 [closed]

采纳回答

编辑标签

举报内容

检举类型

检举原因

检举说明(必填)

打开微信“扫一扫”，打开网页后点击屏幕右上角分享按钮

付费偷看金额在0.1-10元之间