´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net)
ID¿Í Password¸¦ ÀÔ·ÂÇϼ¼¿ä.
ÀÔ±¹Çϱâ
|
¿µÁÖ±Ç ½Åû
¸öºÎ¸² °ñ¶ó°ñ¶ó
¼Ò±Ù¼Ò±Ù
µµ¶õµµ¶õ
³«¼¸¶´ç
Âø°¢ÇѾÆÀÌ
¼ýÀÚ¸ÂÃß±â
¼Ò¿øºô±â
ÈçÀû³²±â±â
²Þ¼Ó¿©Çà
Ä£±¸Áý ³î·¯°¡±â
¸ðµÎµå¸²´ÔÀÇ È¨
î¤éÞ´ÔÀÇ È¨
Çö¿ì´ÔÀÇ È¨
º°¾ÆÇØ´ÔÀÇ È¨
ÇÞ»ì´ÔÀÇ È¨
À̳ª´Ï´ÔÀÇ È¨
À¯¸®¾Ë´ÔÀÇ È¨
³È³ÈÀÌ´ÔÀÇ È¨
²ÀÁö´ÔÀÇ È¨
´ë¼º´ÔÀÇ È¨
µî·ÏÇϽǶ§´Â ÇʼöÇ׸ñÀ» ¸ðµÎ ÀÔ·ÂÇÏ¼Å¾ß ÇÕ´Ï´Ù.
À̸§
*
HTML »ç¿ë
Á¦¸ñ
*
¼±ÅÃ
ÀÚÀÛ
»ç¶û
À¯¸Ó
ÀÚÀ¯
̵̧
¾Ë¸²
Áú¹®
±âŸ
³»¿ë
*
> ¾È³çÇϼ¼¿ä ? > ¾ó¸¶³ª µÆ´Ù°í ¶Ç ´Ù½Ã ÀÌ·¸°Ô ±ÛÀ» ³²±â°Ô µÇ³×¿ä. > Á¦°¡ Á¤¸»·Î ¾Ë°í ½ÍÀº °ÍÀº µ¥ÀÌÅÍ¿¡ À̹ÌÁö¸¦ ³²±â°í ½Í¾î¼ ÀÔ´Ï´Ù.¹°·Ð À¥»ó¿¡¼ »Ñ·ÁÁö´Â °ÍÀº ´ç¿¬ÇÏ°í¿ä. > ¹°·Ð µ¥ÀÌÅÍ¿¡ Á÷Á¢ µé¾î°¡¸é µ¥ÀÌÅÍ°¡ Èû°Ü¿ï¼ö ÀÖÀ¸´Ï±î,images¶ó´Â Æú´õ¿¡ À̹ÌÁö¸¦ ÀúÀå½ÃÅ°°í db¿£ ±× °æ·Î¸¸ ÁöÁ¤ÇÏ´Â ¹æ¹ýÀ» »ç¿ëÇÏ·Á°í Ç߰ŵç¿ä. > ±×·±µ¥ ÀÌÁö ÀÔ·ÂÀÌ µÇÁö ¾Ê´Â°Í °°Àºµ¥¿ä > ÇØ°á ¹æ¹ý Á»¾Ë°í ½Í½À´Ï´Ù.. > ÀÌ·¸°Ô Ç߰ŵç¿ä.¿ì¼± ÀÔ·Â ¸ðµå¿¡¼ > input type="file" size="40" maxlength="250" name="images" > ÀÌ·±½ÄÀ¸·Î ¹Þ¾Ò±¸¿ä.. > ±× ´ÙÀ½¿¡ ³Ñ±â´Â ºÎºÐ¿¡¼´Â ÀÌ·¸°Ô Ç߰ŵç¿ä > <% > 'request °³Ã¼¸¦ ÅëÇØ ³Ñ¾î¿Â °ªµéÀ» º¯¼ö¿¡ ÀúÀåÇÑ´Ù. > name = request("name") > email = request("email") > url = request("url") 'ȨÆäÀÌÁö > title = request("title") > company = request("company") > shipment = request("shipment") > desired = request("desired") > country = request("country") > vdate = request("vdate") > mcode = request("mcode") > pregident = request("pregident") > depart = request("depart") > addre = request("addre") > tel = request("tel") > fax = request("fax") > images = request("images") > pwd = request("pwd") > content = request("content") > > > > > set db = server.CreateObject("ADODB.Connection") > 'µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» À§ÇÑ Connetion°³Ã¼ÀÇ ÀνºÅϽº¸¦ »ý¼ºÇÑ´Ù. > db.Open("sell") > 'db open(DNS)DNS¿¬°á > SQL = "Select MAX(num) as maxnum from myboard" > 'µ¥ÀÌÅÍ Äõ¸®¹® > set rs = Server.CreateObject("ADODB.Recordset") > '·¹ÄÚµå¼Â ÀνºÅϽº »ý¼º > rs.Open SQL,db > 'ÁöÁ¤ÇÑ Äõ¸®·Î db¿¬°á....·¹ÄÚµå¼Â °³Ã¼ °á°ú dbÀúÀå > > If rs("maxnum")="" Then > number = 1 > else > number = rs("maxnum") + 1 > End If > > > > > SQL = "INSERT INTO myboard(name,email,url,title,company,shipment,desired,country,vdate, > mcode,pregident,depart,addre,tel,fax,images,content," > SQL = SQL & " readnum,writeday,pwd)VALUES " > SQL = SQL & "('" & name & "'" > SQL = SQL & ",'" & email & "'" > SQL = SQL & ",'" & url & "'" > SQL = SQL & ",'" & title & "'" > SQL = SQL & ",'" & company & "'" > SQL = SQL & ",'" & shipment & "'" > SQL = SQL & ",'" & desired & "'" > SQL = SQL & ",'" & country & "'" > SQL = SQL & ",'" & vdate & "'" > SQL = SQL & ",'" & mcode & "'" > SQL = SQL & ",'" & pregident & "'" > SQL = SQL & ",'" & depart & "'" > SQL = SQL & ",'" & addre & "'" > SQL = SQL & ",'" & tel & "'" > SQL = SQL & ",'" & fax & "'" > SQL = SQL & ",'" & images & "'" > SQL = SQL & ",'" & content & "'" > SQL = SQl & ",0,'" & now() & "'" > SQL = SQL & ",'" & pwd & "')" > > > db.execute SQL 'µ¥ÀÌÅͺ£À̽º¿¡insertÄõ¸®¸¦ º¸³» »õ·Î¿î µ¥ÀÌÅÍ ÀÔ·Â > > > rs.Close > db.Close > Set rs = Nothing > Set db = Nothing > > Response.redirect "list.asp" > > %> > > ´Ù¸¥ °Í°ú ¸¶Âù°¡Áö·Î ÀÌ·¸°Ô Ç߰ŵç¿ä.±×¸®°í µðºñ´Â ÅؽºÆ®·Î Çß½À´Ï´Ù.¾ÆÁ÷ ÀÌ·±°ÍÀº °æÇèÀÌ ºÎÁ·Çؼ¸® ¸»ÀÔ´Ï´Ù...Á¶¾ð ºÎŹµå¸³´Ï´Ù. > response.write.sqlÇغ¸´Ï±î, ÀÌ·± °á°ú°¡ ³ª¿À´øµ¥ > ³Ñ°ÜÁö±ä Çϴµ¥ À̹ÌÁö´Â ³ª¿ÀÁö ¾Ê°í/±âÈ£¸¸ ³ª¿À³×¿ä -----------------------------------------------------------
Ãß°¡ÇÒ À̹ÌÁö¸¦ ÀÔ·ÂÇϼ¼¿ä.
À̹ÌÁö 1
À̹ÌÁö¼³¸í 1
Ãß°¡ÇÒ ÀڷḦ ÀÔ·ÂÇϼ¼¿ä.
ÀÚ·á 1
ÀÚ·á¼³¸í 1
Ãß°¡ÇÒ ½ÎÀÌÆ®¸¦ ÀÔ·ÂÇϼ¼¿ä.
°ü·Ã½ÎÀÌÆ® 1
½ÎÀÌÆ®¼³¸í 1
Password
*