php取出mysql数据时乱码

1、查看数据库编码

show create table 表名;

mysql> show create table first;
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                        |
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| first | CREATE TABLE `first` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 

编码为utf8

2、在php文件最上面写

header("Content-type:text/html;charset=utf-8");

3、在取出数据时

$pdo->query("set names utf-8");

4、最后文件编码保存为utf-8的形式