<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 );
?>
Shown as follows:
Resource id #1
Dd: 54
Ddd: 8
?? : 15
??? : 25
?? : 32
Mysql code: utf8, GBK all tried. Mysql font and command line display are correct.
Question added:
Garbled:
??? : 15
??? : 25
?? : 32
In these rows, the database value is Chinese characters, and the question mark is displayed.
Solution:
In $ rs = mysql_db_query ("lib", "select * from mytb", $ conn );
Add
Mysql_query ("set names gb2312"); or mysql_query ("set names gbk ");
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
