»Ç¶ó´åÄÄ
Loading...




À¥µðÀÚÀÎ,Æ÷Åä¼¥,±×´©º¸µå,Á¦·Îº¸µå,µ¿¿µ»óÁ¦ÀÛ °ü·Ã ¸Þ¸ð >>


¦­Àüü(437)¦­ÀÎÅͳÝ,ÄÄÇ»ÅÍ (94) | À¥µðÀÚÀÎtip (182) | CG,±×·¡ÇÈtip (70) | BBS_Tip (74) | ¿µ»ótip (17) |
ÃֱٰԽù° À¥ÁøÃâ·Â 2010-06-13 20:15:25
ȨÆäÀÌÁöȨÆäÀÌÁö

<style type="text/css">
a.a1:link {color:0066FF; text-decoration:none}
a.a1:visited {color:000000; text-decoration:none}
a.a1:active {color:000000; text-decoration:none}
a.a1:hover{color:yellow; text-decoration:none}

.text {font-size:9pt;}
.title {font-size:10pt;}
</style>
<?
$connect=mysql_connect("localhost","µðºñ¾ÆÀ̵ð","µðºñÆÐ½º"); // MySQL DB¿¡ Á¢±Ù
mysql_select_db("µðºñÀ̸§"); // »ç¿ëÇÒ DB¸¦ ¼±ÅÃ
$url = "Á¦·Îº¸µåurl"; // Á¦·Îº¸µåURL ³¡¿¡ '/'¸¦ ºÙÀÌÁö¸»°Í
$id = "id"; // °Ô½ÃÆÇ ¾ÆÀ̵ð
$result=mysql_query("select * from zetyx_board_$id order by no desc limit 3"); // ¿©±â¼­ limit 2 ´Â ³ªÅ¸³»´Â °øÁö°¹¼ö¸¦ ³ªÅ¸³¿
?>
<?
while($data=mysql_fetch_array($result))
{
  $max = 140; //º»¹®ÀÌ ±ÛÀÚ °ª ÀÌ»óÀÌ µÇ¸é .....À¸·Î Ç¥½Ã
  $count = strlen($data[memo]);
  $memo = $data[memo];    //º»¹®ÀÌ$max º¸´Ù ÀÛÀ» ¶§ ±×´ë·Î Ç¥½Ã
  if($count >= $max) {
  for ($pos=$max;$pos>0 && ord($new[memo][$pos-1])>=127;$pos--);
  if (($max-$pos)%2 == 0)
  $memo = substr($data[memo], 0, $max) . "..." ;
  else
  $memo = substr($data[memo], 0, $max+1) . "...";
  }
  $no=$data[no];

  // Á¦¸ñÀÌ ±æ¸é ÀÚ¸£±â..
  $max = 40; //Á¦¸ñ ±ÛÀÚ °ª ÀÌ»óÀº .....À¸·Î Ç¥½Ã
  $count = strlen($data[subject]);
  $subject=$data[subject];
  if($count >= $max) {
  for ($pos=$max;$pos>0 && ord($new[subject][$pos-1])>=127;$pos--);
  if (($max-$pos)%2 == 0)
  $subject = substr($data[subject], 0, $max) . "...";
  else
  $subject = substr($data[subject], 0, $max+1) . "...";
  }

 $date=date("m/d",$data[reg_date]);
 // ¿©±â¼­ºÎÅÍ ³»¿ëº¸±âÀÔ´Ï´Ù.
 echo "<table width='300' border='0'>";
 echo "<tr><td class='title' colspan='2'> <a class='a1' href=$url/view.php?id=$id&no=$no target='_self'><b>$subject</b></a></td></tr>";
 echo "<tr><td><img src=$url/".stripslashes($data[file_name1])." border=1 hspace=0 width=65 height=52 style='border-color:#6e6e6e'></td>";
 echo "<td class='text' style=text-align:justify;> $memo  [$date]</td></tr>";
 echo "</table>";
 }
 ?>





    



¸ñ·Ïº¸±â »èÁ¦Çϱâ

