r00ry      2002/01/04 18:08:33     11768     0   
   ÃֱٰԽù° ÃßÃâ... [8]
ÃÖ±Ù °Ô½Ã¹° ÃßÃâ... (Á¦ ȨÇÇ¿¡ Àû¿ëÇÑ ÃßÃâ¹°ÀÔ´Ï´Ù.)

¹°·Ð Á¦·Îº¸µåȨÆäÀÌÁö¿¡¼­ Æۿ°ÍÀ̱¸¿ä....
<?
mysql_connect("localhost","DBID","DBPWD");
//DBID = sql ID, DBPWD= sql password
mysql_select_db("DBNAME");
//DBNAME=sql ¸í
$result=mysql_query("select * from boardname order by no desc limit NO") or die(mysql_error());  
//boardname= °Ô½ÃÆÇ ¸í , NO = »Ì¾Æ³¾ °Ô½Ã¹° ¼ýÀÚ (¿¹: 5)
while($data=mysql_fetch_array($result))
{
$memo=stripslashes($data[memo]);
$data[subject] = stripslashes($data[subject]);
$max = NO;
//NO = °Ô½Ã¹° ÃßÃâ½Ã ÃÖ´ëÃâ·ÂµÇ´Â Á¦¸ñ ¼ýÀÚ (¿¹ : 30)
$count = strlen($data[subject]);
if($count >= $max) {
for ($pos=$max;$pos>0 && ord($new[subject][$pos-1])>=127;$pos--);
if (($max-$pos)%2 == 0)
$data[subject] = substr($data[subject], 0, $max) . "..";
else
$data[subject] = substr($data[subject], 0, $max+1) . "..";
}
else {
$data[subject] = "$data[subject]";
}
echo " <style type=\"text/css\">
a { font: 9pt ±¼¸²; text-decoration: none; color: black ; }
a:hover { text-decoration: underline; color: black ; }
</style>
<table cellpadding=\"0\" cellspacing=\"0\">
    <tr>
        <td width=\"240\" onMouseOver=this.style.backgroundColor='ECF9FF' onMouseOut=this.style.backgroundColor=''>
            <font size=2 color=black>[".date("m-d",$data[reg_date])."] <a href='URL/view.php?id=boardname&no=$data[no]')>".stripslashes($data[subject])."</a></font>
// URL = ÇØ´ç url , boardname= °Ô½ÃÆÇ ¸í
        </td>
    </tr>
</table>";
}
mysql_close();
?>


¿©±â ±îÁö ÀÔ´Ï´Ù.   // ~~  ´Â ¼³¸íÇϱâÀ§ÇÑ ÇàÀÔ´Ï´Ù... (»èÁ¦Çϼ¼¿ä)
   
ÄÚ¸àÆ®¸¦ ÀÛ¼ºÇϽøé 2 Æ÷ÀÎÆ®°¡ Áö±ÞµË´Ï´Ù.
r00ry


2002/01/04 18:09:52
[³¯Â¥, °Ô½ÃÆÇ Á¦¸ñÃâ·Â] ÃßÃâ¹°ÀÔ´Ï´Ù.

¡ÙORC¡Ù


2002/01/04 18:30:15
phpÃ¥ »ç¼­ ºÁ¾ß¡~~ ¤Ñ¤Ñ;;

¡ÙORC¡Ù


2002/01/04 18:30:23
¾î·Æ³ß...




2002/01/21 17:32:40
ÀÌ°Ç ¾îµð¿¡´Ù ³Ö´Â°Ç°¡¿©?

ºê¶óÀ̾ð´ëÀ§21C


2002/01/27 02:19:37
ÀÌ°ÍÀ» ¼öÁ¤Çؼ­ html¹®¼­ÀÚü¿¡ ¼Ò½º¸¦ ³Ö´Â°Ç°¡¿©

r00ry


2002/02/01 23:57:42
html ÆÄÀÏ Ã·°¡Çؼ­ htm ÆÄÀÏÀ̳ª php ÆÄÀÏ·Î ¸¸µå½Ã¸é..... ^^ ±×·¡µÎ ¾ÈµÇ¸é...ÂÊÁöÁÖ¼¼¿ä

