2024 12 06
   
 
 
  
 
    ¹æ¼Û
    VJ
    ȨÆäÀÌÁö
    ÇÁ·Î±×·¥
    ³×Æ®¿öÅ©
    html
    JAVA
    C¾ð¾î
    µå¸²À§¹ö
    Ç÷¡½Ã
    Æ÷Åä¼¥
    ÀÏ·¯½ºÆ®
    PHP
    JSP
    XML
  - ºñµð¿ÀÀú³ÎÀÇ
    »ç»ó°ú öÇÐ

  - ¿î¿µÀÚ ÇÖ¶óÀÎ
  - ¹®ÀÇ»çÇ×
  - Á¦ ÈÞ

-¸ð¹ÙÀÏÀÎÅͳݹæ¼Û
-VJ(PD)
   ÀÎÅͳݰø°£

-VJ(PD)
   ÀÎÅͳݹæ¼Û

-½Ã¹ÎÁ¦ÀÛ
   ÀÎÅͳݹæ¼Û

-½Ã»ç NEWS
-VJ(PD),
   ±âÀÚ, ÀÛ°¡

-ÈÄ¿ø¼îÇθô¿î¿µ

- VJ ÀÎÅͳݰø°£
- VJ ³×Æ®¿öÅ©¿¬°á
- VJ Çùȸ±¸¼º
- VJ È«º¸
- Video
   Journalist

- VJ À̸ÞÀϼ­ºñ½º

- ¿ì¸®Ã£±â
- Ä£ÀÏÆÄÀû±ØÀûû»ê
- µ¶µµ/°í±¸·Á ã±â
- ³²ºÏÅëÀϱ¹È£
   ÀÌÁ¨Corea

- ÀÒ¾î¹ö¸°Á¤½Å
   36³â ÀÏÁ¦Ä§·«

- Á¶¼±500³â¿ÕÁ¶
   ºÎÈ°¿îµ¿

- »õ¸¶À»¿îµ¿
   ±¹°¡°¡Ä¡°ü
   (»ç»óÀÌ ÀÖ¾ú´Ù.)

- ½Ã¹Î¿îµ¿¿¬´ë
- ¸ð¹ÙÀÏ ¹æ¼Û

- ¿µ¹® ±¹Á¦
   ±¹³»µµ¸ÞÀÎ

- Çѱ۵µ¸ÞÀÎ
- ÇѱÛÅ°¿öµå
  * µµ¸ÞÀÎ ±âȹ *
°í°´ Áö¿ø ¼¾ÅÍ
¢Ï 02) 2202 - 1009  
ÆòÀÏ : 10:00 ~ 18:00  
ÁÖ¸» : 10:00 ~ 14:00  
ÈÞ¹« & ÈÞÀÏ(°øÈÞÀÏÆ÷ÇÔ)
¢½±ä±Þ»çÇ× :
Mobile : 010-3079-1009

HOME >> ±³À° >> [ PHP ]
¢Ã Á¦¸ñ : PHP - ¼­¸¥ÀÏ°ö¹ø°³¯ (2005 01 10)
¢Ã ºÎÁ¦¸ñ : shop - DB³»¿ëÁ¾ÇÕ
 
PHP - ù°³¯ 1ÀÏ-11 19

PHP - µÑ°³¯ 2ÀÏ-11 22

PHP - ¼¼Â°³¯ (1123)

PHP - ³×°³¯ (1124)

PHP - ´Ù¼¸Â°³¯ (1125)

PHP - ¿©¼¸Â°³¯ (1126)

PHP - ÀÏ°ö°³¯ (1129+14½Ã°£)

PHP - ¿©´ú°³¯ (1130)

PHP - ¾Æȩ°³¯ (1201)

PHP - ¿­Â°³¯ (1202)

PHP - ¿­ÇÏ·ç°³¯ (1203)

PHP - ¿­µÑ°³¯ (1206)

PHP - ¿­¼¼Â°³¯ (1207)

PHP - ¿­³×°³¯ (1208)

PHP - ¿­´Ù¼¸Â°³¯ (1209)

PHP - ¿­¿©¼¸Â°³¯ (1210)

PHP - ¿­ÀÏ°ö°³¯ (1213)

