首页 > 数据库 > MySQL > 正文

社区(php&&mysql)四

2024-07-24 12:56:42
字体:
来源:转载
供稿:网友
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>&nbsp;&nbsp;$banner</b></font>";
                    } else {
                        echo "<a href=$php_self?proc=view&aid=$aid&sid=$sid&rid=$id>";
                        echo "&nbsp;&nbsp;$banner";
                        echo "</a>";
                    }
                echo "</td>";
                echo "<td>";
                    echo $poster;
                echo "</td>";
                echo "<td class='num'>";
                    echo "&nbsp;";
                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 "&nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' value='癳'>";
            echo "</td>";
        echo "</tr>";
    echo "</table>";
     
}
待续....... 
中国最大的web开发资源网站及技术社区,
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表