HTML
Javascript
Flash Actionscript
PHP
mySQL
ASP
MS-SQL
Linux
Others
Ziwoo Board
Portfolio
About
|
|
Ziwoo Board |
ÀÛ¼º |
2006-08-13 18:26:50 Ãßõ: 0 Á¶È¸: 3666 |
Á¦¸ñ |
zipcode ¿¡·¯ÇØ°áÁ» ^^; |
À̸§(ID) |
±è´ëÇö (mypds)
|
|
|
¾È³çÇϼ¼¿ä?
¿ì¼±...
°Ô½ÃÆÇ ¸µÅ©µÈ°Å ´Ù¿î¹Þ¾Æ¼ ¼³Ä¡Çß½À´Ï´Ù.
±×·¨¶°´Ï
Unknown column 'zipcode.zip_idno' in 'field list'
¿¡·¯°¡ ¶å´Ï´Ù..
zipresult.php ³»¿ë¿¡
$Zip["zip_idno"] = null;
$Zip["zip_code"] = null;
$Zip["zip_sido"] = null;
$Zip["zip_gugun"] = null;
$Zip["zip_dong"] = null;
$Zip["zip_ri"] = null;
$Zip["zip_doseo"] = null;
$Zip["zip_sbunji"] = null;
$Zip["zip_ebunji"] = null;
$Query = "select ".selectQuery($Zip,"zipcode");
$Query .= " from zipcode where zip_dong like '$addr%' order by zip_idno"; <--À̺κÐ
±×¸®°í register_globals=Off ¶ó¼
$address_field = $_GET["address_field"];
$form_name = $_GET["form_name"];
$zip_field = $_GET["zip_field"];
$focus_name = $_GET["focus_name"];
$addr = $_GET["addr"];
ÀÌ·¸°Ô ³Ê¾îº¸¾Ò½À´Ï´Ù..
±Ùµ¥ Á¦°¡ Àß ¸ô¶ó¼ ±×·¯´Âµ¥ user_functions.inc ¿¡ selectQuery ÇÔ¼öÀÖ¶²µ¥
mysql ¿¡ zipcode Å×ÀÌºí º¸´Ï±î
mysql> desc zipcode;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| SEQ | int(5) | NO | PRI | | |
| ZIPCODE | varchar(7) | YES | | | |
| SIDO | varchar(4) | YES | | | |
| GUGUN | varchar(15) | YES | | | |
| DONG | varchar(24) | YES | | | |
| RI | varchar(18) | YES | | | |
| BLDG | varchar(36) | YES | | | |
| ST_BUNJI | varchar(11) | YES | | | |
| ED_BUNJI | varchar(9) | YES | | | |
+----------+-------------+------+-----+---------+-------+
ÀÌ·¸°Ô µÇ¾îÀֳ׿ä
|
|
|
|
Áö¿ì(ziwoo)
2006-08-14 00:25:07
|
|
Áú¹®¿¡ ´äº¯ÀÌ ´Ù ÀÖ±º¿ä..
Á¦ zipcode Å×ÀÌºí ½ºÅ°¸¶´Â
zip_idno
zip_code
zip_sido
zip_gugun
zip_dong
zip_ri
zip_doseo
zip_sbunji
zip_ebunji
Àε¥..
´ëÇö´Ô zipcodeÀÇ ½ºÅ°¸¶´Â Çʵå¸íµéÀÌ ¾à°£ ´Ù¸£±º¿ä.
SEQ
ZIPCODE
SIDO
GUGUN
DONG
RI
BLDG
ST_BUNJI
ED_BUNJI
´ÙÇàÈ÷ Çʵå¸í¸¸ ´Ù¸¦»Ó ±¸Á¶´Â °°Àºµí ÇÏ´Ï...
Äõ¸®ÇÒ¶§ ´ëÇö´Ô »óȲ¿¡ ¸Â°Ô À̸§¸¸ ¼öÁ¤ÇÏ½Ã¸é µÉµíÇϳ׿ä, |
|
|
|
|
±è´ëÇö(218.101.220.201)
2006-08-14 08:21:00
|
|
Á¦°¡ Àß ¸ô¶ó¼ ¼öÁ¤ÇغÁµµ Àß ¾ÈµÇ³×¿ä ^^; ÀÌÁ¦´Â Fatal error: Maximum execution time of 30 seconds exceeded in /home/mypds/www/ziwoo_board/zipcode/zipresult.php on line 61 ÀÌ·± ¿¡·¯¶ß°í¿ä 61¹ø°´Â $Records = array_merge($Records, array($rst)); ÀÔ´Ï´Ù
Áö¿ì³Ý¿¡¼ »ç¿ëÇÏ´Â zipcode¹Þ¾Æ¼ ¼³Ä¡ÇѰű¸¿ä
$Zip["seq"] = null;
$Zip["zipcode"] = null;
$Zip["sido"] = null;
$Zip["gugun"] = null;
$Zip["dong"] = null;
$Zip["ri"] = null;
$Zip["bldg"] = null;
$Zip["st_bunji"] = null;
$Zip["ed_bunji"] = null;
$address_field = $_GET["address_field"];
$form_name = $_GET["form_name"];
$zip_field = $_GET["zip_field"];
$focus_name = $_GET["focus_name"];
$addr = $_GET["addr"];
$Query = "select ".selectQuery($Zip,"zipcode");
$Query .= " from zipcode where dong like '$addr%'";
$cnn = mysql_query($Query) or exit(mysql_error());
while($rst = mysql_fetch_assoc($cnn)) {
$Records = array_merge($Records, array($rst));
}
.
. ÀÌÇÏ »ý·«
ÀÌ·¸°Ô µÇ¾îÀִµ¥
À§ÀÇ while ¿¡¼ ¿À·¡°É¸®´Â°Å °°Àºµ¥ ¹æ¹ýÀ» ¸øã°Ú½À´Ï´Ù ^^;
¹Ù»Ú½Å°¡¿îµ¥.. Ä£ÀýÇÑ ´äº¯ Áּż ³Ñ °¨»çµå¸³´Ï´Ù.. ^^ |
|
|
|
|
±è´ëÇö(mypds)
2006-08-14 08:40:43
|
|
µåµ® ã¾Ò½À´Ï´Ù..;;; ¿øÀÎÀº $addr °ªÀÌ ¾È³Ñ¾î °£°Å¿´³×¿ä ;;
$_GET["addr"]; ÀÌ°Ô Æ²¸°°Å°°½À´Ï´Ù.. $_POST["addr"]; ÀÌ·¸°Ô ÇؾߵǴµ¥ ¤Ð.¤Ð;
|
|
|
|
|
|