001.
<? session_start(); ?>
004.
<head>
005.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
/>
006.
<title>Webbord</title>
007.
<link href=
"stylesheet.css"
rel=
"stylesheet"
type=
"text/css"
/>
008.
<script language=
"javascript"
>
009.
function
addEmo(num){
010.
document.frmTopic.detail.value = document.frmTopic.detail.value +
'['
+ num +
']'
;
011.
}
012.
function
checkNull(){
013.
if
(document.frmTopic.subject.value==
""
|| document.frmTopic.subject.value==null){
014.
alert(
'โปรดกรอกชื่อเรื่องด้วยครับ'
);
015.
document.frmTopic.subject.focus();
016.
return
false;
017.
}
018.
if
(document.frmTopic.detail.value==
""
|| document.frmTopic.detail.value==null){
019.
alert(
'โปรดกรอกรายละเอียดด้วยครับ'
);
020.
document.frmTopic.detail.focus();
021.
return
false;
022.
}
023.
if
(document.frmTopic.name.value==
""
|| document.frmTopic.name.value==null){
024.
alert(
'คุณลืมชื่อนะครับ'
);
025.
document.frmTopic.name.focus();
026.
return
false;
027.
}
028.
document.frmTopic.submit();
029.
}
030.
</script>
031.
</head>
032.
033.
<body>
034.
<center><br />
035.
<?
include
(
"connect.php"
);
036.
include
(
"function.php"
) ?>
037.
<form id=
"frmManage"
name=
"frmManage"
method=
"post"
action=
"managewebbord.php"
>
038.
<table width=
"1000"
class
=
"square"
cellpadding=
"4"
cellspacing=
"1"
>
039.
<tr>
040.
<td width=
"50"
class
=
"square"
align=
"center"
> </td>
041.
<td width=
"641"
class
=
"square"
align=
"center"
>Subject</td>
042.
<td width=
"201"
class
=
"square"
align=
"center"
>
Date
</td>
043.
<td width=
"76"
class
=
"square"
align=
"center"
>View</td>
044.
<td width=
"66"
class
=
"square"
align=
"center"
>Reply</td>
045.
</tr>
046.
<?
$sql
=
"select * from webboard_post order by question_id desc "
;
047.
$query
= mysql_query(
$sql
)
or
die
(mysql_error());
048.
$num
= mysql_num_rows(
$query
);
049.
$page
= isset(
$_GET
[
'page'
])?
$_GET
[
'page'
]:1;
050.
$perpage
= 10;
051.
$totalpage
=
ceil
(
$num
/
$perpage
);
052.
$startpoint
= (
$page
-1)*
$perpage
;
053.
$sql
.=
"limit $startpoin,$perpage"
;
054.
$query
= mysql_query(
$sql
)
or
die
(mysql_error());
055.
$num
= mysql_num_rows(
$query
);
056.
057.
if
(
$num
>0){
058.
for
(
$i
=0;
$i
<
$num
;
$i
++){
059.
$row
= mysql_fetch_array(
$query
); ?>
060.
<tr>
061.
<td width=
"50"
class
=
"square"
align=
"center"
>
062.
<?
if
(!isset(
$_SESSION
[
'admin'
])){ ?>
063.
<img src=
"image/bullet.gif"
width=
"6"
height=
"12"
/>
064.
<? }
else
{ ?>
065.
<input type=
"checkbox"
id=
"id[]"
name=
"id[]"
value=
"<?=$row['question_id']?>"
class
=
"verdana"
/>
066.
<? } ?>
067.
</td>
068.
<td width=
"641"
class
=
"square"
align=
"center"
>
069.
<a href=
"viewtopic.php?id=<?=$row['question_id']?>"
target=
"_blank"
><?=
$row
[
'subject'
]?> </a></td>
070.
<td width=
"201"
class
=
"square"
align=
"center"
>
071.
<?=dateShow(
$row
[
'datadate'
])?> </td>
072.
<td width=
"76"
class
=
"square"
align=
"center"
>
073.
<?=
$row
[
'view'
]?> </td>
074.
<td width=
"66"
class
=
"square"
align=
"center"
>
075.
<?=
$row
[
'reply'
]?> </td>
076.
</tr>
077.
<? }
078.
}
else
{ ?>
079.
<tr> <td colspan=
"5"
class
=
"square"
align=
"center"
> DataBase is emply
080.
</td> </tr>
081.
<? } ?>
082.
<?
if
(
$totalpage
>0){ ?>
083.
<tr><td colspan=
"5"
class
=
"square"
align=
"center"
>
084.
<?
for
(
$i
=1;
$i
<=
$totalpage
;
$i
++){
085.
echo
"<a href=\"?page=$i\">$i</a>"
; } ?>
086.
</td></tr>
087.
<? } ?>
088.
<?
if
(isset(
$_SESSION
[
'admin'
])){?>
089.
<tr><td colspan=
"5"
class
=
"square"
align=
"right"
>
090.
click here
for
delete
<input type=
"submit"
value=
"Delete"
class
=
"verdana"
/> :
091.
<a href=
"logout.php"
class
=
"verdana"
>Logout</a>
092.
</td></tr>
093.
<? } ?>
094.
</table><br/>
095.
</form>
096.
<form id=
"frmtopic"
name=
"frmTopic"
enctype=
"multipart/form-data"
method=
"post"
action=
"inserttopic.php"
onsubmit=
"checkNull();return false;"
>
097.
<table width=
"1000"
class
=
"square"
cellpadding=
"4"
cellspacing=
"1"
>
098.
<tr>
099.
<td width=
"200"
class
=
"square"
align=
"center"
>Subject</td>
100.
<td width=
"800"
class
=
"square"
align=
"left"
>
101.
<input type=
"text"
id=
"subject"
name=
"subject"
style=
"width:500px"
class
=
"verdana"
/>
102.
</td>
103.
</tr>
104.
<tr>
105.
<td width=
"200"
class
=
"square"
align=
"center"
>Detial</td>
106.
<td width=
"800"
class
=
"square"
align=
"left"
>
107.
<textarea name=
"detail"
rows=
"4"
class
=
"verdana"
id=
"detail"
style=
"width:500px"
></textarea>
108.
</td>
109.
</tr>
110.
<tr>
111.
<td width=
"200"
class
=
"square"
align=
"center"
>Emo</td>
112.
<td width=
"800"
class
=
"square"
align=
"left"
>
113.
<?
for
(
$i
=1;
$i
<=15;
$i
++) { ?>
114.
<img src=
"emo/<?=$i?>.gif"
onclick=
"addEmo(<?=$i?>)"
/>
115.
<? } ?>
116.
</td>
117.
</tr>
118.
<tr>
119.
<td width=
"200"
class
=
"square"
align=
"center"
>Attach file</td>
120.
<td width=
"800"
class
=
"square"
align=
"left"
>
121.
<input type=
"file"
id=
"attach"
name=
"attach"
class
=
"verdana"
/>
122.
</td>
123.
</tr>
124.
125.
<td width=
"200"
class
=
"square"
align=
"center"
>Name</td>
126.
<td width=
"800"
class
=
"square"
align=
"left"
>
127.
<input type=
"text"
id=
"name"
name=
"name"
style=
"width:444px"
class
=
"verdana"
/>
128.
129.
<input type=
"submit"
value=
"Post"
class
=
"verdana"
/>
130.
</td>
131.
</tr>
132.
</table>
133.
</form>
134.
<? mysql_close(
$conn
); ?>
135.
</center>
136.
</body>
137.
</html>