復制代碼 代碼如下:

//編碼轉換函數
function utf8togb($s) {
return iconv('utf-8', 'gbk//IGNORE', $s); // IGNORE 參數是遇到不成轉換的字符時忽略
}
//建議把所有中文字段用英文別名替換，方便下面操作還有編碼轉換等問題
$sql="SELECT [id], [欄目] as typeid, [正題] as title, [作者] as author, convert(text, [正文]) as body FROM [文章表];";
$sql = utf8togb($sql);