<form id="hz9zz"></form>
    • <form id="hz9zz"></form>
    

      

      <nobr id="hz9zz"></nobr>
      <form id="hz9zz"></form>
      3.   
          
      明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！
                   
        
                           
        
                        		  
        
                 
              
                
      新聞公布系統 (例子) 一 news
                
                  發表時間：2023-08-08             來源：明輝站整理相關軟件相關文章人氣：          
              
      [摘要]<? /*News Donkey v1.0d8b db d88888b db d8b db .d8888. by Oscar Rylin [oscar@mgon.com] 888o88 88&...
      <?
       /*
      News Donkey v1.0d8b db d88888b db d8b db .d8888. 
      by Oscar Rylin [oscar@mgon.com] 888o88 88' 88 I8I 88 88'YP 
      88V8o 88 88ooooo 88 I8I 88 `8bo. 
      88 V8o88 88~~~~~ Y8 I8I 88 `Y8b. 
      88V888 88. `8b d8'8b d8' db 8D 
      VP V8P Y88888P`8b8' `8d8'`8888Y' 
       
       
      d8888b..d88b.d8b db db dD d88888b dbdb 
      88`8D .8PY8. 888o88 88 ,8P' 88' `8bd8' 
      88 88 8888 88V8o 88 88,8P 88ooooo`8bd8'
      88 88 8888 88 V8o88 88`8b 88~~~~~88
      88.8D `8bd8' 88V888 88 `88. 88.88
      Y8888D'`Y88P'VP V8P YP YD Y88888PYP

      This script was made by Oscar Rylin (oscar@mgon.com) while learning PHP w/
      MySQL connections.

      What the script Does:
       * Provides an easy way to Read news from a MySQL database
       * Prints it out in a nice HTML format which is customizable
       * Provides a secure interface (user/password validation through a MySQL db) 
       * Updating news, deleting and adding users and lots of other stuff
       */

       include "dbconn.php"; // This is http://zend.com/codex.php?id=35&single=1
       include "settings.php"; // The settings file
      ?>

      <html>
       <head>
      <title>newsM0nger1.0</title>
      <style type="text/css">
       .section { font-weight: bold; font-size:10pt; }
       .newsTxt { font-weight: normal; font-size:10pt; color: #ffffff; font-family: verdana; }
       a{ font-weight: bold; font-size:10pt; color: #ffffff; font-family: verdana; }
       a.normal { font-weight: bold; font-size:10pt; color: #000000; font-family: verdana; }
      </style>
       </head>
       <body bgcolor="white">
      <? print $header; ?>
      <center>
       <table border="1" cellpadding="0" cellspacing="0" bordercolor="black">

      <?
       
       $db = mysql_connect($dbHost, $dbUser, $dbPass); 
      mysql_select_db($dbName,$db); 
      $result = mysql_query("select count(id) as Total from news",$db); 
      $row = mysql_fetch_array($result); 
       mysql_close($db); 

       if ($row[Total] > 5) {
      $pCount = 0;
      print "<b>Archive</b> ?";
      print "<a href=\"$PHP_SELF?start=0\" class=\"normal\">Main</a> ";
      while ($pCount < ($row[Total]/5)-1) {
       ++$pCount;
       print "<a href=\"$PHP_SELF?start=". ($pCount*5) ."\" class=\"normal\">$pCount</a> ";
      }
       }

       $tmpDL = 0;

       $sql = new CDBMySQL($dbHost, $dbUser, $dbPass, $dbName); 
      if ($start) {
       $sql -> Query ("SELECT * FROM news WHERE id < ". ($row[Total] - $start) . " ORDER BY id DESC");
      } else {
      $sql -> Query ("SELECT * FROM news ORDER BY id DESC"); 
      }

      while (($sql -> ReadRow()) && ($tmpDL < $newsDL)){
       
       $id = ($sql -> RowData["id"]);
       $date = ($sql -> RowData["date"]);
       $poster = ($sql -> RowData["user"]);
       $header = ($sql -> RowData["header"]);
       $news = ($sql -> RowData["news"]);
       $news = nl2br($news);

       $uDB = new CDBMySQL($dbHost, $dbUser, $dbPass, $dbName); 
       $uDB -> Query ("SELECT * FROM users where user=\"$poster\""); 

       while ($uDB -> ReadRow()){ 
      $email = ($uDB -> RowData["email"]);
       }
       $uDB -> Close();
       
       $format = "

      <tr>
       <td width=\"579\" height=\"20\" background=\"section.gif\" class=\"section\" colspan=\"2\">
       <font color=\"white\">$date</font>   -  <font color=\"#003366\">$header</font>
       </td>
      </tr>

      <tr> 
       <td bgcolor=\"#666688\" class=\"newsTxt\" colspan=\"2\">
      $news
      <br>
      -- <a href=\"mailto:$email\">$poster</a>
       </td>
      </tr>

      <tr> 
       <td bgcolor=\"#ffffff\" height=\"20\" colspan=\"2\">
       </td>
      </tr>
      ";
       print "$format";
       ++$tmpDL;
      } 
       //$sql -> Close(); 
      ?>

      <table border="0" cellpadding="0" cellspacing="0" width="579">
       <tr><td width="50%" align="left"><img src=http://cfan.net.cn/info/"php.gif"></td><td width="50%" align="right"><img src=http://cfan.net.cn/info/"mysql.gif"></td></tr>
       
      </center>
      <? print $footer; ?>
       </body>
      </html>


              
              
                 
              
                                            
                              		       
                          
                           		  
        
                            
      
日韩精品一区二区三区高清