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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

<?php
include_once("./_common.php");

$DB_HOST  =  "localhost";
$DB_USER  =  "WebHostUser";
$DB_PWD   =  "WebHost5263";
$DB_NAME  =  "webhost";

if(!isset($_POST['sido'])) $_POST['sido'] = "";
if(!isset($_POST['gugun'])) $_POST['gugun'] = "";
if(!isset($_POST['d_buildingNo1'])) $_POST['d_buildingNo1'] = "";
if(!isset($_POST['d_buildingNo2'])) $_POST['d_buildingNo2'] = "";
if(!isset($_POST['d_road'])) $_POST['d_road'] = "";

$plusWhere = "";
if($_POST['d_buildingNo1'] != ""){
    $plusWhere .= "AND d_nBdNo01 = '{$_POST['d_buildingNo1']}'";    
}
if($_POST['d_buildingNo2'] != ""){
    $plusWhere .= "AND d_nBdNo02 = '{$_POST['d_buildingNo2']}'";    
}


$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 doro_tbl1 WHERE d_sido = '{$_POST['sido']}' AND d_gugun = '{$_POST['gugun']}' AND d_road LIKE '%{$_POST['d_road']}%' ".$plusWhere;
$result       =   mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
    $data .= "{$row['d_zipcode']}*{$row['d_sido']} {$row['d_gugun']} {$row['d_road']} {$row['d_nBdNo01']}-{$row['d_nBdNo02']}|{$row['d_sido']} {$row['d_gugun']} {$row['d_road']} {$row['d_nBdNo01']}-{$row['d_nBdNo02']}\n";
}
echo $data;