WooYun.org

eat.gd.sina.com.cn/include.tar.gz

<?php
/**
 * 新浪广东美食频道通用餐厅库类.
 *
 * LICENSE
 *
 * @category   eat.gd.sina.com.cn
 * @package    Eat_Core_Library
 * @copyright  Copyright (c) 2009 ,  LiXiang
 * @license    New BSD License
 * @version    $Id: Data.php 2009-06-16  $
 */
//require_once $_SERVER['DOCUMENT_ROOT']."/include/library/Common/Mysql.php";
require_once realpath(dirname(__FILE__))."/../Common/Mysql.php";
class Rstrt_Data
{
    private $_db;
    private $_host = "10.71.2.104";
    private $_dbname = "web_eat";
    private $_dbuser = "web_eat";
    private $_dbpasswd = "giggle4sina";
    private $_table = "web_rstrt";
    private $_primaryKey = "RstrtID";
    private $_where = " 1 ";
    private $_fields = "*";
    private $_groupby = "";
    private $_orderby = "";
    private $_limit = "";
    
    private $_query = "";
    /**
     * 构造函数,初始化数据库连接.
     */
    function Rstrt_Data($db="web_eat")
    {
        if($db!="")$this->_dbname = $db;
        $this->_db = new Common_Mysql($this->_host,$this->_dbname,$this->_dbuser,$this->_dbpasswd,0);
        $this->_db->connect();
    }
    //=============以下函数设置操作参数=================
    /**
     * 设置table和查询的内容.
     * @param string $table
     * @param string $fields
     */
    public function from($table,$fields)
    {
        $this->_table = $table;
        $this->_fields = $fields;
    }
    /**
     * 设置条件
     * @param string $where
     */
    public function where($where)
    {
        $this->_where = $where;
    }
    /**
     * 设置groupby
     * @param string $groupby
     */
    public function group($groupby)
    {
        $this->_groupby = $groupby;
    }
    /**
     * 设置orderby
     * @param string $orderby
     */
    public function order($orderby)
    {
        $this->_orderby = $orderby;
    }
    /**
     * 设置limit
     * @param string|int $limit
     */
    public function limit($limit)
    {
        $this->_limit = $limit;
    }
    /**
     * 设置limit
     * @param int $limit
     * @param int $offset
     */
    public function limitPage($curPage,$offset=10)
    {
        $this->_limit = ($curPage-1)*$offset.",".$offset;
    }
    //====================================
    public function resetParams()
    {
        $this->_where = "";
        $this->_table = "";
        $this->_fields = "";
        $this->_groupby = "";
        $this->_orderby = "";
        $this->_limit = "";
        $this->_query = "";
    }
    /**
     * 查询表信息.
     * @param string $where
     * @param string $fields
     * @param string $orderby
     * @param int|string $limit
     * @return array 
     */
    public function select()
    {
        $result = array();
        //$this->_where = mysql_escape_string($this->_where);
        if($this->_where == "")$this->_where = "1";
        if($this->_fields == "")$this->_fields = "*";
        $query = " SELECT ".$this->_fields." FROM ".$this->_table." WHERE ".$this->_where." ";
        if($this->_groupby != "")$query .= " GROUP BY ".$this->_groupby;
        if($this->_orderby != "")$query .= " ORDER BY ".$this->_orderby;
        if($this->_limit != "")$query .= " LIMIT ".$this->_limit;
        $this->_query = $query;
        $this->_db->query($query);
        $i = 0;
        while($row=$this->_db->fetch_row()){
            $result[$i] = $row;
            $i++;
        }
        return $result;
        
    }//end function get
    /**
     * 查询餐厅库中符合条件的记录总数.
     * @param string $where
     * @return int
     */
    public function selectCount()
    {
        $result = 0;
        $query = "SELECT COUNT(*) as total FROM ".$this->_table." where ".$this->_where.";";
        $this->_query = $query;
        $this->_db->query($query);
        $row = $this->_db->fetch_row();
        $result = $row['total'];
        return $result;
        
    }
    /**
     * 输出query语句.
     * @return string
     */
    public function _toString()
    {
        return $this->_query;
    }
}//end class