[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_MysqliResult
  33  {
  34  
  35      /**
  36       * mapping taken from http://forums.mysql.com/read.php?52,255868,255895#msg-255895
  37       */
  38      static public $mysqli_type = array(
  39          0 => "MYSQLI_TYPE_DECIMAL",
  40          1 => "MYSQLI_TYPE_TINYINT",
  41          2 => "MYSQLI_TYPE_SMALLINT",
  42          3 => "MYSQLI_TYPE_INTEGER",
  43          4 => "MYSQLI_TYPE_FLOAT",
  44          5 => "MYSQLI_TYPE_DOUBLE",
  45          7 => "MYSQLI_TYPE_TIMESTAMP",
  46          8 => "MYSQLI_TYPE_BIGINT",
  47          9 => "MYSQLI_TYPE_MEDIUMINT",
  48          10 => "MYSQLI_TYPE_DATE",
  49          11 => "MYSQLI_TYPE_TIME",
  50          12 => "MYSQLI_TYPE_DATETIME",
  51          13 => "MYSQLI_TYPE_YEAR",
  52          14 => "MYSQLI_TYPE_DATE",
  53          16 => "MYSQLI_TYPE_BIT",
  54          246 => "MYSQLI_TYPE_DECIMAL",
  55          247 => "MYSQLI_TYPE_ENUM",
  56          248 => "MYSQLI_TYPE_SET",
  57          249 => "MYSQLI_TYPE_TINYBLOB",
  58          250 => "MYSQLI_TYPE_MEDIUMBLOB",
  59          251 => "MYSQLI_TYPE_LONGBLOB",
  60          252 => "MYSQLI_TYPE_BLOB",
  61          253 => "MYSQLI_TYPE_VARCHAR",
  62          254 => "MYSQLI_TYPE_CHAR",
  63          255 => "MYSQLI_TYPE_GEOMETRY",
  64      );
  65  
  66      // Build an associative array for a type look up
  67      static $mysqli_to_php = array(
  68          "MYSQLI_TYPE_DECIMAL"     => 'float',
  69          "MYSQLI_TYPE_NEWDECIMAL"  => 'float',
  70          "MYSQLI_TYPE_BIT"         => 'integer',
  71          "MYSQLI_TYPE_TINYINT"     => 'integer',
  72          "MYSQLI_TYPE_SMALLINT"    => 'integer',
  73          "MYSQLI_TYPE_MEDIUMINT"   => 'integer',
  74          "MYSQLI_TYPE_BIGINT"      => 'integer',
  75          "MYSQLI_TYPE_INTEGER"     => 'integer',
  76          "MYSQLI_TYPE_FLOAT"       => 'float',
  77          "MYSQLI_TYPE_DOUBLE"      => 'float',
  78          "MYSQLI_TYPE_NULL"        => 'null',
  79          "MYSQLI_TYPE_TIMESTAMP"   => 'string',
  80          "MYSQLI_TYPE_INT24"       => 'integer',
  81          "MYSQLI_TYPE_DATE"        => 'string',
  82          "MYSQLI_TYPE_TIME"        => 'string',
  83          "MYSQLI_TYPE_DATETIME"    => 'string',
  84          "MYSQLI_TYPE_YEAR"        => 'string',
  85          "MYSQLI_TYPE_NEWDATE"     => 'string',
  86          "MYSQLI_TYPE_ENUM"        => 'string',
  87          "MYSQLI_TYPE_SET"         => 'string',
  88          "MYSQLI_TYPE_TINYBLOB"    => 'object',
  89          "MYSQLI_TYPE_MEDIUMBLOB"  => 'object',
  90          "MYSQLI_TYPE_LONGBLOB"    => 'object',
  91          "MYSQLI_TYPE_BLOB"        => 'object',
  92          "MYSQLI_TYPE_CHAR"        => 'string',
  93          "MYSQLI_TYPE_VARCHAR"     => 'string',
  94          "MYSQLI_TYPE_GEOMETRY"    => 'object',
  95          "MYSQLI_TYPE_BIT"         => 'integer',
  96      );
  97  
  98      /**
  99       * Parse resource into array
 100       *
 101       * @param resource $resource
 102       * @return array
 103       */
 104      public function parse($resource) {
 105  
 106          $result = array();
 107          $fieldcnt = mysqli_num_fields($resource);
 108  
 109  
 110          $fields_transform = array();
 111  
 112          for($i=0;$i<$fieldcnt;$i++) {
 113              $finfo = mysqli_fetch_field_direct($resource, $i);
 114  
 115              if(isset(self::$mysqli_type[$finfo->type])) {
 116                  $fields_transform[$finfo->name] = self::$mysqli_to_php[self::$mysqli_type[$finfo->type]];
 117              }
 118          }
 119  
 120          while($row = mysqli_fetch_assoc($resource)) {
 121              foreach($fields_transform as $fieldname => $fieldtype) {
 122                 settype($row[$fieldname], $fieldtype);
 123              }
 124              $result[] = $row;
 125          }
 126          return $result;
 127      }
 128  }