社区(php&&mysql)三_php实例

function prev_subj($id){
    $DROOT=getenv(DOCUMENT_ROOT);
    include("sql.php3");
    $db=mysql_connect($sql[host], $sql[user] , $sql[passwd]);  
    $qstr="select id,aid from bbs_subj where id=$id";
    $rs=mysql_db_query($sql[db],$qstr);     
    $row=mysql_fetch_array($rs);
    $aid=$row[aid];
     
    $qstr="select id from bbs_subj where aid=$aid order by wdate DESC";
    $rs=mysql_db_query($sql[db],$qstr);
    $pid=$id;     
    while($row=mysql_fetch_array($rs)){
        $tid=$row[id];     
        if($id==$tid) break;
        $pid=$tid;
    }
     
    return $pid;
}
// 絞
function next_subj($id){
    $DROOT=getenv(DOCUMENT_ROOT);
    include("sql.php3");
    $db=mysql_connect($sql[host], $sql[user] , $sql[passwd]);  
    $qstr="select id,aid from bbs_subj where id=$id";
    $rs=mysql_db_query($sql[db],$qstr);     
    $row=mysql_fetch_array($rs);
    $aid=$row[aid];
     
    $qstr="select id from bbs_subj where aid=$aid order by wdate DESC";
    $rs=mysql_db_query($sql[db],$qstr);
    $pid=$id;     
    while($row=mysql_fetch_array($rs)){
        $pid=$row[id];     
        if($id==$pid) break;
    }
    if($row=mysql_fetch_array($rs)) {
        $pid=$row[id];
    }
    return $pid;
}

