|
Á¦·Îº¸µå4ÀÇ È¸¿ø°¡ÀԽà ¿ìÆí¹øÈ£(ÁÖ¼Ò°Ë»ö)Àº Á¦·Îº¸µå ¼¹öÀÇ DB¸¦ ²ø¾î ¿À´Â ¹æ½ÄÀÔ´Ï´Ù.
Á¦ Ȩ¿¡¼± ȸ¿ø°¡ÀÔÀ» ¸·¾Æ µÐ »óÅÂÀÌ°í °£°£È÷ °¡ÀÔ Á¶Ä¡¸¦ ÇØ µå¸±¶§¸¶´Ù ÁÖ¼Ò´Â ¹ÞÁö ¾Ê¾Æ¼ ±×µ¿¾È Âü ÀÌ ºÎºÐ¿¡ ´ëÇØ¼´Â ¹«µòÆíÀÌ¿´½À´Ï´Ù.
´ÑÀÚÄ¿¹Â´ÏƼ ȸ¿øºÐ²²¼ ÀÌÁ¦ ´õ ÀÌ»ó Á¦·Îº¸µå4ÀÇ ÁÖ¼Òã±â ±â´ÉÀÌ µ¿ÀÛÀ» ¾ÈÇϽŴٰí ÇϽñ淡..
Å×½ºÆ® °â È®ÀÎ ÇØº¸´Ï Á¤¸» ¿À·ù°¡ ³ª´õ±º¿ä..
DB°¡ ¾ÆÁ÷ Á¸Àç ÇÏ´ÂÁöÀÇ ¿©ºÎ¸¦ ¶°³ª¼ Á¦·Îº¸µå »çÀÌÆ®ÀÇ ¼¹ö°¡ ¹®Àڼ ¹æ½ÄÀÌ UTF-8·Î ¹Ù²î¾úÀ¸´Ï EUC-KR ¼¹ö¿¡¼´Â ¿À·ù°¡ ³ª´õ±º¿ä.. ^^
ÀÌ¿¡ ÆÁ °øÀ¯Â÷¿ø¿¡¼ ÃֽŠ¿ìÆíº¯È£(2009³â 12¿ù 16ÀÏÀÚ) ÆÄÀÏÀ» DBÆÄÀÏ·Î º¯È¯À» ÇÏ¿© ±âÁ¸¿¡ ³ª¿Í ÀÖ´Â ÆÁ°ú °°ÀÌ Ã·ºÎ¸¦ ÇÕ´Ï´Ù.
1, ÷ºÎÆÄÀÏÀ» ´Ù¿î·Îµå ¹ÞÀ¸¼Å¼ ¾ÐÃàÀ» Ǫ½Ã¸é...
zipcode.db : ¿ìÆí¹øÈ£ µðºñÆÄÀÏ (2009.12.16.¹öÀü)
zipcode.php
zipcode2.php
ÀÌ·¸°Ô 3°³°¡ ÀÖ½À´Ï´Ù.
ÀÌ ¸ðµç ÆÄÀÏÀ» Á¦·Îº¸µåÀÇ zipcode Æú´õ¿¡ ¾÷·Îµå ½Ãŵ´Ï´Ù.
2. ´ÙÀ½Àº member_join.php¿Í member_modify.php ÆÄÀÏÀ» ¼öÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
µÎ°³ÀÇ ÆÄÀÏ¿¡ º¸½Ã¸é ÆË¾÷ ÀÚ¹Ù½ºÅ©¸³Æ®°¡
function address_popup(num) {
window.open('zipcode/search_zipcode.php?num='+num,'searchaddress','width=440,height=230,scrollbars=yes');
}
ÀÌ·¸°Ô ½áÀÖÀ» ²¨¿¡¿ä.
ÀÌ ÇÔ¼ö´Â ´õÀÌ»ó Á¦·Îº¸µå ÁÖ¼Ò°Ë»öÀ» »ç¿ëÇÏÁö ¾ÊÀ¸½Ã·Á¸é ÀÌ ÇÔ¼ö¿Í
zipcode/search_zipcode.php
zipcode/search_zipcode2.php
zipcode/search_zipcode3.php
ÀÌ 3°³ÀÇ ÆÄÀϵé°ú ÇÔ²² »èÁ¦ ÇÏ½Ã¸é µË´Ï´Ù. ³öµÎ¼Åµµ ¾Æ¹«·± ¹®Á¦´Â ¾ø½À´Ï´Ù.
¿ì¼± Å×½ºÆ®ÇØ º¸°í »èÁ¦ÇϽñ⸦ ¹Ù¶ø´Ï´Ù.±¦È÷ ³ªÁß¿¡ ¾ÈµÈ´Ù°í ÇÏÁö ¸¶½Ã±¸¿ä.^^;
À§ ½ºÆ®¸³Æ®ÀÇ À§³ª ¾Æ·¡¿¡´Ù ¾Æ·¡ÀÇ ÇÔ¼ö¸¦ Çϳª ´õ Ãß°¡ Çϰųª º¯°æÇÕ´Ï´Ù.
function zipcode(form,address) {
window.open('zipcode/zipcode.php?form='+form+'&address='+address,'searchaddress','left=100,top=100,width=445,height=400,scrollbars=yes');
}
µÎ°³ÀÇ ÆÄÀÏ(member_join.php¿Í member_modify.php)¿¡ ã¾Æ¼ °¢°¢ Ãß°¡ÇØÁÖ½Ã¸é µË´Ï´Ù.
±×¸®°í ÀÌÁ¦ ÁÖ¼Òã±â ¸µÅ©¸¦ ¹Ù²ãÁà¾ß ÇÕ´Ï´Ù.
µÎ¹øÂ°¿¡¼ ÀÚ¹Ù½ºÅ©¸³ ÇÔ¼ö¸¦ Ãß°¡ÇØÁ̴ּø member_join.php¿Í member_modify.php ÆÄÀÏ¿¡
ÁýÁÖ¼Òã±â ¹öư Çϰí ȸ»çÁÖ¼Òã±â ¹öư ÀÌ µÎ°³°¡ ÀÖ½À´Ï´Ù.
ÁýÁÖ¼Òã±â
onclick=address_popup(1) À» =====> onclick=zipcode('write','home_address') ·Î º¯°æ
ȸ»çÁÖ¼Òã±â
onclick=address_popup(2) ¸¦ =====> onclick=zipcode('write','office_address') ·Î º¯°æ
±×¸®°í Å×½ºÆ®¸¦ ÇØ º¸¼¼¿ä.(¹«¸®¾øÀÌ Àß ÀÛµ¿À» ÇÒ°Ì´Ï´Ù.
* Âü°í·Î
http://www.postman.pe.kr/zipcode/index.html
À̰÷¿¡¼ ÃֽŠ¿ìÆí¹øÈ£°¡ ¿Ã·ÁÁ® ÀÖ½À´Ï´Ù.
Type 2 ´Ù¿î·Îµå ÆÄÀÏÀ» ¹ÞÀ¸¸é µÇ´Âµ¥¿ä..
ÀÌ°Ô DBÆÄÀÏÀÌ ¾Æ´Ï¶ó ¿¢¼¿ ÆÄÀÏÀ̹ǷΠ¿¢¼¿·Î ¿¾î¼ CSVÆÄÀÏ·Î º¯È¯À» ÇØ¼ ¿¡µðÅÍ °°Àº °ÍÀ¸·Î ¿¾î¼ ÆÄÀÏÀ» ¼öÁ¤À» ÇØ ÁÖ°í DBÆÄÀÏ·Î º¯È¯À» ÇÏ´Â °úÁ¤À» °ÅÃÄ¾ß ÇÕ´Ï´Ù.
À§ »çÀÌÆ®¿¡¼ ÆÄÀÏÀ» ¹Þ¾Æ¼ DBÆÄÀÏ·Î º¯È¯ÇÏ´Â ¹æ¹ýÀº..
¾ÐÃàÀ» Ǫ¼Å¼ ÀÌ ÆÄÀÏÀ» ¿¢¼¿·Î ºÒ·¯ µéÀ̽ŠÈÄ¿¡ °¡Àå ÀÁÙ°ú, °¡Àå ¿À¸¥ÂÊ ÁÙÀ» »èÁ¦ÇϽðí,
CSV Çü½ÄÀ¸·Î ÀúÀåÇϽŠÈÄ¿¡
Edit Plus2 ¿Í °°Àº ÆíÁý ÇÁ·Î±×·¥À¸·Î ¿©¼Å¼ ,,¸¦ ,·Î ¼öÁ¤ÇϽðí,
ÀÌ ÈÄ¿¡ ,¸¦ |·Î ¼öÁ¤Çϼż dbÆÄÀÏ·Î ÀúÀåÇÏ½Ã¸é »ç¿ëÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
ÀÌ °Ô½Ã´¿¡ ÷ºÎµÈ ÆÄÀÏÀÌ ¾ÆÁ÷Àº ÃÖ½ÅÁ¤º¸ÀÌ´Ï ´çºÐ°£Àº °Ô½Ã¹°ÀÇ Ã·ºÎÆÄÀÏÀ» ÀÌ¿ëÇϼŵµ µÇ°Ú½À´Ï´Ù. ^^
|