社区(php&&mysql)四

php  /  管理员 发布于 7年前   201

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 >夹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>";

}
待续.......