zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

社区(php&&mysql)四

mysqlampPHP 社区
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>";

}
待续.......