现在从数据库查询出结果集
$sql = "SELECT TOP 10 id,title,text FROM content "; $AdminResult = $db->getResult($sql);结果集中的title,text字段为乱码,我想把结果集中的字段转码后再生成另一个数组,应该怎么去写,请会的朋友帮忙。谢谢! 转码: $AdminResult ['title'] = iconv("GBK","UTF-8",$sum['news_ztitle']);
$AdminResult ['text']= iconv("GBK","UTF-8",$sum['news_zytext']);
$sql = "SELECT TOP 10 id,title,text FROM content "; $AdminResult = $db->getResult($sql);结果集中的title,text字段为乱码,我想把结果集中的字段转码后再生成另一个数组,应该怎么去写,请会的朋友帮忙。谢谢! 转码: $AdminResult ['title'] = iconv("GBK","UTF-8",$sum['news_ztitle']);
$AdminResult ['text']= iconv("GBK","UTF-8",$sum['news_zytext']);
while ($row = mysql_fetch_assoc($AdminResult)) {
$new_array[]=$row; //关键
}//根据实际代码写
foreach($rows as $_key => $_value)
{
$newResult[] = iconv("GBK","UTF-8",$_value);
}
}//使用$newResult 结果集则可
{foreach from=结果集 item=fz}{/foreach}
这个的结果应该是一个一维数组,我从数据库取出的是10条数据,每条数据都有4个字段,我觉得格式应该是
Array
(
[Griffin] => Array
(
[0] => Peter
[1] => Lois
[2] => Megan
)
[Quagmire] => Array
(
[0] => Glenn
)
[Brown] => Array
(
[0] => Cleveland
[1] => Loretta
[2] => Junior
)
)这样的。
foreach($rows as $_key => $_value)
{
$newResult[$cols][$_key] = iconv("GBK","UTF-8",$_value);
}
}