广

PHP编程

  • IOS开发
  • android开发
  • PHP编程
  • JavaScript
  • ASP.NET
  • ASP编程
  • JSP编程
  • Java编程
  • 易语言
  • Ruby编程
  • Perl编程
  • AJAX
  • 正则表达式
  • C语言
  • 编程开发

    社区(php&&mysql)三

    2018-10-13 10:38:03 次阅读 稿源:互联网
    零七广告
    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 style="text-align:center" style="text-align:center" class='num'>";
        echo "<tr><td style="text-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%  style="text-align:center" cellPadding=1 cellSpacing=0 class='tablefont'>";
                echo "<TR><TD >";
                    viewbar();
                echo "</td></tr>";
                echo "<TR><TD>";
                //====ゅ彻==============
                echo "<TABLE BORDER=0 width=100%  style="text-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%   style="text-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='Submit'value=''>";
                           echo "</TD>";
                        echo "</TR>";
                    echo "</FORM>";     
                    echo "</TABLE>";                 
                echo "</td></tr>";
                echo "<TR><TD >";
                    //=======mail List===============
                echo "<TABLE BORDER=0 width=100%   style="text-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>";

             
    待续........
             

    零七网部分新闻及文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与零七网进行文章共享合作。

    零七广告
    零七广告
    零七广告
    零七广告