¹øÈ£ Á¦¸ñ ÀÏÀÚ
362  [À¥µðÀÚÀÎtip] Å×À̺í Ç¥¸¦ ¸µÅ© °É±â  2008-04-27
361  [À¥µðÀÚÀÎtip] Å×ÀÌºí ¾ÈÀ¸·Î ÇÑÄ­ÇÑÄ­ ¸µÅ©µÈ ±Û ½ºÅ©·Ñ  2008-04-27
360  [À¥µðÀÚÀÎtip] Å×ÀÌºí ¾È ±úÁö°Ô ÇÏ´Â css  2017-08-29
359  [À¥µðÀÚÀÎtip] Å×ÀÌºí ¾È ±úÁö°Ô ±úÁü¹æÁö  2017-09-04
358  [À¥µðÀÚÀÎtip] Å×À̺í table td ¾ÈÂÊ ¿©¹é ÁÖ±â  2011-06-08
357  [À¥µðÀÚÀÎtip] Å׵θ®¸¦ ¹Ý¦ÀÌ°Ô ÇÏ´Â ½ºÅ©¸³Æ®  2008-04-27
356  [ÀÎÅͳÝ,ÄÄÇ»ÅÍ] ¹Ì¸®º¸±âŽ»ö±âÀÇ À̹ÌÁö ½æ³×ÀÏ Å©±â Á¶Àý  2009-03-02
355  [À¥µðÀÚÀÎtip] Å¸ÀÌÇÎ È¿°ú  2008-04-27
354  [À¥µðÀÚÀÎtip] Å¬¸³º¸µå º¹»ç  2013-10-31
353  [CG,±×·¡ÇÈtip] Å¬¸³,Çѹ®,È­»ìÇ¥ ºê·¯½¬  2008-04-27
352  [À¥µðÀÚÀÎtip] Äü¸Å´º ´Þ±â  2008-04-27
351  [BBS_Tip] ÄÚ¸àÆ®¸¦ üũÇÏ¿© »èÁ¦  2009-08-31
350  [BBS_Tip] ÄÚ¸àÆ® Å×ÀÌºí ºñ¿îÈÄ °Ô½Ã¹° ÄÚ¸àÆ® ¼ýÀÚ Á¶Á¤ÇÏ±â  2009-08-31
349  [BBS_Tip] ÄÚ¸àÆ® À¯¹«·Î Áú¹®°Ô½ÃÆÇ ¸¸µé±â  2009-02-23
348  [ÀÎÅͳÝ,ÄÄÇ»ÅÍ] ÄÄÇ»ÅÍÁ¶¸³  2009-02-12
347  [ÀÎÅͳÝ,ÄÄÇ»ÅÍ] ÄÄÀÌ ´À·ÁÁ³À» ¶§,  2008-04-27
346  [À¥µðÀÚÀÎtip] Ä÷¯ÀÇ ¿µ¹®À̸§  2010-08-16
345  [BBS_Tip] Ä«Å×°í¸®¸¦ À̹ÌÁö·Î Ç¥½ÃÇϱâ.  2009-04-03
344  [BBS_Tip] Ä«Å×°í¸® ¼±Åà À̵¿  2009-01-21
343  [ÀÎÅͳÝ,ÄÄÇ»ÅÍ] Ãß°¡·Î ·Î±×¿Â Á¤º¸°¡ ÇÊ¿äÇÕ´Ï´Ù ¾ø¾Ö±â  2014-10-13
342  [À¥µðÀÚÀÎtip] ÃÖ±ÙÀ̹ÌÁö ·£´ý ÃßÃâÇϱâ - ±×´©º¸µå4  2013-09-29
341  [BBS_Tip] ÃÖ±Ù°øÁö±Û ±ÛÀÚ¼ö Á¦ÇÑ  2010-06-13
340  [BBS_Tip] ÃÖ±Ù°øÁö,À̹ÌÁö ·£´ýÃßÃâ  2010-06-13
 [BBS_Tip] ÃֱٰԽù° À¥ÁøÃâ·Â  2010-06-13
338  [À¥µðÀÚÀÎtip] Ãµ¸®¾Èü  2020-02-20
¸ñ·Ïº¸±â
12345678910