Lusian


2003/02/17 14:34:59
mysql_connect("localhost","DBID","DBPWD") ¿¡¼­ ·ÎÄÃÈ£½ºÆ® ºÎºÐÀº ³öµÎ´Â°Ç°¡¿ä? ¾Æ´Ï¸é ·ÎÄÃÈ£½ºÆ®¸¦ ÀÔ·ÂÇؾßÇϳª¿ä?


Lusian


2003/02/27 18:13:04
Àú°Í ±×·¸´Ù Ãĵµ ¸¸¾à ÃֱٰԽù° ÆÄÀÏÀ» ¸¸µç´Ù¸é ÃֱٰԽù° ¸¸µé½Ã¿¡ ±âÁ¸ÀÇ z_list.php ÆÄÀÏÀÌ ÀÖ´Ù¸é ±×°ÍÀ» »èÁ¦ÇÏ°í ´Ù½Ã z_list.php¸¦ »õ·Ó°Ô ¸¸µé¾ú´Ù°í ÇսôÙ. ±×·±µ¥ Ãâ·Â½Ã¿¡´Â ¾î¶² ű׸¦ ½á¾ß ³ªÅ³¾¾¥ÀÕÁÒ? ÃֱٰԽù° ÇüÅÂÀÇ ¼Ò½º´Â ÁÖ¾îÁ³Áö¸¸
ÃֱٰԽù°·Î ³ªÅ¸³¾ Ãâ·Â ¼Ò½º¸¦ ¸ô¶ó °í»ýÁß~


       

249 ÀÀ´ä¾ø´Â ÇÁ·Î±×·¥ »¡¸®²ô±â ^^ [4] ±è¼º¼ö 02/23 18100 01/20(01:08)
248 ºÎÆýà XP·Î°í ¾È³ª¿À°Ô Çϱâ ^^ [1] ±è¼º¼ö 02/23 16833 10/22(07:09)
247 XPÀÇ ¼û°ÜÁøº¹»ç±â´É ^^ ±è¼º¼ö 02/23 15234
246 ¹ÙÅÁÈ­¸é¿¡ ¹Ù·Î°¡±â ¾ÆÀÌÄÜ»ý¼º±ÝÁö ±è¼º¼ö 02/23 15157
245 CMOS Æнº¿öµå ÀÒ¾î¹ö¸±¶§,, [1] ±è¼º¼ö 02/23 15541 02/23(23:27)
244 Æú´õ Àб⠼ӵµ ¿Ã¸®´Â¹æ¹ý^^ ±è¼º¼ö 02/23 14478
243 À¯¿ëÇÑÄÄÇ»ÅÍÆÁ 4°¡Áö^^ ±è¼º¼ö 02/23 13903
242 ±³Åë»ç°í À¯¹ß »ç±âÀÇ 6°¡Áö À¯Çü°ú ´ëó¿ä·É ÀüÈ­¹Ú»ç 04/14 14708
241 Shift Å°ÀÇ È°¿ë¹ý ÀüÈ­¹Ú»ç 04/14 14272
240 ¿Ü±¹¿¡¼­ »ê DVDº¸´Â ¹ý? ÀüÈ­¹Ú»ç 04/14 16210
239 CD ÀÚµ¿ÀÎ½Ä ¸·´Â ¹æ¹ý ÀüÈ­¹Ú»ç 04/14 15063
238 CD¸í·É¾î·Î ±äÀ̸§ÀÇ µð·ºÅ丮 ½±°Ô À̵¿Çϴ¹ý ÀüÈ­¹Ú»ç 04/14 16239
237 ¹«·á ·Î±× ºÐ¼® Åø~ ÀüÈ­¹Ú»ç 04/14 13958
236 »ç¿ëÁß À̶ó¸é¼­ »èÁ¦ ¾ÈµÇ´Â ÆÄÀÏ »èÁ¦¹ý ÀüÈ­¹Ú»ç 04/14 14740
235 CDÀÚ·á´Â 200³â°£ ¾ÈÀüÇÏ´Ù?? ÀüÈ­¹Ú»ç 04/14 13261
FIRST234567815LAST