mysqlresult.php

一、修改产品详细页面的附件块 二、添加上浏览历史模块 三、在后台加入自定义首页、自定义页头、自定义页脚内容功能 四、在后台修改网站全局CSS样式文件功能 五、在后台修改每个模块的模板内容功能

<?php

/**
 * Swift Mailer MySQL Resultset Iterator
 * Please read the LICENSE file
 * @author Chris Corbyn <[e-mail]>
 * @package Swift
 * @license GNU Lesser General Public License
 */

require_once dirname(__FILE__) . "/../ClassLoader.php";
Swift_ClassLoader::load("Swift_Iterator");

/**
 * Swift Mailer MySQL Resultset Iterator.
 * Iterates over MySQL Resultset from mysql_query().
 * @package Swift
 * @author Chris Corbyn <[e-mail]>
 */
class Swift_Iterator_MySQLResult implements Swift_Iterator
{
  /**
   * The MySQL resource.
   * @var resource
   */
  protected $resultSet;
  /**
   * The current row (array) in the resultset.
   * @var array
   */
  protected $currentRow = array(null, null);
  /**
   * The current array position.
   * @var int
   */
  protected $pos = -1;
  /**
   * The total number of rows in the resultset.
   * @var int
   */
  protected $numRows = 0;
  
  /**
   * Ctor.
   * @param resource The resultset iterate over.
   */
  public function __construct($rs)
  {
    $this->resultSet = $rs;
    $this->numRows = mysql_num_rows($rs);
  }
  /**
   * Get the resultset.
   * @return resource
   */
  public function getResultSet()
  {
    return $this->resultSet;
  }
  /**
   * Returns true if there is a value after the current one.
   * @return boolean
   */
  public function hasNext()
  {
    return (($this->pos + 1) < $this->numRows);
  }
  /**
   * Moves to the next array element if possible.
   * @return boolean
   */
  public function next()
  {
    if ($this->hasNext())
    {
      $this->currentRow = mysql_fetch_array($this->resultSet);
      $this->pos++;
      return true;
    }
    
    return false;
  }
  /**
   * Goes directly to the given element in the array if possible.
   * @param int Numeric position
   * @return boolean
   */
  public function seekTo($pos)
  {
    if ($pos >= 0 && $pos < $this->numRows)
    {
      mysql_data_seek($this->resultSet, $pos);
      $this->currentRow = mysql_fetch_array($this->resultSet);
      mysql_data_seek($this->resultSet, $pos);
      $this->pos = $pos;
      return true;
    }
    
    return false;
  }
  /**
   * Returns the value at the current position, or NULL otherwise.
   * @return mixed.
   */
  public function getValue()
  {
    $row = $this->currentRow;
    if ($row[0] !== null)
      return new Swift_Address($row[0], isset($row[1]) ? $row[1] : null);
    else
      return null;
  }
  /**
   * Gets the current numeric position within the array.
   * @return int
   */
  public function getPosition()
  {
    return $this->pos;
  }
}