社区(php&&mysql)四

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>  $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 "癚阶硂杠肈";
            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 "    <INPUT TYPE='submit' value='癳'>";
            echo "</TD>";
        echo "</TR>";
    echo "</TABLE>";

}
待续.......

(0)

相关推荐

  • 社区(php&&mysql)四

    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 b

  • MySQL 四种事务隔离级别详解及对比

    MySQL 四种事务隔离级别详解及对比 按照SQL:1992 事务隔离级别,InnoDB默认是可重复读的(REPEATABLE READ).MySQL/InnoDB 提供SQL标准所描述的所有四个事务隔离级别.你可以在命令行用--transaction-isolation选项,或在选项文件里,为所有连接设置默认隔离级别. 例如,你可以在my.inf文件的[mysqld]节里类似如下设置该选项: transaction-isolation = {READ-UNCOMMITTED | READ-CO

  • win10 下安装mysql服务器社区版本mysql 5.7.22 winx64的图文教程

    下载: http://dev.mysql.com/downloads/mysql/ 解压到C盘 添加环境变量path 添加环境变量 右击我的电脑->属性->高级系统设置->高级->环境变量-> 在系统变量中找到变量Path,点击编辑,在变量值最后面添加解压路径,路径要到bin文件夹下的路径,如: 以管理员权限运行cmd 安装MySQL服务 在cmd 命令窗口下 输入 mysqld install 初始化mysql数据库,这时会创建刚刚配置的data目录和一些数据库系统用的基本

  • 简述MySql四种事务隔离级别

    隔离级别: 隔离性其实比想象的要复杂. 在SQL标准中定义了四种隔离级别, 每一个事务中所做的修改,哪些在事务内和事务间是可见的,哪些是不可见的.较低级别的隔离通常可以执行更高的并发,系统的开销也更低. 下面简单地介绍一下四种隔离级别. 1.READ UNCOMMITTED(未提交读) 在 READ UNCOMMITTED级别, 事务中的修改, 即使没有提交, 对其他事务也都是可见的. 事务可以读取未提交的数据, 这也被称为脏读 (Dirty Read). 这个级别会导致很多问题,从性能上来说,

  • Mysql四种分区方式以及组合分区落地实现详解

    目录 一.问题 1.分区是什么 2.Mysql为什么要使用分区 3.Mysql中分区原理 4.Mysql中分区局限 二.分区落地实现 1.Range分区 2.Hash分区 3.Key分区 4.Mysql中如何落地List分区 5.Mysql中如何落地组合分区 三.Mysql如何管理分区 1.删除分区 2.重建分区 2.1RANGE 分区重建 2.2 LIST 分区重建 2.3 HASH/KEY 分区重建 3. 新增分区 3.1 新增 RANGE 分区 3.2 新增 HASH/KEY 分区 3.3

  • MySQL四种事务隔离级别详解

    本文实验的测试环境:Windows 10+cmd+MySQL5.6.36+InnoDB 一.事务的基本要素(ACID) 1.原子性(Atomicity):事务开始后所有操作,要么全部做完,要么全部不做,不可能停滞在中间环节.事务执行过程中出错,会回滚到事务开始前的状态,所有的操作就像没有发生一样.也就是说事务是一个不可分割的整体,就像化学中学过的原子,是物质构成的基本单位. 2.一致性(Consistency):事务开始前和结束后,数据库的完整性约束没有被破坏 .比如A向B转账,不可能A扣了钱,

  • 聊天室php&mysql(四)

    第四个页面 name="index.php" <? include "../signup/mysql.php"; header("Expires: Sun, 28 Dec 1997 09:32:45 GMT"); header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); header("Co

  • MySQL 四种连接和多表查询详解

    目录 MySQL 内连接.左连接.右连接.外连接.多表查询 构建环境: 一.INNER JION 内连接 ( A ∩ B ) 二.LEFT JOIN 左外连接( A 全有 ) 三.RIGHT JOIN 右外连接 (B 全有) 四.FULL JOIN 全外连接( A + B) 五.LEFT Excluding JOIN ( A - B 即 A 表独有)+ 六.RIGHT Excluding JOIN ( B - A 即 B表独有) 七.OUTER Excluding JOIN (A 与 B 各自独

  • 社区(php&&mysql)一

    function cook_cooloff(){     global $PHP_SELF,$aid,$pgno;     setcookie("OPEN_LIST",0,time()+ 31536000);     Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");     exit; } //==========================================================

  • 社区(php&&mysql)五

    function post2() {     global $sid,$aid,$PHP_SELF;     global $banner,$body,$poster,$email,$type,$CHAR_GB; if(strlen($banner)==0 || strlen($body)==0 || strlen($poster)==0 || strlen($email)==0) {         echo "           <script language=javascript

随机推荐