社区(phpmysql)四
2018-09-07 14:52
echo "<br>";
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor=#6CA6CD>";
echo "<tr><td>";
echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class=tablefont>";
echo "<tr bgcolor=#F1E1FF>";
echo "<th >夹肈</th>";
echo "<th>祇癬</th>";
echo "<th width=30>莱</th>";
echo "<th width=30></th>";
echo "<th width=70>ら戳</th>";
echo "</tr>";
$qsql="SELECT * from bbs_subj where id=$sid ";
$rs=mysql_db_query($sql[db],$qsql);
$row=mysql_fetch_array($rs);
$id=$row[id];
$banner=$row[banner];
$poster=$row[poster];
$views=$row[views];
$wdate=sdatetime($row[wdate]);
$docs=reAnum($id);
echo "<tr bgcolor=#F0F8FF>";
echo "<td>";
if($sid!=$rid) {
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
echo $banner;
echo "</a>";
} else echo "<font color=red><b>$banner</B></font>";
echo "</td>";
echo "<td>";
echo $poster;
echo "</td>";
echo "<td class=num>";
echo $docs;
echo "</td>";
echo "<td class=num>";
echo $views;
echo "</td>";
echo "<td class=num>";
echo $wdate;
echo "</td>";
echo "</tr>";
$qsql="SELECT * from bbs_docs where sid=$sid order by wdate";
$rs=mysql_db_query($sql[db],$qsql);
while($row=mysql_fetch_array($rs)) {
$id=$row[id];
$banner=$row[banner];
$poster=$row[poster];
$views=$row[views];
$wdate=sdatetime($row[wdate]);
$docs=reAnum($id);
echo "<tr bgcolor=#F0F0F0>";
echo "<td>";
if($sid!=$rid && $rid==$id) {
echo "<font color=red><b>$banner</B></font>";
} else {
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
echo "$banner";
echo "</a>";
}
echo "</td>";
echo "<td>";
echo $poster;
echo "</td>";
echo "<td class=num>";
echo "";
echo "</td>";
echo "<td class=num>";
echo $views;
echo "</td>";
echo "<td class=num>";
echo $wdate;
echo "</td>";
echo "</tr>";
}
echo "</td></tr></table>";
echo"</td></tr></table>";
} // ====
echo "<a name=re></a>";
if($type==1) {
if(substr($rebanner,0,3)!="Re:")
$rbanner="Re:".$rebanner;
else $rbanner=$rebanner;
}
echo "<FORMname=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=post2>";
echo "<input type=hidden name=aid value=$aid>";
echo "<input type=hidden name=sid value=$sid>";
echo "<input type=hidden name=type value=$type>";
echo "<TABLE width=95% BORDER=0align=center cellPadding=3 cellSpacing=0 class=tablefont>";
if($sid) {
echo "<TR bgcolor=white>";
echo "<TH colspan=2 >";
echo "癚阶硂杠肈";
echo "</TH>";
echo "</TR>";
}
echo "<TR>";
echo "<TD width=100 align=right>";
echo "肈:";
echo "</TD>";
echo "<TD>";
echo "<INPUT TYPE=text NAME=banner size=60 value=$rbanner>";
echo "</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD width=100 align=right>";
echo "祇ē:";
echo "</TD>";
echo "<TD>";
echo "<INPUT TYPE=text NAME=poster size=30 value=$c_poster>";
echo "</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD width=100 align=right>";
echo "E-Mail:";
echo "</TD>";
echo "<TD>";
echo "<INPUT TYPE=text NAME=email size=30 value=$c_email>";
echo "</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD width=100 align=right valign=top>";
echo "ず甧:";
echo "</TD>";
echo "<TD>";
echo "<font color=green>や穿禬硈挡ノ猭絛ㄒ:<font color=red><b>[
echo "<TEXTAREA NAME=body cols=80 rows=16>";
echo "</TEXTAREA>";
echo "</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD align=center colspan=2>";
//echo "<INPUT TYPE=checkbox NAME=remail>";
//echo "滦";
if($sid) {
$br="-----------------------------------------------------------";
$obody="まノ $poster ゅ彻n$brn".$body;
$obody.="n$brn滦癚阶ず甧:n";
echo "<input type=hidden name=obody value="$obody">";
echo "<INPUT TYPE=button value=まノゅ onClick="this.form.body.value=this.form.body.value + this.form.obody.value; this.form.obody.value=;">";
}
echo "<INPUT TYPE=submit value=癳>";
echo "</TD>";
echo "</TR>";
echo "</TABLE>";
}
待续.......
上一篇:ThinkPHP框架实现的MySQL数据库备份功能示例
下一篇:main.php