1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

<?php
include_once("./_common.php");
$DB_HOST  =  "localhost";
$DB_USER  =  "WebHostUser";
$DB_PWD   =  "WebHost5263";
$DB_NAME  =  "webhost";

$conn = mysql_connect($DB_HOST, $DB_USER, $DB_PWD);
if(!$conn){
    echo "mysql_error()";
}

mysql_select_db($DB_NAME);
$charSet_sql = "set names utf8";      
mysql_query($charSet_sql); 

if(!isset($_POST['code'])) $_POST['code'] = "";

$data = "";
$sql          =  "SELECT * FROM zipcode WHERE dong LIKE '%{$_POST['code']}%'";
$result       =   mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
    $data .= "{$row['zipcodeno']}*{$row['sido']} {$row['gugun']} {$row['dong']} {$row['note1']}|{$row['sido']} {$row['gugun']} {$row['dong']} {$row['note1']}\n";
}

echo $data;