Changeset 13014

Timestamp:

2007/05/17 21:42:34 (17 years ago)

Author:

nakanishi

Message:

 

File:

• branches/dev/html/input_zip_json.php (modified) (1 diff)

branches/dev/html/input_zip_json.php

@@ -44 +44 @@
     echo "{ 'POST' : 'test' , 'GET' : 'test' }";
 } else {
-    $zip = $_GET['zip01'].$_GET['zip02'];
-echo "{'MSG' : '½»½ê¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£' , 'ZIP' : '$zip','DATA_LIST':'$data_list[0]'}" ;
+    
+    $zipcode = $_GET['zip1'].$_GET['zip2'];
+    $zipcode = mb_convert_kana($zipcode ,"n");
+    $sqlse = "SELECT state, city, town FROM mtb_zip WHERE zipcode = ?";
+    $data_list = $conn->getAll($sqlse, array($zipcode));
+echo "{'MSG' : '½»½ê¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£' , 'ZIP' : '$zipcode','DATA_LIST':'$data_list[0]'}" ;
     }
 }