jsboard ¸¦ ÀÌ¿ëÇÏ¿© ÃֱٰԽù° Ãâ·ÂÇϱâ >>
ÀÛ¼ºÀÚ : ÀåÇüÈ (hhjang97@venus.uos.ac.kr)
ÀÛ¼ºÀÏ : 2001. 12. 28
¼öÁ¤ÀÏ : 2002. 01. 30
¼³¸í :
ÃÖ±Ù °Ô½Ã¹° Ãâ·ÂÇϱâÀÇ Àü¹ÝÀûÀÎ ¼³¸íÀ» ÇÏ°Ú½À´Ï´Ù.
ÀÏ´Ü ¾î¶² °Ô½ÃÆÇÀ» »ç¿ëÇϵçÁö ¸®½ºÆ®¸¦ Ãâ·ÂÇÏ´Â ÆäÀÌÁö°¡ ÀÖ½À´Ï´Ù.
ÀÌ ÆäÀÌÁö¸¦ notice.php ·Î º¹»çÇϼ¼¿ä.
±×¸®°í³ª¼ notice.php ¿¡ º¸¸é º¸Åë limit ¸¦ »ç¿ëÇؼ °á°ú¸¦ °¡Á®¿É´Ï´Ù.
¿©±â¿¡¼ °¡Á®¿À´Â °³¼ö¸¦ Àû´çÈ÷ ÁÙÀÌ½Ã¸é µË´Ï´Ù. º¸Åë 5~7°³ Á¤µµ·Î ÇÏ¸é µÇÁÒ.
ÀÌ·¸°Ô ÇϽðí, notice.php ¸¦ Àû´çÈ÷ °íÄ¡¼¼¿ä.
±×·³ ±âº»ÀûÀÎ °øÁö»çÇ×Àº ³¡³°Ì´Ï´Ù.
±×¸®°í, °øÁö»çÇ×À» º¸¿©ÁÙ ÆäÀÌÁö¿¡ IFRAME ű׸¦ ÀÌ¿ëÇؼ °¡Á®¿À¸é µË´Ï´Ù.
======================= main.html ======================
À§ÂÊ ¸Þ´º
¾Æ·¡ ¸Þ´º
======================= main.html ======================
¸Ó ÀÌ·±½ÄÀ¸·Î ÇÏ¸é µË´Ï´Ù.
½±°Ô º¸¸é °Ô½ÃÆÇ ¸ñ·Ï ¸®½ºÆ®¸¦ Çϳª´õ ¸¸µå´Â°Å¶û ºñ½ÁÇÏÁÒ.
========================= notice.php ======================================
require("jsboard/config/global.ph");
require("jsboard/include/get.ph");
require("jsboard/include/error.ph");
require("jsboard/include/sql.ph");
require("jsboard/include/check.ph"); # is_hangul
require("jsboard/include/parse.ph");
sql_connect($db[server], $db[user], $db[pass]);
sql_select_db($db[name]);
# ¸®½ºÆ® Çü½Ä¿¡ »ç¿ëÇÏ´Â »ö±ò
$s_list[bg] = "#CEE3F7";
$s_list[tbg] = "#F2FFF9"; # Å×À̺íÀÇ bg color
$s_list[mouseover] = "#B9E1FF";
$s_list[mouseout] = "";
/* table : Ãâ·ÂÇÒ Å×À̺í À̸§
* title : °Ô½ÃÆÇ Á¦¸ñ
* num : Ãâ·ÂÇÒ °³¼ö (default = 9)
* main_img : ¸ÞÀο¡ µé¾î°¥ À̹ÌÁö(default = bulletinboard.gif)
*/
function last_list($table, $title, $url1 = "test", $main_img = "face.gif", $num=5)
{
global $s_list;
if($url1 == "test") { # ±âº»Àº ÀÚÀ¯°Ô½ÃÆÇÀ¸·Î
$url1 = "../board/list.php?table=phpfree";
}
$readurl = str_replace("list.php", "read.php", $url1);
## À̹ÌÁö ¸µÅ©
$title_img = "";
## Á¦¸ñ Ãâ·Â
$title_str = " $title_img $title";
## Àüü °³¼ö¸¦ ã´Â´Ù.
$query = "SELECT count(*) FROM $table";
$result = mysql_query($query);
if( mysql_errno() ) { print_error( mysql_error() ); }
$row = mysql_fetch_row($result);
$total_num = $row[0];
mysql_free_result($result);
$title_str .= " Àüü:$total_num ";
## $num ¹®ÅÀÇ ¸ñ·ÏÀ» Ãâ·ÂÇÑ´Ù.
$query = "SELECT * FROM $table ORDER BY idx DESC LIMIT 0, $num";
$result = mysql_query($query);
if( mysql_errno() ) { echo_error( mysql_error() ); }
## °Ô½ÃÆÇ Ãâ·Â
echo ("
$title_str |
¸ñ·Ï
|
");
while($list = mysql_fetch_array($result))
{
# $list[title] = unhtmlspecialchars(cut_string($list[title], 28));
$list[title] = strip_tags(cut_string($list[title], 28));
$date = date("m/d[H/i]", $list[date]);
if($list[reno]) {
$list_add = " ";
} else $list_add = '';
$readurl2 = $readurl. "&no=$list[no]";
echo ("
$list_add
$list[title] |
$date |
");
}; # end while
echo ("
|
");
}; ## end last_list
#
#
# ȸé Ãâ·Â
#
echo ("
");
echo " ";
echo last_list("test", "test!! test!!", "jsboard/list.php?table=test");
echo " | ";
echo " | ";
echo " ";
echo last_list("notice", "°øÁö »çÇ×(^_^)", "jsboard/list.php?table=notice");
echo " | ";
echo "
";
echo ("
");
?>
========================= notice.php ======================================