<?

if (isset($_GET['btnG'])) {
  header("Location: http://" . $_SERVER['SERVER_NAME'] . "/~k-ozaki/ajax/zip/");
  exit;
}

$zip = trim($_GET['qu']);

// 半角に
$zip = mb_convert_kana ($zip, 'a', "UTF-8");

$zip = str_replace("-", "", $zip);
if ($zip == '') {
  exit;
}

if (preg_match("/[^0-9]/", $zip)) {
  exit;
}

$addressList = array();

$con = mysql_connect('127.0.0.1', 'k-ozaki', 'password')
     or die ('could not connect: ' . mysql_error());
mysql_select_db('zip')
     or die ('could not select database');

$query = 'select PREFECTURE,CITY,STREET from ZIP';
$query.= ' where OLD_ZIP LIKE \''.$zip.'%\' ';
$query.= ' or ZIP LIKE \''.$zip.'%\' ';
$query.= ' order by CODE ';
$query.= ' limit 20 ';
$result = mysql_query($query)
     or die ('query failed: ' . mysql_error());

while ($row = mysql_fetch_array($result)) {
  $address = $row[0].$row[1].$row[2];
  $address = mb_convert_encoding($address, "UTF-8", "SJIS");
  array_push ($addressList, '"' . $address . '"');
}
mysql_free_result($result);
mysql_close($con);

header("Content-type: text/html; charset=utf-8");

echo 'sendRPCDone(frameElement, "' . $_GET['qu'] . '", ';
echo 'new Array(' . join(',', $addressList) . '), ';
echo 'new Array(';
if (is_array($addressList)) {
  $count = 0;
  foreach ($addressList as $value) {
    if ($count > 0) {
      echo ',';
    }
    echo '""';
    $count++;
  }
}
echo '), ';
echo 'new Array("")); ';
echo "\n";
echo "\n";

?>