社区(php&&mysql)四
2023-06-13 09:13:43 时间
echo"<br>";
echo"<TABLEwidth=85%border=0cellPadding=0cellSpacing=1align=centerbgcolor="#6CA6CD">";
echo"<tr><td>";
echo"<TABLEwidth=100%cellPadding=1cellSpacing=1bgcolor=whiteclass="tablefont">";
echo"<trbgcolor=#F1E1FF>";
echo"<th>夹?</th>";
echo"<th>???</th>";
echo"<thwidth=30>?莱</th>";
echo"<thwidth=30>??</th>";
echo"<thwidth=70>ら戳</th>";
echo"</tr>";
$qsql="SELECT*frombbs_subjwhereid="$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"<trbgcolor="#F0F8FF">";
echo"<td>";
if($sid!=$rid){
echo"<ahref=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
echo$banner;
echo"</a>";
}elseecho"<fontcolor=red><b>$banner</B></font>";
echo"</td>";
echo"<td>";
echo$poster;
echo"</td>";
echo"<tdclass="num">";
echo$docs;
echo"</td>";
echo"<tdclass="num">";
echo$views;
echo"</td>";
echo"<tdclass="num">";
echo$wdate;
echo"</td>";
echo"</tr>";
$qsql="SELECT*frombbs_docswheresid="$sid"orderbywdate";
$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"<trbgcolor="#F0F0F0">";
echo"<td>";
if($sid!=$rid&&$rid==$id){
echo"<fontcolor=red><b> $banner</B></font>";
}else{
echo"<ahref=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
echo" $banner";
echo"</a>";
}
echo"</td>";
echo"<td>";
echo$poster;
echo"</td>";
echo"<tdclass="num">";
echo" ";
echo"</td>";
echo"<tdclass="num">";
echo$views;
echo"</td>";
echo"<tdclass="num">";
echo$wdate;
echo"</td>";
echo"</tr>";
}
echo"</td></tr></table>";
echo"</td></tr></table>";
}//====
echo"<aname="re"></a>";
if($type==1){
if(substr($rebanner,0,3)!="Re:")
$rbanner="Re:".$rebanner;
else$rbanner=$rebanner;
}
echo"<FORM name=mtabENCTYPE=multipart/form-dataMETHOD=POSTACTION=$PHP_SELF?proc=post2>";
echo"<inputtype="hidden"name=aidvalue="$aid">";
echo"<inputtype="hidden"name=sidvalue="$sid">";
echo"<inputtype="hidden"name=typevalue="$type">";
echo"<TABLEwidth=95%BORDER=0 align=centercellPadding=3cellSpacing=0class="tablefont">";
if($sid){
echo"<TRbgcolor="white">";
echo"<THcolspan=2>";
echo"???阶??杠?";
echo"</TH>";
echo"</TR>";
}
echo"<TR>";
echo"<TDwidth=100align=right>";
echo"??:";
echo"</TD>";
echo"<TD>";
echo"<INPUTTYPE="text"NAME="banner"size=60value="$rbanner">";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDwidth=100align=right>";
echo"?ē?:";
echo"</TD>";
echo"<TD>";
echo"<INPUTTYPE="text"NAME="poster"size=30value="$c_poster">";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDwidth=100align=right>";
echo"E-Mail:";
echo"</TD>";
echo"<TD>";
echo"<INPUTTYPE="text"NAME="email"size=30value="$c_email">";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDwidth=100align=rightvalign=top>";
echo"ず?:";
echo"</TD>";
echo"<TD>";
echo"<fontcolor=green>や穿??挡ノ??ㄒ:<fontcolor=red><b>[www]http://www.jerry.com.tw[/www]</b></font></font><br>";
echo"<TEXTAREANAME="body"cols="80"rows="16">";
echo"</TEXTAREA>";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDalign=centercolspan=2>";
//echo"<INPUTTYPE="checkbox"NAME="remail">";
//echo"?滦???";
if($sid){
$br="-----------------------------------------------------------";
$obody="まノ$poster?ゅ彻n$brn".$body;
$obody.="n$brn?滦?阶?ず???:n";
echo"<inputtype="hidden"name=obodyvalue="$obody">";
echo"<INPUTTYPE="button"value="まノ?ゅ"onClick="this.form.body.value=this.form.body.value+this.form.obody.value;this.form.obody.value="";">";
}
echo" <INPUTTYPE="submit"value="??">";
echo"</TD>";
echo"</TR>";
echo"</TABLE>";
}
待续.......
echo"<TABLEwidth=85%border=0cellPadding=0cellSpacing=1align=centerbgcolor="#6CA6CD">";
echo"<tr><td>";
echo"<TABLEwidth=100%cellPadding=1cellSpacing=1bgcolor=whiteclass="tablefont">";
echo"<trbgcolor=#F1E1FF>";
echo"<th>夹?</th>";
echo"<th>???</th>";
echo"<thwidth=30>?莱</th>";
echo"<thwidth=30>??</th>";
echo"<thwidth=70>ら戳</th>";
echo"</tr>";
$qsql="SELECT*frombbs_subjwhereid="$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"<trbgcolor="#F0F8FF">";
echo"<td>";
if($sid!=$rid){
echo"<ahref=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
echo$banner;
echo"</a>";
}elseecho"<fontcolor=red><b>$banner</B></font>";
echo"</td>";
echo"<td>";
echo$poster;
echo"</td>";
echo"<tdclass="num">";
echo$docs;
echo"</td>";
echo"<tdclass="num">";
echo$views;
echo"</td>";
echo"<tdclass="num">";
echo$wdate;
echo"</td>";
echo"</tr>";
$qsql="SELECT*frombbs_docswheresid="$sid"orderbywdate";
$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"<trbgcolor="#F0F0F0">";
echo"<td>";
if($sid!=$rid&&$rid==$id){
echo"<fontcolor=red><b> $banner</B></font>";
}else{
echo"<ahref=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
echo" $banner";
echo"</a>";
}
echo"</td>";
echo"<td>";
echo$poster;
echo"</td>";
echo"<tdclass="num">";
echo" ";
echo"</td>";
echo"<tdclass="num">";
echo$views;
echo"</td>";
echo"<tdclass="num">";
echo$wdate;
echo"</td>";
echo"</tr>";
}
echo"</td></tr></table>";
echo"</td></tr></table>";
}//====
echo"<aname="re"></a>";
if($type==1){
if(substr($rebanner,0,3)!="Re:")
$rbanner="Re:".$rebanner;
else$rbanner=$rebanner;
}
echo"<FORM name=mtabENCTYPE=multipart/form-dataMETHOD=POSTACTION=$PHP_SELF?proc=post2>";
echo"<inputtype="hidden"name=aidvalue="$aid">";
echo"<inputtype="hidden"name=sidvalue="$sid">";
echo"<inputtype="hidden"name=typevalue="$type">";
echo"<TABLEwidth=95%BORDER=0 align=centercellPadding=3cellSpacing=0class="tablefont">";
if($sid){
echo"<TRbgcolor="white">";
echo"<THcolspan=2>";
echo"???阶??杠?";
echo"</TH>";
echo"</TR>";
}
echo"<TR>";
echo"<TDwidth=100align=right>";
echo"??:";
echo"</TD>";
echo"<TD>";
echo"<INPUTTYPE="text"NAME="banner"size=60value="$rbanner">";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDwidth=100align=right>";
echo"?ē?:";
echo"</TD>";
echo"<TD>";
echo"<INPUTTYPE="text"NAME="poster"size=30value="$c_poster">";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDwidth=100align=right>";
echo"E-Mail:";
echo"</TD>";
echo"<TD>";
echo"<INPUTTYPE="text"NAME="email"size=30value="$c_email">";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDwidth=100align=rightvalign=top>";
echo"ず?:";
echo"</TD>";
echo"<TD>";
echo"<fontcolor=green>や穿??挡ノ??ㄒ:<fontcolor=red><b>[www]http://www.jerry.com.tw[/www]</b></font></font><br>";
echo"<TEXTAREANAME="body"cols="80"rows="16">";
echo"</TEXTAREA>";
echo"</TD>";
echo"</TR>";
echo"<TR>";
echo"<TDalign=centercolspan=2>";
//echo"<INPUTTYPE="checkbox"NAME="remail">";
//echo"?滦???";
if($sid){
$br="-----------------------------------------------------------";
$obody="まノ$poster?ゅ彻n$brn".$body;
$obody.="n$brn?滦?阶?ず???:n";
echo"<inputtype="hidden"name=obodyvalue="$obody">";
echo"<INPUTTYPE="button"value="まノ?ゅ"onClick="this.form.body.value=this.form.body.value+this.form.obody.value;this.form.obody.value="";">";
}
echo" <INPUTTYPE="submit"value="??">";
echo"</TD>";
echo"</TR>";
echo"</TABLE>";
}
待续.......
相关文章
- PHP和MySQL:构建动态网站的利器(php与mysql)
- PHP使用MySQL数据库:最佳实践(php查询mysql数据库)
- MySQL访问图片:实现图片存取的新方式(mysql访问图片)
- 详解MySQL数据库语句解析:从入门到精通(mysql数据库语句)
- 技术实现的网络系统PHP和MySQL结合:搭建网络系统的利器.(基于php和mysql)
- MySQL禁用SSL安全协议(mysql关闭ssl)
- MySQL and PHP: Establishing the Perfect Connection(mysql链接php)
- 远程探索——PHP与MySQL的结合(php远程连接mysql)
- PHP连接MySQL:完成数据库操作的基本语句(php连接mysql语句)
- MySQL验证:PHP实现细节(php验证mysql)
- 器中的日志如何清除MySQL服务器中的日志记录(清除mysql服务)
- Mysql格式化时间的快速方法(mysql把时间格式化)
- 教你如何用 PHP 创建 MySQL 数据表(php创建mysql表)
- MySQL查询:获取最后一条数据(mysql查询最后一条数据)
- MySQL连接池:PHP提供的快速访问方式(mysql连接池php)
- 那么流行PHP和MySQL——广泛应用的利器(为什么php和mysql)
- PHP遍历MySQL:从基本循环到高效操作(php遍历mysql)
- MySQL成功迁移至DB2数据库平台,企业数据更加安全稳定!(mysql迁移db2)
- AMP MySQL升级提升数据库性能的必要之举(amp mysql升级)
- BBS(php&mysql)完整版(六)
- BBS(php&mysql)完整版(一)