PHP - ¿­¿©´ú°³¯ (1214)

PHP - ¿­¾Æȩ°³¯ (1215)

PHP - ½º¹°¹ø°³¯ (1216)

PHP - ½º¹°Çѹø¹ø°³¯ (1217)

PHP - ½º¹°µÎ¹ø°³¯ (1220)

PHP - ½º¹°µÎ¹ø°³¯ (2004/12/21)

PHP - ½º¹°¼¼¹ø°³¯ (2004/12/22)

PHP - ½º¹°³×¹ø°³¯ (2004/12/23)

PHP - ½º¹°³×¹ø°³¯ (2004/12/23)

PHP - ½º¹°´Ù¼¸¹ø°³¯ (2004/12/24)

PHP - ½º¹°¿©¼¸¹ø°³¯ (2004/12/26)

PHP - ½º¹°¿©´ú¹ø°³¯ (2004/12/28)

PHP - ½º¹°¿©´ú¹ø°³¯ (2004 12 28)

PHP - ½º¹°¾ÆÈ©¹ø°³¯ (2004 12 31)

PHP - ¼­¸¥µÎ¹ø°³¯ (2005 01 03)

PHP - ¼­¸¥¼¼¹ø°³¯ (2005 01 04)

PHP - ¼­¸¥³×¹ø°³¯ (2005 01 05)

PHP - ¼­¸¥´Ù¼¸¹ø°³¯ (2005 01 06)

PHP - ¼­¸¥¿©¼¸¹ø°³¯ (2005 01 07)

PHP - ¼­¸¥¿©´ú¹ø°³¯ (2005 01 11)

PHP - ¼­¸¥¾ÆÈ©¹ø°³¯ (2005 01 12)

PHP - ¸¶Èç¹ø°³¯ (2005 01 13)

PHP - ¸¶ÈçÇѹø°³¯ (2005 01 14)

PHP - ¸¶ÈçµÎ¹ø°³¯ (2005 01 17)

PHP - ¸¶Èç¼¼¹ø°³¯ (2005 01 18)

PHP - ¸¶Èç³×¹ø°³¯ (2005 01 19)



mysql>
mysql>
mysql> show tables;
+-------------------+
| Tables_in_appledb |
+-------------------+
| aaa               |
| admin             |
| bd_02             |
| bd_3              |
| board             |
| board1            |
| cart              |
| member            |
| memo              |
| mymemo            |
| product           |
| result            |
| zipcode1          |
+-------------------+
13 rows in set (0.00 sec)


 


mysql> desc aaa;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| aaa   | varchar(10) |      |     |         |       |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)


mysql> desc admin;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| adminid   | varchar(20) | YES  |     | NULL    |       |
| adminpass | varchar(20) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)


 


mysql> desc bd_02;
+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| code     | int(10) unsigned    |      | PRI | NULL    | auto_increment |
| bbs_code | varchar(20)         | YES  |     | NULL    |                |
| name     | varchar(20)         | YES  |     | NULL    |                |
| passwd   | varchar(20)         | YES  |     | NULL    |                |
| email    | varchar(50)         | YES  |     | NULL    |                |
| home     | varchar(100)        | YES  |     | NULL    |                |
| title    | varchar(255)        | YES  |     | NULL    |                |
| content  | text                | YES  |     | NULL    |                |
| reg_date | int(10) unsigned    | YES  |     | NULL    |                |
| count    | int(10) unsigned    | YES  |     | NULL    |                |
| ref      | int(10) unsigned    | YES  |     | NULL    |                |
| level    | tinyint(3) unsigned | YES  |     | NULL    |                |
| step     | tinyint(3) unsigned | YES  |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)


 


mysql> desc bd_3;
+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| code     | int(10) unsigned    |      | PRI | NULL    | auto_increment |
| bbs_code | varchar(20)         | YES  |     | NULL    |                |
| name     | varchar(20)         | YES  |     | NULL    |                |
| passwd   | varchar(20)         | YES  |     | NULL    |                |
| email    | varchar(50)         | YES  |     | NULL    |                |
| home     | varchar(100)        | YES  |     | NULL    |                |
| title    | varchar(255)        | YES  |     | NULL    |                |
| content  | text                | YES  |     | NULL    |                |
| reg_date | int(10) unsigned    | YES  |     | NULL    |                |
| count    | int(10) unsigned    | YES  |     | NULL    |                |
| ref      | int(10) unsigned    | YES  |     | NULL    |                |
| level    | tinyint(3) unsigned | YES  |     | NULL    |                |
| step     | tinyint(3) unsigned | YES  |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)


 


