|










|
|
|
 |
0 |
|
View Articles |
|
 |
 Name |
¹ÙÅõ |
(2003-05-20 00:04:42, Hit : 17143, Vote : 2039)
|
|
 |
Subject |
 Èì ¹øÈ£ |
 |
 |
¹øÈ£°¡ 1¹øÀ¸·Î ¾È³ª¿À°í 11¹øºÎÅÍ ½ÃÀÛ ÇÏ´Â °Å¶ó¼ Áú¹®ÀÌ¿ä
¾î¶² °ÇÁö ¸ô¶ó¼ list, view µÑ ´Ù ¿Ã¸³´Ï´Ù.
list.php
<?
//db¿¡ ¿¬°áÇÏ´Â ºÎºÐÀÔ´Ï´Ù. Ç×»ó ¹Ýº¹ µÇ´Â ºÎºÐÀÌ´Ï ²À ¾Ï±â!!
mysql_connect("localhost","phpbbs","phpbbs") or die(mysql_error());
mysql_select_db("itmembers");
//°Ô½ÃÆÇ ¸ñ·Ï º¸±â¿¡ ÇÊ¿äÇÑ °¢Á¾ º¯¼ö ÃʱⰪÀ» ¼³Á¤
$tablename="bbs";//Å×À̺í À̸§
if($page=='') $page=1;//ÆäÀÌÁö ¹øÈ£°¡ ¾ø´Ù¸é 1
$list_num=10;//ÇÑÆäÀÌÁö¿¡ º¸¿©ÁÙ ¸ñ·Ï °¹¼ö
$page_num=10;//ÇÑȸ鿡 º¸¿©ÁÙ ÆäÀÌÁö ¸µÅ©(¹À½) °³¼ö
$offset=$list_num*($page-1);//ÇÑ ÆäÀÌÁöÀÇ ½ÃÀÛ ±Û ¹øÈ£(listnum¼ö¸¸Å ³ª´©¾úÀ» 떄 ½ÃÀÛÇÏ´Â ±ÛÀÇ ¹øÈ£
//Àüü ±Û ¼ö¸¦ ±¸ÇÑ´Ù.(Äõ¸®¹®À» »ç¿ë °á°ú¸¦ ¹è¿·Î ÀúÀåÇÏ´Â ÀϹÝÀûÀÎ ¹æ¹ý)
$query="select count(*) from $tablename";//bbs Å×À̺íÀÇ ·¹ÄÚµå ¼ö¸¦ ±¸ÇÏ´Â Äõ¸®¹®À» $query º¯¼ö¿¡ ÀúÀåÇÑ °ÍÀÔ´Ï´Ù.
$result=mysql_query($query) or die(mysql_error());//À§ÀÇ Äõ¸®¹®À» ½ÇÇàÇÏ¿© °á°ú¸¦ result¿¡ ´ëÀÔ,½ÇÆÐÇÏ¸é ¿¡·¯ ¸Þ½ÃÁö Ç¥½Ã
$row=mysql_fetch_row($result);//$row=mysql_fetch_row($result); ¿Í °°ÀÌ ÇÏ¿´´Ù¸é,$row[0]¿¡ ½ÇÇà °á°úÀÇ Ã³À½ °ªÀÌ µé¾î°¡°ÚÁÒ. 15ÇàÀÇ Äõ¸® °á°ú´Â Àüü ·¹ÄÚµå ¼ö¸¦ ±¸ÇÏ´Â °ÍÀ̹ǷΠÇϳªÀÇ °ª¸¸ ¸®ÅÏÇÏ°Ô µÇ¹Ç·Î °á±¹ $row[0]ÀÇ °ª¸¸ ÀÖÀ¸¸é µÇ´Â °Ì´Ï´Ù. ¸¸¾à 24Çà¿¡¼ÀÇ °°Àº Äõ¸®¶ó¸é ±× °á°ú·Î $row[0], $row[1], $row[2]... ¿Í °°ÀÌ Â÷·Ê´ë·Î ÀúÀåÀÌ µÉ °ÍÀÔ´Ï´Ù. ´Ü ÀÌ ÇÔ¼ö´Â ÇϳªÀÇ ·¹Äڵ忡¿¡¸¸ ÇØ´çµÇ¹Ç·Î ¿©·¯ ·¹ÄÚµåÀÇ °á°ú °ªÀ» Â÷·Ê´ë·Î ¾òÀ»·Á¸é ·¹ÄÚµå ¼ö¸¸Å ¹Ýº¹ÇØ¾ß ÇÕ´Ï´Ù.63ÇàÀº º¸¸é while ¹®À» »ç¿ëÇÏ¿© ·¹ÄÚµå ¼ö¸¸Å ¹Ýº¹ÇÏ¿© ±× °á°ú°ªÀ» ¹è¿·Î ÀúÀåÇÏ´Â ¿¹°¡ µÇ°Ú½À´Ï´Ù.
$total_no=$row[0];//¹è¿ÀÇ Ã¹¹øÂ° ¿ä¼ÒÀÇ °ª, Áï Å×À̺íÀÇ Àüü ±Û ¼ö¸¦ ÀúÀå!
//Àüü ÆäÀÌÁö ¼ö¿Í ÇöÀç ±Û ¹øÈ£¸¦ ±¸ÇÑ´Ù.
$total_page=ceil($total_no/$list_num);//Àüü ±Û¼ö¸¦ ÆäÀÌÁö´ç ±Û¼ö·Î ³ª´« °ªÀÇ ¿Ã¸²°ªÀ» ±¸ÇÔ..Áï Àüü ±Û ¼ö°¡ 55°³¶ó¸é, 55/10 = 5.5 À̹ǷΠ¿Ã¸² ¼öÀ̴ϱî 6ÀÌ µÇ°ÚÁÒ.Áï 55°³ÀÇ ±ÛÀ» ¸ðµÎ Ç¥½ÃÇÏ·Á¸é 6ÆäÀÌÁö°¡ ÇÊ¿äÇÏ´Ù´Â °Ì´Ï´Ù.
$cur_num=$total_no-$list_num*(page-1);//ÇöÀç ±Û ¹øÈ£
//bbsÅ×ÀÌºí¿¡¼ ¸ñ·ÏÀ» °¡Á® ¿É´Ï´Ù.(À§ÀÇ Äõ¸®¹® »ç¿ë¿¹¿Í ºñ½Á!
$query="select * from $tablename order by number desc limit $offset, $list_num";//bbs Å×ÀÌºí¿¡¼ ¸ðµç °ÍÀ» ºÒ·¯¿ÀµÇ, number Çʵå(Ä÷³)¸¦ ±âÁØÀ¸·Î ³»¸²Â÷¼øÀ¸·Î Á¤·ÄÇÏ¿© Ç¥½ÃÇ϶ó´Â ¹®ÀåÀÔ´Ï´Ù. ´Ü $offset ÇàºÎÅÍ $list_num °³¸¸Å ºÒ·¯¿À¶ó´Â ¶æÀÔ´Ï´Ù. $offset º¯¼ö¿¡´Â ÇÑ ÆäÀÌÁöÀÇ ½ÃÀÛ ±Û ¹øÈ£°¡ ÀúÀåµÇ¾î ÀÖ°í, $list_num¿¡´Â ÇÑ ÆäÀÌÁö¿¡ Ç¥½ÃÇÒ ¸ñ·ÏÀÇ °³¼ö°¡ ÀúÀåµÇ¾î ÀÖ½À´Ï´Ù.
$result=mysql_query($query) or die(mysql_error());//Äõ¸®¹®À» ½ÇÇà °á°ú
//Äõ¸® °á°ú¸¦ Çϳª¾¿ ºÒ·¯¿Í ½ÇÁ¦ html¿¡ ³ªÅ¸³»´Â °ÍÀº html¹® Áß°£¿¡ »ðÀÔ!
?>
<html>
<head>
<meta http-equiv=content-type content=text/htm; charset=euc-kr>
<title>±Û¸ñ·Ï º¸±â</title>
<STYLE TYPE=text/css>
BODY,TD,SELECT,input,div,form,TEXTAREA,center,option,pre,blockqute{font-family:±¼¸²;font-size:9pt;color:#555555;}
A:link {color:black;text-decoration:none;}
A:active{color:black;text=decoration:none;}
A:hover{color:gray;text-decoration:none;}
</STYLE>
</head>
<body background=/image/body_bg.gif>
<img src=./images/maintitle.gif>
<table border=1 cellspacing=0 width=680 bordercolordark=white bordercolorlight=#999999>
<tr>
<td width=30 bgcolor=#CCCCC>
<p align=center>no</p>
</td>
<td bgcolor=#CCCCC width=490>
<p align=center> subject</p>
</td>
<td width=60 bgcolor=#CCCCC>
<p align=center>name</p>
</td>
<td width=80 bgcolor=#CCCCC>
<p align=center>date</p>
</td>
<td width=30 bgcolor=#CCCCC>
<p align=center>hit</p>
</td>
</tr>
<?
while($array=mysql_fetch_array($result))//mysql_fetch_array() ÇÔ¼ö´Â Àü ½Ã°£¿¡ ´Ù·ç¾ú´ø mysql_fetch_row()¿Í ¸¶Âù°¡Áö·Î Äõ¸®ÀÇ °á°ú¸¦ ¹è¿ ÇüÅ·Π<u>ÇÑ ÁÙ¾¿</u> ¸®ÅÏÇÏ´Â ±â´ÉÀ» ÇÕ´Ï´Ù.
{
$date=date("Y/m/d",$array[writetime]);//$array[wirtetime]ÀÇ °ªÀ» ³â(Y)/¿ù(m)/ÀÏ(d)ÀÇ ÇüÅ·Πǥ½ÃÇ϶ó´Â ¶æÀÔ´Ï´Ù.
echo"
<tr>
<td width=30>
<p align=center>$cur_num</p>
</td>
<td width=490>
<p><a href='view.php?page=$page=$page&number=$array[number]'>$array[subject]</p>
</td>
<td width=60>
<p align=center>$array[name]</p>
</td>
<td width=70>
<p align=center>$date</p>
</td>
<td width=30>
<p align=center>$array[count]</p>
</td>
</tr>";
$cur_num--;
}
?>
<tr>
<td width=100% colspan=5>
<?
//¿©±â¼ ºÎÅÍ °¢Á¾ ÆäÀÌÁö ¸µÅ©>
//¸ÕÀú ÇÑ È¸é¿¡ º¸ÀÌ´Â ºí·Ï($page_num ±âº»°ª ÀÌ»óÀÏ ¶§ ºí·ÏÀ¸·Î ³ª´µ¾îÁü)
$total_block=ceil($total_page/$page_num);//°Ô½ÃÆÇ Àüü ºí·Ï¼ö¸¦ ±¸ÇÏ´Â ¹ý
$block=ceil($page/$page_num);//ÇöÀç ºí·Ï
$first=($block-1)*$page_num;//ÆäÀÌÁö ºí·ÏÀÌ ½ÃÀ۵Ǵ ù ÆäÀÌÁö
$last=$block*$page_num;//ÆäÀÌÁö ºí·ÏÀÇ ³¡ ÆäÀÌÁö
if($block>=$total_block){
$last=$total_page;
}
echo"
$nbs <p align=center>";
//[óÀ½][*°³¾Õ]
if($block>1){
$prev=$first-1;
echo"<a href=list.php?page=1>[óÀ½],</a> ";
echo"<a href=list.php?page=$prev>[$page_num °³ ¾Õ]</a>";
}
//[ÀÌÀü]
if($page>1){
$go_page=$page-1;
echo"<a href='list.php?page=$go_page'>[ÀÌÀü]</a> ";
}
//ÆäÀÌÁö ¸µÅ©
for($page_link=$first+1;$page_link<=$last;$page_link++){
if($page_link==$page){
echo"<font color=green><b>$page_link</b></font>";
}
else{
echo"<a href='list.php?page=$page_link'>[$page_link]</a>";
}
}
//´ÙÀ½
if($total_page>$page){
$go_page=$page+1;
echo" <a href='list.php?page=$go_page'>[´ÙÀ½]</a>";
}
//[*°³µÚ][¸¶Áö¸·]
if($block<$total_block){
$next=$last+1;
echo",a href='list.php?page=$next'>[$page_num °³ µÚ]</a> ";
echo"<a href='list.php?page=$total_page'>[¸¶Áö¸·]</a></p>";
}
?>
</td>
</tr>
<tr>
<td width=100% colspan=5>
<p align=center><a href='write.php'>[±Û¾²±â]</a></p>
</td>
</tr>
</table>
</body>
</html>
view.php
<?
mysql_connect("localhost","phpbbs","phpbbs") or die(mysql_error());
mysql_select_db("itmembers");
$tablename="bbs";
$query="select * from $tablename where number='$number'";//±Û¹øÈ£¸¦ °¡Áö°í Á¶È¸¸¦ ÇÑ´Ù.
$result=mysql_query($query) or die(mysql_error());
$array=mysql_fetch_array($result);
//¹é½½·¯½¬ Á¦°Å, Ư¼ö¹®ÀÚ º¯È¯(html¿ë),°³Çü(<br>ó¸® µî
$array[name]=stripslashes($array[name]);
$array[subject]=stripslashes($array[subject]);
$array[memo]=stripslashes($array[memo]);
$array[subject]=htmlspecialchars($array[subject]);
$array[memo]=htmlspecialchars($array[memo]);
$array[memo]=nl2br($array[memo]);
//Á¶È¸¼ö Ä«¿îÅÍ Áõ°¡
$query="update $tablename set count=count+1 where number=$number";
mysql_query($query);
?>
<html>
<head>
<title>PHP°Ô½ÃÆÇ ÇÁ·ÎÁ§Æ®-º¸±â></title>
<STYLE TYPE="text/css">
BODY,TD,SELECT,input,DIV,form,TEXTAREA,center,option,pre,blockquote{font-family:±¼¸²;font-size:9pt;color:#555555;}
A:link {color:black;text-decoration:none;}
A:visited{color:black;text-decration:none;}
A:active{color:black;text-decoration:none;}
A:hover{color:gray;text-decoration:none;}
</STYLE>
</head>
<body bgcolor=white background=./images/body_bg.gif>
<img src=./images/maintitle.gif>
<table border=0 cellspacing=1 cellpadding="3" width=670>
<tr>
<td align=center>
<font color=green><b>³»¿ëº¸±â ȸéÀÔ´Ï´Ù.<b></font>
</td>
</tr>
<tr>
<td bgcolor="#EAC3EA">
<table border=0 cellspacing=1 cellpadding=0 width=670 bgcolor="white">
<tr>
<td width="100">
<p align="right"><b>À̸§ </b></p>
</td>
<td width="400">
<p><? echo $array[name];?></p>
</td>
<td width="100">
<p align="right"><b>Á¶È¸¼ö </b><p>
</td>
<td>
<p><? echo $array[count];?></p>
</td>
</tr>
<tr>
<td width="100">
<p align="right"><b>ÀüÀÚ¿ìÆí </b></p>
</td>
<td colspan="3"
<p><? echo $array[email];?></p>
</td>
</tr>
<tr>
<td width="100">
<p align="right"><b>ȨÆäÀÌÁö </b></p>
</td>
<td colspan="3">
<p><? echo $array[homepage];?> </p>
</td>
</tr>
<tr>
<td width="100">
<p align="right"><b>Á¦¸ñ ></b></p>
</td>
<td colspan="3">
<p><? echo $array[subject];?></p>
</td>
</tr>
<tr>
<td width="100">
<a align="right"><b>³»¿ë </b></p>
</td>
<td colspan="3">
<p><? echo $array[memo]?></p>
</td>
</tr>
</table>
<p align="center"><a href="list.php?page=<?echo $page; ?>">[¸ñ·Ï]</a> [¾²±â] [¼öÁ¤] [»èÁ¦]</p>
</td>
</tr>
</table>
<body>
</html>
-------------------------------------------------
¿¡°í, ºü¸¥ ´äº¯ °¨»çµå¸³´Ï´Ù.
Á¦°¡ " »©¸Ô¾î¼ ¾ÈµÇ¾ú±º¿ä. ±×°Å ¶§¹®¿¡ 2½Ã°£À» ÇãºñÇß½À´Ï´Ù. öǪ´ö@_@;;;
±×¸®°í Çпø¿¡¼ À̹ø´Þ ¼ö¾÷ ³»¿ëÀÌ È¨ÆäÀÌÁö ¸¸µé±â¶ó¼ ¸ð¸£´Â php¹®À» ¿½ÉÈ÷ º¸°í Àִµ¥¿ä.
»çÀÌÆ®¸¦ º¸´Ù º¸¸é º¸¾È¿¡ ´ëÇÑ À̾߱Ⱑ ¸¹´õ¶ó°í¿ä.
ÇöÀç Á¦°¡ Áö±Ý ¿½ÉÈ÷ Â¥°í ÀÖ´Â °Ç ȸ¿ø °¡ÀÔ ºÎºÐÀä.
¿¹¸¦ µé¾î¼ »çÀÌÆ® ÁÖ¼Ò°¡ aa.co.k/ À̶ó°í Çϸé
/~~~~ ÀÌ µÚ¿¡ °Ô½ÃÆÇÀ̳ª ³»¿ë º¸¸é ¾öû³ª°Ô ±æ°Ô ³ª¿ÀÁö ¾Ê½À´Ï±î.
±Ùµ¥ Àü / ÀÌ µÚ¿¡ ºÎºÐÀ» ¸ðµÎ ¾ø¾Ö°í ¾ðÁ¦³ª ¾îµð¼³ª(...) µµ¸ÞÀÎ ÁÖ¼Ò¸¸ º¸ÀÌ°Ô ÇÏ°í ½Í°Åµç¿ä. ¾î¶»°Ô ÇÏ¸é ±×·¸°Ô µÉ±î¿ä. ¾î¶² ºÐ ¸»¾¸À¸·Î´Â È÷µçÀ» »ç¿ëÇ϶ó°í Çϴµ¥......
¿¡°í... ¸ð¸£´Â°Ô ÀÖÀ¸¸é ¾ðÁ¦³ª ¿Ã¸®°Ú½À´Ï´Ù@_@;;
¾öû ±ÍÂú°Ô ÇØµå¸± °Í °°³×¿ä(....)
|
 ¼Õº´¸ñ |
±Û ¹øÈ£´Â list.php¸¸ °ü·ÃÀÌ ÀÖ½À´Ï´Ù. ¸ñ·Ï º¸±â ¿Ü¿¡´Â ±Û ¹øÈ£°¡ Ç¥½ÃµÇ´Â °÷ÀÌ ¾øÀ¸´Ï±î¿ä.
±×·¡¼ list.php¸¦ ÁÖ~¿í ºÃ´Âµ¥¿ä,
$cur_num=$total_no-$list_num*(page-1);//ÇöÀç ±Û ¹øÈ£
ÀÌ ºÎºÐ¿¡¼ ¿ÀŸ°¡ ³µ³×¿ä.
page ¡æ $page
ÀÌ·² °æ¿ì ¸Å ÆäÀÌÁö¸¶´Ù µ¿ÀÏÇÑ ±Û ¹øÈ£°¡ ³ªÅ¸³³´Ï´Ù.
±× ¿Ü¿¡µµ ¿ÀŸ°¡ Á¶±Ý¾¿ ÀÖ´Â °Í °°½À´Ï´Ù¸¸, ÇÁ·Î±×·¥¿¡ °áÁ¤ÀûÀÎ ¿µÇâÀ» ¹ÌÄ¡´Â °ÍÀº $page º¯¼ö ¿ÀŸÀÎ °Í °°³×¿ä.
¾Æ·¡¿Í °°Àº ¿ÀŸµµ ÀÖ´Â °Í °°±¸¿ä...
echo",a href='list.php?page=$next'>[$page_num °³ µÚ]</a> ";
¿©±â¼´Â ½°Ç¥(,) ´ë½Å <¸¦ ½á¾ßÇÒ °Í °°±¸¿ä... |
|
|
 ¼Õº´¸ñ |
±×¸®°í view.php?no=12&page=3&src_name=%!#!$!@# ¿Í °°ÀÌ È£ÃâµÇ´Â °ÍÀÌ ½ÈÀ¸½Ã´Ù¸é¿ä,
FORM ű׿¡¼ method="get"À» method="post"·Î ¹Ù²Ù¾î¼ »ç¿ëÇÏ¸é µË´Ï´Ù.
È÷µçÀ¸·Î ó¸®ÇÑ´Ù´Â °ÍÀº,
<input type="hidden" name="xxxx" value="oooo">¿Í °°Àº ½ÄÀ¸·Î ¼Ò½º Áß°£¿¡ Áý¾î³Ö°í, FORM ű׿¡¼ method="post"·Î ÁöÁ¤Ç϶ó´Â °ÍÀÔ´Ï´Ù.
±×·¯³ª ÀÌ·¸°Ô Çϸé À¥ ºê¶ó¿ìÀúÀÇ ÁÖ¼Ò Ç¥½ÃÁÙ¿¡ º¹ÀâÇÑ ¹®ÀÚ(ÀÌ°É query stringÀ̶ó°í Çϴµ¥¿ä...), ÀÌ°Ô º¸ÀÌÁö ¾Ê¾Æ¼ ÁÁ±â´Â ÇÏÁö¸¸, ÇÁ·Î±×·¥À» © ¶§ ºÒÆíÇÒ °æ¿ì°¡ ÀÖ½À´Ï´Ù. Àß ±¸ÇöÀÌ ¾ÈµÉ ¶§µµ ÀÖ±¸¿ä.
¿¹¸¦ µé¾î ±Û ¸ñ·ÏÀ» º¼ ¶§ ÇöÀç ÆäÀÌÁö¿¡¼ ´ÙÀ½ ÆäÀÌÁö·Î °¡±â À§ÇØ [´ÙÀ½] ¹öưÀ» ´·¶À» ¶§ ÇØ´ç ¸µÅ©¸¦ ó¸®ÇÏ·Á¸é get ¹æ½ÄÀÌ ¸Å¿ì Æí¸®ÇÕ´Ï´Ù. post ¹æ½ÄÀ¸·Î ÇÏ·Á¸é... ¸øÇÒ °Å¾ß ¾øÁö¸¸ ¸Ó¸®¸¦ Á» ´õ ±¼·Á¾ß(?) µË´Ï´Ù. ´ë°³ ±×·¸°Ô Àß ¾²Áö ¾Ê½À´Ï´Ù. |
|
|

|
|

|
|