六月婷婷综合激情-六月婷婷综合-六月婷婷在线观看-六月婷婷在线-亚洲黄色在线网站-亚洲黄色在线观看网站

明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！

社區(php&&mysql)二

發表時間：2024-05-25 來源：明輝站整理相關軟件相關文章人氣：

[摘要]function sdatetime(str) str=ereg_replace("-","/",str); str=substr(str,5,strlen(str)-8); return str; function reAnum(...
function sdatetime($str){
    $str=ereg_replace("-","/",$str);
    $str=substr($str,5,strlen($str)-8);
    return $str;
}

function reAnum($sid){ //羆萊絞計
    $DROOT=getenv('DOCUMENT_ROOT');
    include("sql.php3");
    $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
    $qsql="SELECT id from bbs_docs where sid='$sid'";
    $rs=mysql_db_query($sql['db'],$qsql);
    return mysql_num_rows($rs);
}

function pagebar($pages) {
    global $pgno;
    //global $pages;
    global $PHP_SELF;
    global $aid;
    global $OPEN_LIST;
    echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD' class='num'>";
    echo "<tr><td>";
    if($pgno!=0) {
        $pu=$pgno-1;
        echo "<a href=$PHP_SELF?aid=$aid&pgno=$pu>[]</a>";         
    }     
    if($pgno<$pages) {
        $pd=$pgno+1;
        echo "<a href=$PHP_SELF?aid=$aid&pgno=$pd>[]</a>";         
    }     
    for($i=0;$i<=$pages;$i++) {
        if($pgno==$i) {
            echo "<b>";
            echo "[".($i+1)."]";
            echo "</b>";     
        } else {
            echo "<a href=$PHP_SELF?aid=$aid&pgno=$i>";
            echo "[".($i+1)."]";
            echo "</a>";     
        }
    }
    echo "</td>";
    echo "<TD align=right>";
        echo "<a href=$PHP_SELF?proc=view&aid=$aid>";
                echo "[祇ゅ徹]";
                echo "</a>";
    //echo "</TD>";
    //echo "<TD align=right>";
            if($OPEN_LIST) {
                echo "<a href=$PHP_SELF?proc=colloff&aid=$aid&pgno=$pgno>";
                echo "[ぃ甶秨杠肈]";
                echo "</a>";
            }else {
                echo "<a href=$PHP_SELF?proc=collon&aid=$aid&&pgno=$pgno>";
                echo "[甶秨杠肈]";
                echo "</a>";
            }
    echo "</TD>";         
    echo "</tr></table>";     
     
}
//===============================================================================
function openlist($sid) {
    global $aid;
    global $PHP_SELF;
     
    $DROOT=getenv('DOCUMENT_ROOT');
    include("sql.php3");
    $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
    $qsql="SELECT * from bbs_docs where sid='$sid' order by wdate";
    $rs=mysql_db_query($sql['db'],$qsql);
    //if(mysql_num_rows($rs)==0) return;
    //echo  mysql_num_rows($rs);
    while($row=mysql_fetch_array($rs)) {
        $id=$row['id'];
            $banner=$row['banner'];
            $poster=$row['poster'];
            $views=$row['views'];
            $wdate=sdatetime($row['wdate']);
             
            echo "<tr bgcolor='#F0F0F0'>";
                echo "<td>";
                    echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
                    echo "&nbsp;&nbsp;<font color=#836FFF>$banner</font>";
                    echo "</a>";
                    //echo "banner is $banner";
                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>";
    }
     
}

//========================================================================
function area() {
    global $PHP_SELF;
    global $aid,$sid,$pgno;
    global $OPEN_LIST;
    $showitems=20;
    $DROOT=getenv('DOCUMENT_ROOT');
    include("sql.php3");
    $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
    //============================================================
    if(!$aid) {
          $qsql="SELECT id from bbs_area";
          $rs=mysql_db_query($sql['db'],$qsql);
          $row=mysql_fetch_array($rs);
          $aid=$row['id'];               
        }
    if(!$sid) {
        $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
        $rs=mysql_db_query($sql['db'],$qsql);
        $row=mysql_fetch_array($rs);
        $sid=$row['id'];     
    }     
     
    if(!$pgno) {//礚﹚計
        //$pgno=0;  
        $items=0;
        $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
        $rs=mysql_db_query($sql['db'],$qsql);
        while($row=mysql_fetch_array($rs)){
            $id=$row['id'];     
            if($id==$sid) break;
            $items++;
        }
        $pgno=(INT)($items/$showitems);         
    }
     
    //============================================================
    $qsql="SELECT * from bbs_area where id=$aid ";
    $rs=mysql_db_query($sql['db'],$qsql);
    $row=mysql_fetch_array($rs);
    $banner=$row['banner'];
    $body=$row['body'];
    $master=$row['master'];
    echo "<center><font color=GREEN size=5><b>$banner</b></font></center>";
     
    echo "<FORM  name=mtab  ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=search>";
    echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center class='tablefont'>";
      echo "<tr><td>";
           
              echo "<input type='hidden' name=aid value='$aid'>";     
              echo "穓碝ゅ徹:";
              echo "<INPUT TYPE='TEXT' NAME='key' size=25 class='tablefont'>";
              echo "<INPUT TYPE='Submit'value='琩高' class='tablefont'>";
           
      echo "</td></tr>";
    echo "</table>";  
    echo "</FORM>";  
     
    $qsql="SELECT * from bbs_subj where aid=$aid order by wdate DESC";
    $rs=mysql_db_query($sql['db'],$qsql);
    $all=mysql_num_rows($rs);  //how rows
    $pages=(INT)($all/$showitems); // how pages
    $pgcount=$pgno*$showitems;
    if($pgcount > $all) {  
        $pgno=$pages-1; // Page point over all pages
        $pgcount=$pgno*$showitems;
     }
    mysql_data_seek($rs, $pgcount);
    $cnt=0;
    pagebar($pages);
    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>";
        while($row=mysql_fetch_array($rs)) {
            if(++$cnt > $showitems) break;
            $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>";
                    echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
                        if($sid==$id) echo "<font color=red>〈$banner</font>";
                        else echo $banner;
                    echo "</a>";
                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>";
            if($OPEN_LIST) openlist($id);
        }
      echo "</td></tr></table>";
    echo"</td></tr></table>";       
     
    pagebar($pages);
}
待續........ 

相關文章
主站蜘蛛池模板： 色吊丝性永久免费看码 | 中文字幕第233页 | 日本天堂网站 | 日本a在线视频 | 全部免费特黄特色大片视频 | 欧美一区日韩一区中文字幕页 | 四虎成人免费网址在线 | 亚洲成a人v在线观看 | 亚洲高清免费视频 | 青青青久草 | 日韩一级欧美一级一级国产 | 午夜天堂在线 | 亚洲图片在线欧美专区图片 | 五福影院凹凸一区二区 | 日韩精品欧美激情国产一区 | 中日韩国语视频在线观看 | 天狼影院伦理片在线bd观看 | 日韩中文字幕在线 | 欧美在线视频免费播放 | 青青草原亚洲 | 人人干狠狠干 | 欧美视频免费在线播放 | 中文字幕亚洲综久久2021 | 日本一区二区在线免费观看 | 一级毛片一级毛片一级毛片一级毛片 | 日韩爱爱小视频 | 一级黄色a级片 | 亚洲一区二区免费看 | 天天av天天翘天天综合网 | 人人草97 | 特一级黄色 | 人人草人人爱 | 青娱乐免费在线观看 | 中文字幕第15页 | 亚洲国产精品久久久天堂麻豆 | 欧美一级做性受 | 欧美一级欧美三级在线观看 | 片免费观看在线看 | 亚洲免费网站 | 日韩免费不卡视频 | 综合网久久|