mysql> desc board;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| code     | int(10) unsigned |      | PRI | NULL    | auto_increment |
| bbs_code | varchar(20)      |      |     |         |                |
| name     | varchar(20)      |      |     |         |                |
| passwd   | varchar(20)      |      |     |         |                |
| email    | varchar(50)      |      |     |         |                |
| home     | varchar(100)     |      |     |         |                |
| title    | varchar(255)     |      |     |         |                |
| content  | text             |      |     |         |                |
| reg_date | int(10)          |      |     | 0       |                |
| count    | int(10)          |      |     | 0       |                |
| ref      | int(10)          |      |     | 0       |                |
| level    | tinyint(3)       |      |     | 0       |                |
| step     | tinyint(3)       |      |     | 0       |                |
+----------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)


 


mysql> desc board1;
+----------+-------------+------+-----+------------+----------------+
| Field    | Type        | Null | Key | Default    | Extra          |
+----------+-------------+------+-----+------------+----------------+
| num      | int(11)     |      | PRI | NULL       | auto_increment |
| name     | varchar(20) |      |     |            |                |
| email    | varchar(30) |      |     |            |                |
| hpage    | varchar(50) |      |     |            |                |
| subject  | varchar(70) | YES  |     | NULL       |                |
| content  | text        |      |     |            |                |
| dbpass   | varchar(20) |      |     |            |                |
| userip   | varchar(30) |      |     |            |                |
| reg_date | date        |      |     | 0000-00-00 |                |
| cnt      | int(11)     |      |     | 0          |                |
+----------+-------------+------+-----+------------+----------------+
10 rows in set (0.01 sec)


 


mysql> desc cart;
+---------------+------------------+------+-----+---------------------+-------+
| Field         | Type             | Null | Key | Default             | Extra |
+---------------+------------------+------+-----+---------------------+-------+
| product_id    | int(11)          |      |     | 0                   |       |
| product_name  | varchar(30)      |      |     |                     |       |
| product_price | int(10) unsigned |      |     | 0                   |       |
| product_count | int(10) unsigned |      |     | 0                   |       |
| added_time    | datetime         |      |     | 0000-00-00 00:00:00 |       |
| id            | varchar(30)      |      |     |                     |       |
+---------------+------------------+------+-----+---------------------+-------+
6 rows in set (0.00 sec)


 


mysql> desc member;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| num      | int(11)      |      | PRI | NULL    | auto_increment |
| userid   | varchar(20)  |      | UNI |         |                |
| userpass | varchar(20)  |      |     |         |                |
| question | varchar(150) |      |     |         |                |
| answer   | varchar(50)  |      |     |         |                |
| username | varchar(30)  |      |     |         |                |
| email    | varchar(50)  |      |     |         |                |
| jumin    | varchar(13)  |      |     |         |                |
| tel      | varchar(20)  |      |     |         |                |
| zip      | varchar(7)   |      |     |         |                |
| address  | varchar(50)  |      |     |         |                |
| job      | varchar(50)  |      |     |         |                |
| hobby    | varchar(50)  |      |     |         |                |
+----------+--------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)


 


mysql> desc memo;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| pid      | int(11)     |      |     | 0       |       |
| memoname | varchar(20) |      |     |         |       |
| memopass | varchar(30) |      |     |         |       |
| memo     | text        |      |     |         |       |
| step     | int(11)     |      |     | 0       |       |
+----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)


 


mysql> desc mymemo;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| num   | int(11)      |      | PRI | NULL    | auto_increment |
| name  | varchar(20)  |      |     |         |                |
| email | varchar(30)  |      |     |         |                |
| memo  | varchar(100) |      |     |         |                |
+-------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)


 


