|
|
|
|
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¸¦ »õ·Ó°Ô ¸¸µé¾ú´Ù°í ÇսôÙ. ±×·±µ¥ Ãâ·Â½Ã¿¡´Â ¾î¶² ű׸¦ ½á¾ß ³ªÅ³¾¾¥ÀÕÁÒ? ÃֱٰԽù° ÇüÅÂÀÇ ¼Ò½º´Â ÁÖ¾îÁ³Áö¸¸
ÃֱٰԽù°·Î ³ªÅ¸³¾ Ãâ·Â ¼Ò½º¸¦ ¸ô¶ó °í»ýÁß~
|
|
|
|
|
|
|
|
|
ÄÄÇ»Áî´åÄÄ(´ëÇ¥ ÀåÁ¤ÁÖ) ÀÎõ±¤¿ª½Ã µ¿±¸ ¹æÃà·Î83¹ø±æ 23, 24µ¿ 333È£
»ç¾÷ÀÚµî·Ï¹øÈ£ 137-05-83351, Åë½ÅÆǸŠÀÎõ µ¿±¸ 03-78È£, °³ÀÎÁ¤º¸Ã¥ÀÓÀÚ ÀåÁ¤ÁÖ
|
|
|
|