社区(php&&mysql)四
2015-01-24信息快讯网
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 >夹D</th>";
echo "<th>o_H</th>";
echo "<th width=30>^莱</th>";
echo "<th width=30>H</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 "[JQ阶o痈苊D";
echo "</TH>";
echo "</TR>";
}
echo "<TR>";
echo "<TD width=100 align=right>";
echo "DD:";
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 "oēH:";
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 "ずe:";
echo "</TD>";
echo "<TD>";
echo "<font color=green>や穿Ws挡ノkdㄒ:<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^滦Q阶氦寒epU: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='eX'>";
echo "</TD>";
echo "</TR>";
echo "</TABLE>";
}
待续.......
Mysql的GROUP_CONCAT()函数使用方法
php中文字符截取防乱码
php5中类的学习
php一些公用函数的集合
PHP之变量、常量学习笔记
php日历[测试通过]
PHP与MySQL开发中页面乱码的产生与解决
一家之言的经验之谈php+mysql扎实个人基本功
php+mysql分页代码详解
Mysql和网页显示乱码解决方法集锦
社区(php&&mysql)五
社区(php&&mysql)三
利用php来自动调用不同服务器上的flash
社区(php&&mysql)二
社区(php&&mysql)一
如何在PHP中使用Oracle数据库(6)
BBS(php & mysql)完整版(八)
BBS(php & mysql)完整版(六)