<!doctype html>
<html>
<head>
<meta charset="utf-8" />
<title>yltlq</title>
<script type="text/javascript">
function check_data()
{
if(document.myForm.user.value.length==0)
alert("123");
else if(document.myForm.title.value.length==0)
alert("456");
else if(document.myForm.content.value.length==0)
alert("789");
else
myForm.submit();
}
</script>
</head>
<body>
<p align="center"><img src="123.jpg"></p>
<?php
require_once("dbtools.inc.php");
$records_per_page=5;
if(isset($_GET["page"]))
$page=$_GET["page"];
else
$page=1;
$link=create_connection();
$sql="SELECT id,user,title,lastdate FROM message ORDER BY CAST(lastdate as datetime) DESC";
$result=execute_sql($link,"bbs",$sql);
$total_records=mysqli_num_rows($result);
$total_pages=ceil($total_records/$records_per_page);
$started_record=$records_per_page*($page-1);
mysqli_data_seek($result,$started_record);
echo "<table width='800' align='center' cellpadding='3'>";
$bg[0]="#d9d9ff";
$bg[1]="#ffcaee";
$bg[2]="#ffffcc";
$bg[3]="#b9eeb9";
$bg[4]="#b9e9ff";
$j=1;
while($row=mysqli_fetch_assoc($result)and $j<=$records_per_page)
{
echo "<tr>";
echo "<td width='120' align='center'><img src='123.jpg'></td>";
echo "<td bgcolor='".$bg[$j-1]."'>作者: ".$row["user"]."<br>";
echo "主题:".$row["title"]."<br>";
echo "时间:".$row["lastdate"]."<hr>";
echo "<a href='show_news.php?id=";
echo $row["id"]."'>加入讨论</a></td></tr>";
$j++;
}
echo "</table>";
echo "<p align='center'>";
if($page>1)
echo "<a href='index1.php?page=".($page-1)."'>上一页</a>";
for($i=1;$i<=$total_pages;$i++)
{
if($i==$page)
echo "$i";
else
echo "<a href='index1.php?page=$i'>$i</a>";
}
if($page<$total_pages)
echo "<a href='index1.php?page=".($page+1)."'>下一页</a>";
echo"</p>";
mysqli_free_resule($result);
mysqli_close($link);
?>
<hr>
<form name="myForm" method="post" action="post.php">
<table border="0" width="800" align="center" cellspacing="0">
<tr bgcolor="#0084ca" align="center">
<td colspan="2"><font color="white">请在此输入新的评论</font></td>
</tr>
<tr bgcolor="#d9f2ff">
<td width="15%">作者</td>
<td width="85%"><input name="user" type="text" size="50"></td>
</tr>
<tr bgcolor="#84d7ff">
<td width="15%">题目</td>
<td width="85%"><input name="title" type="text" size="50"></td>
</tr>
<tr bgcolor="#d9f2ff">
<td width="15%">内容</td>
<td width="85%"><textarea name="content" cols="50" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="2" height="40" align="center">
<input type="button" value="回复" onClick="check_data()">
<input type="reset" value="重置">
</td>
</tr></table></form></body></html>
<html>
<head>
<meta charset="utf-8" />
<title>yltlq</title>
<script type="text/javascript">
function check_data()
{
if(document.myForm.user.value.length==0)
alert("123");
else if(document.myForm.title.value.length==0)
alert("456");
else if(document.myForm.content.value.length==0)
alert("789");
else
myForm.submit();
}
</script>
</head>
<body>
<p align="center"><img src="123.jpg"></p>
<?php
require_once("dbtools.inc.php");
$records_per_page=5;
if(isset($_GET["page"]))
$page=$_GET["page"];
else
$page=1;
$link=create_connection();
$sql="SELECT id,user,title,lastdate FROM message ORDER BY CAST(lastdate as datetime) DESC";
$result=execute_sql($link,"bbs",$sql);
$total_records=mysqli_num_rows($result);
$total_pages=ceil($total_records/$records_per_page);
$started_record=$records_per_page*($page-1);
mysqli_data_seek($result,$started_record);
echo "<table width='800' align='center' cellpadding='3'>";
$bg[0]="#d9d9ff";
$bg[1]="#ffcaee";
$bg[2]="#ffffcc";
$bg[3]="#b9eeb9";
$bg[4]="#b9e9ff";
$j=1;
while($row=mysqli_fetch_assoc($result)and $j<=$records_per_page)
{
echo "<tr>";
echo "<td width='120' align='center'><img src='123.jpg'></td>";
echo "<td bgcolor='".$bg[$j-1]."'>作者: ".$row["user"]."<br>";
echo "主题:".$row["title"]."<br>";
echo "时间:".$row["lastdate"]."<hr>";
echo "<a href='show_news.php?id=";
echo $row["id"]."'>加入讨论</a></td></tr>";
$j++;
}
echo "</table>";
echo "<p align='center'>";
if($page>1)
echo "<a href='index1.php?page=".($page-1)."'>上一页</a>";
for($i=1;$i<=$total_pages;$i++)
{
if($i==$page)
echo "$i";
else
echo "<a href='index1.php?page=$i'>$i</a>";
}
if($page<$total_pages)
echo "<a href='index1.php?page=".($page+1)."'>下一页</a>";
echo"</p>";
mysqli_free_resule($result);
mysqli_close($link);
?>
<hr>
<form name="myForm" method="post" action="post.php">
<table border="0" width="800" align="center" cellspacing="0">
<tr bgcolor="#0084ca" align="center">
<td colspan="2"><font color="white">请在此输入新的评论</font></td>
</tr>
<tr bgcolor="#d9f2ff">
<td width="15%">作者</td>
<td width="85%"><input name="user" type="text" size="50"></td>
</tr>
<tr bgcolor="#84d7ff">
<td width="15%">题目</td>
<td width="85%"><input name="title" type="text" size="50"></td>
</tr>
<tr bgcolor="#d9f2ff">
<td width="15%">内容</td>
<td width="85%"><textarea name="content" cols="50" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="2" height="40" align="center">
<input type="button" value="回复" onClick="check_data()">
<input type="reset" value="重置">
</td>
</tr></table></form></body></html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货