四 文章類 封裝對文章的各種操作（插入資料庫、從資料庫取出等等)

插入|封裝|資料|資料庫 <?php
//
// +----------------------------------------------------------------------+
// | 文章類                                                               |
// +----------------------------------------------------------------------+
// | Copyright (c) 2001 NetFish Software                                  |
// |                                                                      |
// | Author: whxbb(whxbb@21cn.com)                                        |
// +----------------------------------------------------------------------+
//
// $Id: whxbb_article.class.php,v 0.1 2001/8/11 22:18:13 yf Exp $
//

// 禁止直接存取該頁面
if (basename($HTTP_SERVER_VARS['PHP_SELF']) == "whxbb_article.class.php") {
    header("HTTP/1.0 404 Not Found");
}


/**
* 文章類
* Purpose
*  封裝對文章的各類操作
*
*
* @author  : whxbb(whxbb@21cn.com)
* @version : 0.1
* @date    :  2001/8/1
*/

class WHXBB_Article extends WHXBB
{
    /** 分頁對象 */
    var $pager;

    function Article()
    {
        $this->WHXBB();
    }
    /**
     * 文章寫入資料庫
     * @param $title 文章標題
     * @param $author 文章作者
     * @param $content 文章內容
     * @return 操作出錯：一個WHXBB_Error對象　成功:true
     * @access public
     */
    function Insert($title, $author, $content)
    {
        new WHXBB_Debug("Insert() Start");

        // 處理傳入的參數
        WHXBB::OperateString(&$title, 'in');
        WHXBB::OperateString(&$author, 'in');
        WHXBB::OperateString(&$content, 'in');

        $sql = "insert into article(title,author,content) values('$title','$author','$content')";
        if( !@mysql_query($sql, $this->_conn) )
        {
            return new WHXBB_Error("Insert() Failed.($sql)", 1021);
        }
        new WHXBB_Debug("Insert() Completed");
        return true;
    }
    /**
     * 刪除指定的記錄
     * @param $id 要刪除記錄的id
     * @return 操作出錯：一個WHXBB_Error對象　成功:true
     * @access public
     */
    function Del($id)
    {
        new WHXBB_Debug("Del($id) Start");

        $sql = "delete from article where id=$id)";
        if( !@mysql_query($sql, $this->_conn) )
        {
            return new WHXBB_Error("Del() Failed.($sql)", 1024);
        }
        new WHXBB_Debug("Dle($id) Completed");
        return true;
    }
    /**
     * 得到文章的總數
     * @param $condition      查詢條件
     * @return 操作出錯：一個WHXBB_Error對象　成功:true
     * @access public
     */
    function GetCount($condition = '')
    {
        new WHXBB_Debug("GetCount() Start");
        $sql = "select count(id) from article where  1=1 $condition";
        if( !$result = @mysql_query($sql, $this->_conn))
        {
            return new WHXBB_Error("GetCount() Failed.($sql)", 1000);
        }        
        list($count) = @mysql_fetch_array($result);
        @mysql_free_result($result);
        new WHXBB_Debug("GetCount() Completed");
        return $count;
    }

    /**
     * 得到某一篇文章的所有欄位資訊
     * @param $id 文章id號
     * @return 操作出錯：一個WHXBB_Error對象　成功:返回一個關聯陣列 找不到資訊:返回0
     * @access public
     */
    function GetInfo($id )
    {
        new WHXBB_Debug("GetInfo($id) Start");
        $sql = "select  id, title, content, author from article where id=$id";
        $result = @mysql_query($sql, $this->_conn);
        if( !$result)
            return new WHXBB_Error("GetInfo($id) Failed.($sql)", 1002);

        if(@mysql_num_rows($result) == 0)
            return 0;

        $info = @mysql_fetch_array($result);
        while (list($var, $key) = each($info))
        {
            WHXBB::OperateString(&$info[$var], 'out');
        }
        reset($info);
        @mysql_free_result($result);
        new WHXBB_Debug("GetInfo($id) Completed");
        return $info;
    }

    /**
     * 得到所有author為指定作者名的所有記錄
     * @param $items 每頁顯示條數，如果為0則表示取出所有記錄
     * @param page   當前頁碼
     * @param author 作者名
     * @param $orderBy 排序方式
     * @return 操作出錯：一個WHXBB_Error對象　成功:返回一個數組 找不到資訊:返回0
     * @access public
     */
     function GetNInfoByAuthor($items, $page, $author, $orderBy = 'order by id desc')
     {
        WHXBB::OperateString(&$author, 'in');
        $condition = " and author='$author'  ";
        $result = $this->GetNInfo($items, $page, $condition, $orderBy);
        return $result;
     }


     }
    /**
     * 列出所有記錄
     * @param $items 每頁顯示條數，如果為0則表示取出所有記錄
     * @param $page  當前頁碼
     * @param $condition 查詢條件
     * @param $orderBy 排序方式
     * @return 操作出錯：一個WHXBB_Error對象　成功:返回一個二維數組 找不到資訊:返回0
     * @access public
     */
    function GetNInfo($items, $page, $condition = '', $orderBy = 'order by id desc')
    {
        new WHXBB_Debug("GetNInfo() Start");
        $limit = '';
        //取記錄總數
        $infoCount = $this->GetCount($condition);
        if ($infoCount == 0)
            return 0;

        if ($items != 0)
        {
           // 建立一個分頁器
            $this->pager = new Pager($infoCount, $items, $page);
            $startPos    = $this->pager->startPos;
            $limit = " limit ".$startPos.", ".$items;
        }
        $sql = "select  id, title, author from article where 1=1 $condition $orderBy $limit";

        $result = @mysql_query($sql, $this->_conn);
        if( !$result )
            return new WHXBB_Error("GetNInfo() Failed.($sql)", 1001);

        if(@mysql_num_rows($result) == 0)
            return 0;
        $i = 0;
        while ($arr = @mysql_fetch_array($result))
        {
            while(list($var, $key) = each($arr))
            {
                WHXBB::OperateString(&$arr[$var], 'out');
            }
            reset($arr);
            $info[$i]            = $arr;
            $i++;
        }
        @mysql_free_result($result);
        new WHXBB_Debug("GetNInfo() Completed");
        return $info;
    }
}
?>