//»ç¼ÇÔ ³»¿ëÀ» ¾÷µ¥ÀÌÆ®
if($post_save=="upd")
mysql_query("update post_man set feature='$feature',pgroup='$pgroup'
where id='$id' and pid='$pid'");
//»ç¼ÇÔ¿¡ »õ·Î¿î µ¥ÀÌÅ͸¦ ÀÔ·Â
elseif($post_save=="new"){
$presult = mysql_query("select * from post_man where id='$id' and pid='$pid'");
if($prow = mysql_fetch_array($presult)) {
echo "
";
exit();
}
$sql = "INSERT INTO post_man (id, pid, pnick, feature, pgroup) VALUES ('$id','$pid','$pnick','$feature','$pgroup')";
mysql_query($sql);
}
//¼±Åà »èÁ¦ ó¸®
if($mode) {
for($i = 0; $i < sizeof($checkup); $i++) {
$pid = $checkup[$i];
mysql_query("delete from post_man where id='$id' and pid='$pid'");
}
}
?>
//ÇÔ¼ö µî·Ï ºÎ ========================================================
function echo_line($no, $row) {
global $id,$nickname,$d_num,$d_rid,$d_sid;
//±¸·ìº°·Î ¹é±×¶ó¿îµå Ä®¶ó ÀÔÈ÷±â
if($row[pgroup]=="A") $bc="#FFCCCC";
elseif($row[pgroup]=="B") $bc="#FFCCFF";
elseif($row[pgroup]=="C") $bc="#CCCCFF";
elseif($row[pgroup]=="D") $bc="#CCFFFF";
elseif($row[pgroup]=="E") $bc="#CCFFCC";
elseif($row[pgroup]=="F") $bc="#FFFFCC";
//±Û¾²±â ÆÇÀ¸·ÎÀÇ ÁÖ¼Ò¸µÅ©¸¦ º¯¼ö·Î ó¸®
$write_link="";
echo "\n";
//äũ¹Ú½º
echo " | \n";
//±¸·ì
echo "$row[pgroup]±¸·ì | \n";
//¾ÆÀ̵ð
echo "$write_link$row[pid] | \n";
//´Ð³×ÀÓ
echo "$write_link$row[pnick] | \n";
// Ư¡
echo "$write_link$row[feature] | \n";
//ȸ¿ø ±¸·ì ¹× Ư¡ º¯°æ
echo " | \n";
echo "
\n";
}
// ========================================================ÇÔ¼ö µî·Ï ºÎ
//°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â
if(strlen($keyword) > 0)
{
switch ($ftype) {
case "pid":
$colm = pid;
break;
case "pnick":
$colm = pnick;
break;
case "feature":
$colm = feature;
break;
}
$result = mysql_query("select * from post_man where id='$id' and $colm like '%$keyword%' order by pgroup");
}
else
$result = mysql_query("select * from post_man where id='$id' order by pgroup");
$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);
?>
|
ºÐ·ù |
¾ÆÀ̵ð |
´Ð³×ÀÓ |
Ư ¡ |
º¯°æ |
}?>