//======================================================================
function viewbar() {
    global $pgno;
    global $PHP_SELF;
    global $aid,$sid;
    //global $OPEN_LIST;
    echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center align=center class=num>";
    echo "<tr><td align=center>";
        $nextid=next_subj($sid);
        $previd=prev_subj($sid);
        echo "<a href=$PHP_SELF?aid=$aid&sid=$sid>[夹肈跋]</a>";
        echo "<a href=#re>[莱セ絞]</a>";
        echo "<a href=$PHP_SELF?proc=view&aid=$aid>[祇穝ゅ彻]</a>";
        echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$nextid&rid=$nextid>[絞]</a>";
        echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$previd&rid=$previd>[絞]</a>";
        //echo "<a href=$PHP_SELF?proc=view&pgno=$pgno&aid=$aid&sid=$previd&rid=$previd>[程絞]</a>";
         
    echo "</td>";
             
    echo "</tr></table>";     
     
}
//======================================================================
function view() {
    global $PHP_SELF,$aid,$sid,$rid;
    global $c_poster,$c_email;
    //echo "$PHP_SELF,$aid,$sid,$rid,$pgno";
    $type=0; //秨穝杠肈
  if($sid && $rid) {
      addhitviews($sid,$rid);
    $type=1; //莱
    $db_table="bbs_subj";
    if($sid!=$rid)    $db_table="bbs_docs";
    $DROOT=getenv(DOCUMENT_ROOT);
    include("sql.php3");
    $db=mysql_connect($sql[host], $sql[user] , $sql[passwd]);  
    $qstr="select banner from bbs_area where id=$aid";
    $rs=mysql_db_query($sql[db],$qstr);
    echo mysql_error();
    $row=mysql_fetch_array($rs);
    $abanner=$row[banner];
     
    $qsql="SELECT * from $db_table where id=$rid ";
    $rs=mysql_db_query($sql[db],$qsql);
    $row=mysql_fetch_array($rs);
    $poster=$row[poster];
    $pip=$row[pip];
    $wdate=$row[wdate];
    $rebanner=$banner=$row[banner];
    $body=$row[body];
    $body=htmlspecialchars($body);
    $pbody=ereg_replace("n","<br>",$body);
    $pbody =preg_replace( "/[www *]([\x0-\xff]*?)[/www *]/", <a href="\1"  target="_blank">\1</a>, $pbody );  
    $pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", <a href="\1"  target="_blank">\2</a>, $pbody );  
     
    echo "<center>";
    echo "<font color=GREEN size=5><b>[$abanner]<br>";
    echo "$banner</b></font></center>";
    echo "<TABLE BORDER=0 width=95%  align=center cellPadding=1 cellSpacing=0 class=tablefont>";
            echo "<TR><TD >";
                viewbar();
            echo "</td></tr>";
            echo "<TR><TD>";
            //====ゅ彻==============
            echo "<TABLE BORDER=0 width=100%  align=center cellPadding=1 cellSpacing=0 class=tablefont>";
            echo "<TR>";
                echo "<TD  width=120 align=right>";
                    echo ":";
                echo "</TD>";
                echo "<TD align=left>";
                    echo $poster;
                echo "</TD>";
            echo "</TR>";
            echo "<TR>";
                echo "<TD width=120 align=right>";
                    echo "ㄓ:";
                echo "</TD>";
                echo "<TD align=left>";
                    echo $pip;
                echo "</TD>";
            echo "</TR>";
            echo "<TR>";
                echo "<TD width=120 align=right valign=top>";
                    echo "ゅ彻ず甧:";
                echo "</TD>";
                echo "<TD valign=top class=bodycolor align=left>";
                            echo $pbody;
                            echo "<hr size=1>";
                echo "</TD>";
            echo "</TR>";
            echo "</TD></TR>";
            echo "</TABLE>";
            echo "<TR><TD >";
             
                //=======籔狟ねだㄉ===============
                echo "<TABLE BORDER=0 width=100%   align=center cellPadding=3 cellSpacing=0 class=menufont>";     
                echo "<FORM  name=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=mail_friend>";
                echo "<input type=hidden name=sid value=$sid>";
                echo "<input type=hidden name=aid value=$aid>";
                echo "<input type=hidden name=rid value=$rid>";
                echo "<input type=hidden name=poster value=$c_poster>";
                echo "<input type=hidden name=email value=$c_email>";
                    echo "<TR>";
                       echo "<TD align=right width=250>";
                        echo "籔狟ねだㄉ硂絞ゅ彻:";
                       echo "</TD>";
                       echo "<TD>";
                        echo "<INPUT TYPE=TEXT NAME=frmail size=25 value=ねE-mail>";
                
                        echo "<INPUT TYPE=Submitvalue=癳>";
                       echo "</TD>";
                    echo "</TR>";
                echo "</FORM>";     
                echo "</TABLE>";                 
            echo "</td></tr>";
            echo "<TR><TD >";
                //=======mail List===============
            echo "<TABLE BORDER=0 width=100%   align=center cellPadding=3 cellSpacing=0 class=menufont>";     
            echo "<FORM  name=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=mail_list>";
                echo "<input type=hidden name=sid value=$sid>";
                echo "<input type=hidden name=aid value=$aid>";
                echo "<input type=hidden name=rid value=$rid>";
                echo "<input type=hidden name=poster value=$c_poster>";
                echo "<input type=hidden name=email value=$c_email>";

            echo "<TR >";
               echo "<TD align=right width=250>";
                echo "璹境o肈尿癚阶:";
               echo "</TD>";
               echo "<TD>";
                if(strlen($c_email)) $addmail=$c_email;
                else $addmail="E-mail";
                echo "<INPUT TYPE=TEXT NAME=email size=25 value=$addmail>";
                echo "<INPUT TYPE=Submit name=way1 value=璹?>";
                echo "<INPUT TYPE=Submit name=way2 value=璹?>";
                $qsql="SELECT id from bbs_sml where sid=$sid";
                $rs=mysql_db_query($sql[db],$qsql);
                $nums=mysql_num_rows($rs);
                echo "<br>硂肈ヘ玡璹兢H计:$nums";
               echo "</TD>";
            echo "</TR>";     
            echo "</FORM>";
            echo "</TABLE>";     
         
            echo "</td></tr>";
            echo "<TR><TD >";
                viewbar();
            echo "</td></tr>";
        echo "</TABLE>";
         
         
待续……..