php的foreach乱码怎么办

具体问题：

php foreach 循环 数据全是乱码 怎么解决 ？

这是代码

<?php
$link = MySQL_connect("localhost", "root", "")
or die("Could not connect: " . mysql_error());
mysql_query("set names utf-8;");
mysql_query("SET character_set_connection='utf-8', character_set_results='utf-8', character_set_client='utf-8'");
$sql="select * from baoming.bAImingbiao";
$aa=mysql_query($sql);
$v = mysql_fetch_array($aa);
if(is_array($v))
{
foreach($v as $k=>$r)
{
$aaa .="<table>";
$aaa.="<tr><td>".$r['name']."</td><td>".$r['dianhua']."</td><td>".$r['xingbie']."</td><td>".$r['youxiang']."</td><td>".$r['danwei']."</td><td>".$r['zhiye']."</td><td>".$r['hjhhy']."</td><td>".$r['zhusu']."</td><td>".$r['shouji']."</td><td>".$r['yjje']."</td><td>".$r['yfje']."</td><td>".$r['ddbz']."</td><td>".$r['fjbz']."</td><td>".$r['ddbz']."</td><td>".$r['fjbz']."</td><td>".$r['beizhu']."</td><td>".$r['yewuyuan']."</td><td>".$r['fjh']."</td></tr>";
}
$aaa .="</table>";
echo $aaa;
exit;
$handle = @fopen('./c.xls', 'w');
if($handle)
{
if(@fwrite($handle, $aaa))
{
echo '1';
}
else
{
echo "0";
}
fclose($handle);
@header("location:xls_bu.php");
}
}
?>

解决办法：

从浏览器上改下编码格式为utf-8看看，如果不是乱码的话，在程序里指定编码格式就行了。

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