php中文乱码问题

  •   2009-07-31/22:52
  • <html>

    <head>
    <title></title>
    </head>

    <body>

    <?php
    $mysql_server_name='localhost';
    $mysql_username='root';
    $mysql_password='000000';
    $mysql_database='lib';
    $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
    $sql="select name,age from mytb";
    print($conn);
    $rs=mysql_db_query("lib","select * from mytb",$conn);
    print("\n<br>");
    while($row = mysql_fetch_object($rs)){
    print ($row->name.":".$row->age."<br>");
    }
    mysql_close($conn);
    ?>
    显示如下:
    Resource id #1
    dd:54
    ddd:8
    ??:15
    ???:25
    ??:32
    mysql编码:utf8,GBK都试过了。mysql font 和命令行显示都正确。
    问题补充:
    乱码:
    ???:15
    ???:25
    ??:32
    这几行,数据库里的值是汉字.显示出来的是问号.

    解决办法:

    在$rs=mysql_db_query("lib","select * from mytb",$conn);
    前面加上
    mysql_query("set names gb2312");或者mysql_query("set names gbk");


    评论 {{userinfo.comments}}

    {{money}}

    {{question.question}}

    A {{question.A}}
    B {{question.B}}
    C {{question.C}}
    D {{question.D}}
    提交

    驱动号 更多