住所からでも番号からでも検索できます。
";
exit;
}
# $row=mysql_select_db("c:\mysql\data\test",$my_con);
# $row=mysql_select_db("test",$my_con);
# mysql_select_db("/web/sites/70/sunhouse/www.gakusai.f2s.com/test",$my_con);
$rtn = mysql_query("SET NAMES utf8" , $my_con);
mysql_select_db("hsu0266",$my_con);
if($result=mysql_query("select * from zip where zi like '$keyword%'")){
# $row=mysql_fetch_array($result);
while($row=mysql_fetch_array($result)){
if ($row){
# $row = i18n_convert($row, SJIS, EUC-JP);
# $row = Exec("echo $row | nkf -s");
# $row = "echo $row | nkf -s";
$row["ad"] = mb_convert_encoding($row[ad], "SJIS", "UTF-8");
# $row["ad"] = Exec("echo $row[ad] | nkf -Ws");
# $row["ad"] = Exec("echo $row[ad]");
# $row = tosjis($row);
print "
";
}
}
}
if($result=mysql_query("select * from zip where ad like '%$keyword%'")){
while($row=mysql_fetch_array($result)){
# $row = i18n_convert($row, SJIS, EUC-JP);
# $row = Exec("echo $row | nkf -s");
# $row["ad"] = Exec("echo $row[ad] | nkf -s");
$row["ad"] = mb_convert_encoding($row[ad], "SJIS", "UTF-8");
# $row["ad"] = Exec("echo $row[ad]");
# $row = tosjis($row);
print "";
print "〒";
print substr($row["zi"],0,3);
print "-";
print substr($row["zi"],3,4);
print "は";
print $row["ad"];
print "です。";
print " ";
}
}
$date = date("Y/m/d H:i:s");
$log = fopen("zip.log","a");
flock($log,2);
fwrite($log,"$keyword\t$date\n");
flock($log,3);
fclose($log);
}
?>
";
print $row["ad"];
print "は〒";
print substr($row["zi"],0,3);
print "-";
print substr($row["zi"],3,4);
print "です。";
print "