社区(php&&mysql)四
(编辑:jimmy 日期: 2024/11/16 浏览:3 次 )
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 "<FORM name=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=0 align=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>[www]http://www.jerry.com.tw[/www]</b></font></font><br>";
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>";
}
待续.......
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 "<FORM name=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=0 align=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>[www]http://www.jerry.com.tw[/www]</b></font></font><br>";
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>";
}
待续.......
下一篇:社区(php&&mysql)三