mysql> desc product;
+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| product_id     | int(11)          |      | PRI | NULL    | auto_increment |
| category_large | varchar(20)      |      |     |         |                |
| category_small | varchar(20)      |      |     |         |                |
| product_name   | varchar(20)      |      |     |         |                |
| product_price  | int(10) unsigned |      |     | 0       |                |
| product_remain | int(10) unsigned |      |     | 0       |                |
| product_doc    | text             |      |     |         |                |
| product_img    | varchar(50)      |      |     |         |                |
| product_type   | varchar(20)      |      |     |         |                |
| milage         | int(11)          |      |     | 0       |                |
+----------------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)


 


mysql> desc result;
+---------------+---------------------+------+-----+---------------------+----------------+
| Field         | Type                | Null | Key | Default             | Extra          |
+---------------+---------------------+------+-----+---------------------+----------------+
| result_id     | int(10) unsigned    |      | PRI | NULL                | auto_increment |
| id            | varchar(20)         |      |     |                     |                |
| pay_time      | datetime            |      |     | 0000-00-00 00:00:00 |                |
| pay_info      | varchar(20)         |      |     |                     |                |
| pay_check     | enum(`´ë±â`,`¿Ï·á`) | YES  |     | NULL                |                |
| product_id    | int(10) unsigned    |      |     | 0                   |                |
| product_price | int(10) unsigned    |      |     | 0                   |                |
| product_count | int(10) unsigned    |      |     | 0                   |                |
| total_price   | int(10) unsigned    |      |     | 0                   |                |
| send          | enum(`´ë±â`,`¿Ï·á`) | YES  |     | NULL                |                |
| tran_addr     | varchar(50)         |      |     |                     |                |
| product_name  | varchar(20)         |      |     |                     |                |
+---------------+---------------------+------+-----+---------------------+----------------+
12 rows in set (0.00 sec)


 


mysql> desc zipcode1;
+---------+--------------------------+------+-----+---------+-------+
| Field   | Type                     | Null | Key | Default | Extra |
+---------+--------------------------+------+-----+---------+-------+
| NUMBER  | int(9)                   | YES  |     | NULL    |       |
| STATE   | varchar(16)              |      |     |         |       |
| CITY    | varchar(20)              |      |     |         |       |
| ADDRESS | varchar(60)              |      |     |         |       |
| ETC     | varchar(80)              |      |     |         |       |
| INCH    | varchar(80)              |      |     |         |       |
| BS      | varchar(80)              |      |     |         |       |
| BE      | varchar(80)              |      |     |         |       |
| PNF     | int(3) unsigned zerofill |      |     | 000     |       |
| PNS     | int(3) unsigned zerofill |      |     | 000     |       |
| DDD     | char(3)                  |      |     |         |       |
+---------+--------------------------+------+-----+---------+-------+
11 rows in set (0.00 sec)


 


mysql>
mysql>
mysql>
mysql>
mysql>

Home| Á¤Ä¡| ±¹Á¦| »çȸ| °æÁ¦| ÈÞ¸Õ| ÀÚ¿¬| µ¿¹°| ¿ª»ç| ±â·Ï| °Ç°­| °úÇÐ| Àü½Ã| °¶·¯¸®| ¹Ú¹°°ü| ½ºÅ¸| °¡¼ö| ¹è¿ì| ÅÅ·±Æ®| ¸ðµ¨| µ¥ºß| ¹®ÀÎ| ¼­Àû| ¿¬±Ø| À½¾Ç| ¹Ì½½| ±³À° »ç´ÂÀ̾߱â | ¿µÈ­| ¾ð·Ð| ¿©Çà| Ã¥µ¿³×| Æ÷Åä°¶·¯¸®| e±â»ç´Â ³íÀïÁß ±¤ÁÖÀü³²| ´ë±¸°æºÏ| ÀüºÏÈñ¸Á| Àü³²µ¿ºÎ| ºÎ»ê°æ³²| ´ëÀüÃæ³²| ¹ÌÁÖ¼Ò½Ä| ¾Æ½Ã¾Æ| À¯·´ 6VJ-TV| ºñµð¿À Àú³Î¸®½ºÆ®(PD) ºñµð¿ÀÀú³Î¸®½º³×Æ®¿öÅ© ºñµð¿ÀÀú³Î¸®½ºÇùȸ ±âÀÚ¸¸µé±â | 6VJ°Ô½ÃÆÇ | °ø°³ÆíÁýȸÀÇ ¹æ¼ÛÆíÁýȸÀÇ
  6VJ ÀÌ¿ë ¾à°ü °³ÀÎÁ¤º¸ º¸È£Á¤Ã¥ ÀÎÅͳݾð·ÐÆíÁýȸÀÇ Contact Us    
  Copyright © 2003 by 6VJ.com All rights reserved [ºñµð¿ÀÀú³Î¸®½ºÆ® ³×Æ®¿öÅ© / À¥¸ÖƼĿ¹Â´ÏÄÉÀ̼Ç]
