include "basic.php";
?>
if ($gourl=="") {
$gourl = $HTTP_REFERER;
}
$query = "Update noticeboard Set readnum=readnum+1 Where kinds='$kinds' and pid='$pid'";
mysqli_query($GLOBALS['dbh'],$query);
$querytemp = " where pid > 0 ";
if (isset($keyword)) {
if ($keyselect=="subject") {
$querytemp = $querytemp." and subject like '%$keyword%' ";
}
else if ($keyselect=="comment") {
$querytemp = $querytemp." and comment like '%$keyword%' ";
}
else if ($keyselect=="username") {
$querytemp = $querytemp." and username like '%$keyword%' ";
}
}
$query = "select pid, subject, regdate from noticeboard ".$querytemp." and kinds='$kinds' and pid<$pid order by pid desc limit 1";
$result = mysqli_query($GLOBALS['dbh'],$query);
$rows = mysql_fetch_row($result);
$prevpid = $rows[0];
$prevsubject = $rows[1];
$prevsubject = htmlspecialchars(stripslashes($prevsubject));
$prevregdate = $rows[2];
$query = "select pid, subject, regdate from noticeboard ".$querytemp." and kinds='$kinds' and pid>$pid order by pid asc limit 1";
$result = mysqli_query($GLOBALS['dbh'],$query);
$rows = mysql_fetch_row($result);
$nextpid = $rows[0];
$nextsubject = $rows[1];
$nextsubject = htmlspecialchars(stripslashes($nextsubject));
$nextregdate = $rows[2];
$query = "Select pid,userid,username,email,subject,comment,userfile, ";
$query = $query." regdate,readnum, ";
$query = $query." ref,step,re_level,kinds,password ";
$query = $query." From noticeboard ";
$query = $query.$querytemp." and kinds='$kinds' and pid='$pid' ";
$result = mysqli_query($GLOBALS['dbh'],$query);
$rows = mysql_fetch_row($result);
$pid=$rows[0];
$userid=$rows[1];
$username=$rows[2];
$email=$rows[3];
$subject=$rows[4];
$subject=htmlspecialchars(stripslashes($subject));
$comment=$rows[5];
$comment=stripslashes($comment);
$comment=nl2br($comment);
$userfile=$rows[6];
$regdate=$rows[7];
$readnum=$rows[8];
$ref=$rows[9];
$step=$rows[10];
$re_level=$rows[11];
$kinds=$rows[12];
?>
::SEOUL METAL::
|
include"../inc/top_inc.php" ?> |
include"../inc/img_comu_inc.php" ?>
|
|
include"../inc/left_comu_inc.php" ?> |
|
|
Home > Ä¿¹Â´ÏƼ > °øÁö»çÇ× |
|
|
echo $subject; ?> |
|
ÀÛ¼ºÀÚ : |
|
echo $comment; ?> |
|
ÀÛ¼ºÀÏ : echo $regdate; ?> |
|
|
|
|
|
include"../inc/copyright_inc.php" ?>
|