我也是用MySQL 4.1.10操作数据库前,执行以下语句: 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"); } } $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");
}
}
$db->free();?>