//ÇÔ¼ö µî·Ï ºÎ ========================================================
function echo_line($no, $row) {
global $id,$nickname,$d_num,$d_rid,$d_sid,$send;
echo "
\n";
echo " | \n";
//¸®½ºÆ®¸¦ ¼±Åà Ãâ·ÂÇϱâ(d_main°ú d_depÀº view.html¿¡¼ ³Ñ¾î¿Â °ª),±Û ¹øÈ£¿Í ¼±Åà À̹ÌÁö Ãâ·Â
if($row[number]==$d_num and $row[rid]==$d_rid and $row[sid]==$d_sid)
echo " | \n";
else echo "$no | \n";
//ÀÌ¹Ì ¿¾îº» ¸ñ·Ï¿¡ »ö³Ö±â
if($row[open_date]) $title="$row[title]";
else $title="$row[title]";
// °Ô½Ã¹° Á¦¸ñ°ú Àб⠸µÅ©
$title = " $title\n";
echo "$title | \n";
//±Û¾´ÀÌ
echo "$row[snick] | \n";
if($send) $mid=$row[rid]; else $mid=$row[sid];
//±Û¾´ÀÌ ¾ÆÀ̵ð
echo "$mid | \n";
//±Û ÀÛ¼º ³¯Â¥
$date = substr($row[date],0,16);
echo "$date | \n";
echo "
\n";
}
// ========================================================ÇÔ¼ö µî·Ï ºÎ
//$send=senÀÌ¸é º¸³½ ¸Þ½Ã¸¦ ºÒ·¯¿À°í ¾Æ´Ï¸é ¹ÞÀº ¸Þ¼¼Áö¸¦ ºÒ·¯¿Â´Ù.
if($send) $qry=sid; else $qry=rid;
//°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â
if(strlen($keyword) > 0)
{
switch ($ftype) {
case "sid":
$colm = sid;
break;
case "snick":
$colm = snick;
break;
case "title":
$colm = title;
break;
case "content":
$colm = content;
break;
}
$result = mysql_query("select * from memo where $qry='$id' and $colm like '%$keyword%' order by date desc");
}
else
$result = mysql_query("select * from memo where $qry='$id' order by date desc");
$colm ="";
//ÇÑȸ鿡 Ãâ·ÂÇÒ ÁÙ ¼ö
$rows = 10;
//ÇÑ È¸é¿¡ Ãâ·ÂÇÒ ÆäÀÌÁö ¼ö
$page_scale = 10;
// Àüü±Û ¸ñ·Ï ¼ö
$count = mysql_num_rows($result);
// ÇöÀç º¸¿©ÁÖ´Â ÆäÀÌÁö¹øÈ£
if (empty($page)) $page = 1;
// ÇöÀç ÆäÀÌÁö¿¡ µû¸¥ º¸¿©ÁÙ °Ô½Ã¹°ÀÇ Ã¹ À§Ä¡
$start=($page-1)*$rows;
// °á°ú Áß¿¡¼ ÇöÀç ÆäÀÌÁöÀÇ Ã¹¹øÂ° ·¹ÄÚµå¼ÂÀ¸·Î À̵¿ÇÑ´Ù.
if ($start > 1) mysql_data_seek($result,$start);
// ÃÑ ÆäÀÌÁö¼ö
$total = ceil(($count)/$rows);
?>
|
¹øÈ£ |
Æí Áö Á¦ ¸ñ |
º¸³½ÀÌ |
¾ÆÀ̵ð |
¹ß¼Û½Ã°£ |
}?>