建议注释掉Apache、php的默认编码设置,在网页head区声明编码即可。这样可以在一个服务器上写多种编码的页面MySQL乱码问题,在操作数据库前,执行以下语句:
SET CHARACTER SET GB2312例:
<?phprequire_once "./classes/phplib/db_mysql.inc";$db = new DB_Sql();$db->connect("dbname","localhost","root","");
$db->query("SET CHARACTER SET GB2312");$sql = "SELECT `id`,`title`,`content`,`date` FROM `news`";
$sql .= "ORDER BY `id` DESC";$db->query($sql);if ($db->nf()) {
while ($db->next_record()) {
$db->p("id");
$db->p("title");
$db->p("content");
$db->p("date");
}
} else {
dir ("No data.");
}$db->free();?>
SET CHARACTER SET GB2312例:
<?phprequire_once "./classes/phplib/db_mysql.inc";$db = new DB_Sql();$db->connect("dbname","localhost","root","");
$db->query("SET CHARACTER SET GB2312");$sql = "SELECT `id`,`title`,`content`,`date` FROM `news`";
$sql .= "ORDER BY `id` DESC";$db->query($sql);if ($db->nf()) {
while ($db->next_record()) {
$db->p("id");
$db->p("title");
$db->p("content");
$db->p("date");
}
} else {
dir ("No data.");
}$db->free();?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货