[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * Zend Framework
   4   *
   5   * LICENSE
   6   *
   7   * This source file is subject to the new BSD license that is bundled
   8   * with this package in the file LICENSE.txt.
   9   * It is also available through the world-wide-web at this URL:
  10   * http://framework.zend.com/license/new-bsd
  11   * If you did not receive a copy of the license and are unable to
  12   * obtain it through the world-wide-web, please send an email
  13   * to [email protected] so we can send you a copy immediately.
  14   *
  15   * @category   Zend
  16   * @package    Zend_Amf
  17   * @subpackage Parse
  18   * @copyright  Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
  19   * @license    http://framework.zend.com/license/new-bsd     New BSD License
  20   * @version    $Id$
  21   */
  22  
  23  /**
  24   * This class will convert mysql result resource to array suitable for passing
  25   * to the external entities.
  26   *
  27   * @package    Zend_Amf
  28   * @subpackage Parse
  29   * @copyright  Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
  30   * @license    http://framework.zend.com/license/new-bsd     New BSD License
  31   */
  32  class Zend_Amf_Parse_Resource_MysqlResult
  33  {
  34      /**
  35       * @var array List of Mysql types with PHP counterparts
  36       *
  37       * Key => Value is Mysql type (exact string) => PHP type
  38       */
  39      static public $fieldTypes = array(
  40          "int" => "int",
  41          "timestamp" => "int",
  42          "year" => "int",
  43          "real" => "float",
  44      );
  45      /**
  46       * Parse resource into array
  47       *
  48       * @param resource $resource
  49       * @return array
  50       */
  51      public function parse($resource) {
  52          $result = array();
  53          $fieldcnt = mysql_num_fields($resource);
  54          $fields_transform = array();
  55          for($i=0;$i<$fieldcnt;$i++) {
  56              $type = mysql_field_type($resource, $i);
  57              if(isset(self::$fieldTypes[$type])) {
  58                  $fields_transform[mysql_field_name($resource, $i)] = self::$fieldTypes[$type];
  59              }
  60          }
  61  
  62          while($row = mysql_fetch_object($resource)) {
  63              foreach($fields_transform as $fieldname => $fieldtype) {
  64                 settype($row->$fieldname, $fieldtype);
  65              }
  66              $result[] = $row;
  67          }
  68          return $result;
  69      }
  70  }