»ó È£: ºñµð¿ÀÀú³Î¸®½ºÆ®¡ºVJ¡»[õ±¹Ä¿¹Â´ÏÄÉÀ̼Ç]
°¨µ¶¡£ÀÌ ±â ¿ë     email: Lee@KY.co.kr
Àü±¹´ëÇ¥¹øÈ£: °í°´¼­ºñ½º-ÀüÁö¿ª
¢Ï1544¢¾0404
 
(4¶ûÇؿ䢾¿µ»ç¿µ»ç:2006.03.01~¼­ºñ½º¢Ñ¹æ¼ÛÁ¦ÀÛ ¹× ¹æ¼ÛÁ¦º¸)

¹æ¼Û: KBS MBC SBS CableTV
±¤°í: Business Product_CF AD
IT: WebProgram Design
BtoB: BusinessNetwork. WebBusinessConsulting
    ¸ð¹ÙÀÏ : 010 - 3079 - 1009   (050-2221-1009: Æò»ý¹øÈ£)
    ´ë Ç¥ :  02) 2202 - 1009   |  (050-2222-1009)
    ±â ȹ :  031) 709 - 1009   |  (050-2223-1009)
    Á¦ ÀÛ :  031) 707 - 1009   |  (050-2224-1009)
    ÆÑ ½º :  031) 702 - 1009   |  (050-2225-1009)
    ÆÑ ½º :  031) 758 - 1009   |  (050-2226-1009)
    ¢ÀÆò»ý¹øÈ£(050)´Â º¸¸§µ¿¾È(2007³â1¿ù16ÀÏ~) ½ÃÇè¹æ¼Û°ü°è·Î ¼­ºñ½º¿¡ È¥µ¿À» µå¸± ¼ö ÀÖÀ¸´Ï ÀÌ¿ëÇÏÁö ¸¶½Ã±æ ¹Ù¶ø´Ï´Ù.(Æò»ó½Ã¿¡´Â ÀϹÝÀüÈ­¿Í µ¿ÀÏÇÏ°Ô »ç¿ëµË´Ï´Ù.)
¿ì Æí: 463-839.°æ±âµµ ¼º³²½Ã ºÐ´ç±¸ ¾ßžµ¿526¹øÁö °æ³²¾ÆÆÄÆ®»ó°¡.ÄÄ¾Ø³Ý º¥Ã³¿ÀÇǽº 111È£ õ±¹Ä¿¹Â´ÏÄÉÀ̼Ç
¡¼ºñµð¿ÀÀú³Î¸®½ºÆ®-6VJ.com¡½ ºñµð¿ÀÀú³Î¸®½ºÆ® (ÇÁ¸®·»¼­ ÇÁ·Îµà¼­µéÀÇ ³×Æ®¿öÅ© À¥¸ÖƼĿ¹Â´ÏÄÉÀ̼Ç)
::::::: ¿ì¸®°¡ »ì¾Æ°¡´Â À̼¼»ó¿¡¼­ »ç¶û°ú Çູ ȤÀº ¹Ì¿ò°ú ½½ÇÄÀÌ Á¸ÀçÇÏ´Â À̼¼»óÀ» ¹Ù¶óº¼ ¼ö ÀÖ´Â ³»°¡ ÇöÀç ¼û½¬°í ÀÖ´Â µ¿¾È¿¡
Á¸ÀçÇÏ´Â ¼¼»ó°ú ´õºÒ¾î ¿ìÁÖ¼Ó¿¡ ¸ÕÁö¿Í °°ÀÌ µ¹°íµµ´Â À̼¼»óÀÌ Ãµ±¹ÀÔ´Ï´Ù. ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::