|
|
|
|
ûÇæÔñýѨ / 2003-06-19 / ¿ÀÀü 1:36:48 / 220.84.136.91
Á¶È¸¼ö : 204
|
[Áú¹®] Ʋ¸°ºÎºÐ ¼öÁ¤ Á» ºÎŹµå¸±²²¿ä.. |
> asp¸¦ °øºÎÇÏ°í ÀÖ´Â Ãʺ¸ÀÔ´Ï´Ù...
> È¥ÀÚÀÇ ÈûÀ¸·Î °Ô½ÃÆÇ ¸¸µé±â¸¦ ÇÏ°í ÀÖ½À´Ï´Ù,.,
> ±Ùµ¥¿ä..list ÆäÀÌÁö¿¡¼...¸îÁÙ¾¿ º¸±â Çຸ±â¶ó°í Çϳª¿ä...Ŭ¸¯Çϸé...10°³ ¶Ç´Â 15,20°³¾¿ º¸ÀÌ´Â°Í ¸»ÀÔ´Ï´Ù...È¥ÀÚ ±¸ÇöÇغ¼·Á±¸ Çߴµ¥..
> Àß ¾È‰Ï´Ï´Ù...
> ¾Æ·¡¿¡ ¼Ò½º¸¦ ºÙÀÌ´Ï...¾Æ½Ã´Â ºÐÀº ¾îµð°¡ À߸øµÆ´ÂÁö Áöµµ Á» ºÎŹµå¸³´Ï´Ù...Á¦¹ß¿ä..¤Ð¤Ð
> list.asp Àüü ¼Ò½º ÀÔ´Ï´Ù..
>
> <%
> if request("page")="" then
> page=1
> else
> page=request("page")
> end if
>
> set db=server.createobject("adodb.connection")
> db.open "mysitedb","sa","asp"
>
> sql="select * from MyBoard ORDER BY m_num DESC"
>
> set rs=server.createobject("adodb.recordset")
>
> 'ÆäÀÌÁö Å©±â°ª¾ò±â..
> select2=request(select2)
>
> if(Cint(select2)>0) then
> rs.pagesize=select2 'ÆäÀÌÁö»çÀÌÁî ÁöÁ¤. ¹Ýµå½Ã ·¹ÄÚµå¼Â¿ÀÇÂÀü¿¡ ÁöÁ¤ÇؾßÇÔ..
> else
> rs.pagesize=5
> end if
> rs.open sql,db,1
> %>
>
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <title>Untitled Document</title>
> <meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
> <script language="javascript">
> function selFunc()
> {
> location.reload();
> }
> </script>
>
> </head>
>
> <body>
> <%if rs.BOF or rs.EOF then%>
> <center>¾Æ¹«µ¥ÀÌŸ ¾ø½¿´ç</center>
> <%
> else
> totalpage=rs.pagecount 'ÃÑÆäÀÌÁö¼ö¸¦ totalº¯¼ö¿¡ ³Ñ..
> rs.absolutepage=page 'ÁöÁ¤µÈ ÆäÀÌÁö·Î ·¹ÄÚµåÀÇ ÇöÀçÀÇ À§Ä¡¸¦ À̵¿
> %>
> <table width="75%" border="0" align="center">
> <tr>
> <td><table width="588" border="0" align="center">
> <tr>
> <td><div align="center"><font color="#000066" size="6"><strong>My List</strong></font></div></td>
> </tr>
> </table>
> <table width="588" border="0" align="center">
>
> <tr>
>
> <td width="185" height="58"><p><a href="write.htm"><img src="bullet2-02161.gif" width="15" height="16" border=0><font size="2">write</font></a></p>
> </td>
> <td width="393"> <div align="right"><font size="2">Çà º¸±â
>
> <select name="select2" onchange="selFunc();">
> <option value="5" selected> 5°³</option>
> <option value="10">10°³</option>
> <option value="15">15°³</option>
> <option value="20">20°³</option>
> <option value="25">25°³</option>
> <option value="30">30°³</option>
> </select>
> </font> </div></td>
> </tr>
>
> </table>
> <table width="588" border="0" align="center">
> <tr>
> <td width="11%" height="30" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>¹øÈ£</strong></font></div></td>
> <td width="18%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>±Û¾´ÀÌ</strong></font></div></td>
> <td width="19%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>³¯Â¥</strong></font></div></td>
> <td width="41%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>Á¦¸ñ</strong></font></div></td>
> <td width="11%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>Á¶È¸¼ö</strong></font></div></td>
> </tr>
> <%
> i=1
> do until rs.EOF or i>rs.pagesize
> %>
> <tr>
> <td bgcolor="#FFFFCC"><div align="center"><%=rs("m_num")%></div></td>
> <td bgcolor="#FFFFCC"><div align="center"><a href="mailto:<%=rs("m_email")%>"><%=rs("m_name")%></a></div></td>
> <td bgcolor="#FFFFCC"><div align="center"><%=left(rs("m_writeday"),10)%></div></td>
> <td bgcolor="#FFFFCC"><div align="center"><a href="read.asp?idx=<%=rs("m_board_idx")%>"><%=rs("m_title")%></a></div></td>
> <td bgcolor="#FFFFCC"><div align="center"><%=rs("m_readnum")%></div></td>
> </tr>
> <%
> rs.MoveNext
> i=i+1
> loop
> %>
> <%end if%>
> </table>
> <hr align="center" width="588"> <p> </p>
> <center><font size=2>
> <%if page <> 1 then%>
> <<a href="list.asp?page=<%=page-1%>">ÀÌÀüÆäÀÌÁö</a>>
> <%end if%>
> <%if cint(page) <> cint(totalpage) then%>
> <<a href="list.asp?page=<%=page+1%>">´ÙÀ½ÆäÀÌÁö</a>>
> <%end if%>
>
> <%=page%>page/<%=totalpage%>pages
> </font></center>
> </td>
> </tr>
> </table>
> <p> </p>
> </body>
> </html>
> <%
> rs.close
> db.close
> set rs=nothing
> set db=nothing
> %>
>
> ºÎŹµå¸³´Ï´Ù..¾Ë·ÁÁÖ¼¼¿ä
-----------------------------------------------------------
Ʋ¸° ºÎºÐÀ» ¾Ë°í ½Í´Ù¸é Ʋ¸° ºÎºÐÀ» ¿Ã·Á ÁּžßÁö¿ä.
¿¡·¯°¡ ³´Ù¸é ¿¡·¯ ¸Þ¼¼Áö¸¦ ¿Ã·Á Áֽñ⠹ٶø´Ï´Ù.
¿¡·¯ ¸Þ¼¼Áö¿¡ ´Ô²²¼ ½Ç¼öÇϽŠ³»¿ëÀÌ ³ª¿Í ÀÖÀ¸´Ñ±î¿ä.
Àüü ¼Ò½º¸¦ ´Ù µÚÁ® º¸°í ÀÖÀ» ¼ö´Â ¾øÁö¿ä~~ ^^
|
|
|
|