大家以后在编写过程中， 一定要记得定义字符类型。

mysql_query("set names 'gbk'")

解决的方法就这么简单。

今天做了一个数据库查询，放出代码。

复制代码 代码如下:

<?php

/*

filename:query.php

do:get and show the data

author:www.5dkx.com

*/

include_once("conn.php");

include_once("include.php");

mysql_query("set names 'gbk'")or die("设置字符库失败n");

mysql_select_db($db)or die("连接数据库失败!n");

$exec = "select * from $table";

//echo $exec;

$result = mysql_query($exec,$conn)or die("查询数据库失败n");

echo "<table border=2>";

for($cout=0;$cout<mysql_numrows($result);$cout++)

{

$city = mysql_result($result,$cout,city);

$name = mysql_result($result,$cout,name);

$phone = mysql_result($result,$cout,phone);

echo "<tr>";

echo "city: $city";

echo "name: $name";

echo "phone: $phone";

echo "</tr>";

}

echo "</table>";

?>