|
|
Ŭ¶ó¿ìµåű×
Javascript PHP ASP CSS HTML MYSQL jquery image Mobile API slide °Ô½ÃÆÇ ¸Þ´º
|
|
|
ÇöÀçÁ¢¼ÓÀÚ ¸í |
|
|
|
|
|
|
|
DDOONG MAILLING - php ¸ÞÀϸµ |
|
|
|
|
¼Ò½ººÐ·ù |
¸ÞÀϸµ ¸®½ºÆ® |
|
|
´Ù¿î·Îµå Ƚ¼ö |
1266 ȸ |
|
|
|
°£´Ü¼³¸í |
php·Î Á¦ÀÛµÈ ¸ÞÀϸµ ¸®½ºÆ® ÇÁ·Î±×·¥ÀÔ´Ï´Ù. µî·ÏÇØ ³õÀº ȸ¿ø Áß È¸¿øµî±Þ, Á÷¾÷, ¼ºº°, ¸ÞÀϸµ °¡ÀÔ¿©ºÎ¿¡ µû¸¥ ºÐ·ù¸¦ ´ÙÁß ¼±ÅÃÇÏ¿© ÇØ´çÁ¶°Ç¿¡ ¸Â´Â ȸ¿ø¿¡°Ô¸¸ ¸ÞÀÏÀ» º¸³¾ ¼ö ÀÖ½À´Ï´Ù. |
|
|
|
|
|
==========¼³Ä¡ ¹æ¹ý
1. ¾ÐÃàÀ» Ǭ»óÅ¿¡¼ /adminZone/mailling µð·ºÅ丮¸¦ ¼¹ö¿¡ ¾÷·Îµå ½ÃÄÑÁÖ½Ã¸é µË´Ï´Ù. [[ ÆÄÀϱ¸Á¶ Âü°í ]]
2. mailling°ü·Ã Å×À̺í 2°³¸¦ »ý¼ºÇÏ°í ±âº»Ä«Å×°í¸®¸¦ ÀÔ·ÂÇÕ´Ï´Ù.
CREATE TABLE mailling (
id int(6) NOT NULL default ``0``,
cateID tinyint(2) NOT NULL default ``0``,
maillingType enum(``P``,``C``) NOT NULL default ``P``,
sendName varchar(60) NOT NULL default ````,
sendEmail varchar(60) NOT NULL default ````,
subject varchar(120) NOT NULL default ````,
rDate int(10) NOT NULL default ``0``,
status enum(``Y``,``N``) NOT NULL default ``Y``,
content text NOT NULL,
PRIMARY KEY (id),
KEY category (cateID)
) TYPE=MyISAM COMMENT=``ȸ¿ø ¸ÞÀϸµ¸®½ºÆ®``;
CREATE TABLE maillingCategory (
id tinyint(2) NOT NULL default ``0``,
maillingType enum(``P``,``C``) NOT NULL default ``P``,
category varchar(60) NOT NULL default ````,
PRIMARY KEY (id)
) TYPE=MyISAM;
INSERT INTO maillingCategory VALUES (1, ``P``, ``ȸ¿ø °¡ÀÔ``);
INSERT INTO maillingCategory VALUES (2, ``P``, ``ȸ¿ø Å»Åð``);
INSERT INTO maillingCategory VALUES (3, ``P``, ``´º½º·¹ÅÍ``);
INSERT INTO maillingCategory VALUES (4, ``P``, ``¾÷µ¥ÀÌÆ® ¾È³»``);
¡Ø À§ µ¥ÀÌŸ Áß 1, 2¹øÀÇ È¸¿ø°¡ÀÔ, ȸ¿øÅ»Åð Ä«Å×°í¸®´Â ȸ¿ø°ü¸®¿¡¼ÀÇ °¡ÀÔ, Å»Åð½Ã ¸ÞÀϺ¸³»±â¿Í ¿¬°üÀÌ ÀÖÀ¸´Ï id°ªÀ» º¯°æÇÏ¸é ¾ÈµË´Ï´Ù.
3. °ü¸®ÀÚ ¸ðµå¿¡¼ ¸ÞÀϸµ µî·ÏÀ» ÇÏ½Ã¾î »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.
¡Ø ¸ðµç ¼³Ä¡ °úÁ¤ÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù.
ÀÚ¼¼ÇÑ ¼³Ä¡ ¹æ¹ýÀº http://www.ddoong.net¿¡¼ È®ÀÎÇϼ¼¿ä. ^^
|
|
³×ƼÁð ÀÇ°ß ÀÌ¿ëÇϽŠÀÚ·áÀÇ Èı⸦ ÀÚÀ¯·Ó°Ô ÀÛ¼ºÇϼ¼¿ä. (»ó¾÷ÀûÀÎ ±¤°í ¹× µµ¹è¼º ±Û µîÀº »çÀüÅ뺸¾øÀÌ »èÁ¦µÉ ¼ö ÀÖ½À´Ï´Ù.) |
|