夏日里的冰红茶

写了短小程序，从数据库中获取几条记录，程序很简单，反复确认没有任何错误，但是页面始终无法显示获取的数据，反复调试无果，后来偶发灵感，发现数据库编码是utf8而页面文件编码是ANSI，于是加了一行：mysql_query("set names gbk");解决

—————————

mysql_connect(‘localhost’, ‘root’, ‘password’ );

mysql_select_db(‘ecmall’);

mysql_query("SET NAMES GBK");

$handle = fopen(‘canyin.txt’, ‘r’);

$findme   = ‘：’;

$field_id = 0;

if ($handle) {

    while (!feof($handle)) {

        $buffer = fgets($handle, 4096);

if(strpos($buffer, $findme) === false){

}

else{

$buffer = str_replace($findme, ”, $buffer);

$buffer = str_replace("\r", ”, $buffer);

$buffer = trim(str_replace("\n", ”, $buffer));

//echo $buffer;

$sql = "select * from ecm_field where field_name like ‘%$buffer%’";

//echo $sql;

$res = mysql_query($sql);

//

//echo $res;

if($res){

$data = mysql_fetch_array($res);

print_r($data);

echo $data['field_id'];

}

else{

echo mysql_error();

}

}

    }

    fclose($handle);

}