lib/zend/Zend/Amf/Parse/Resource/MysqlResult.php

   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 license@zend.com so we can send you a copy immediately.
  14  *
  15  * @category   Zend
  16  * @package    Zend_Amf
  17  * @subpackage Parse
  18  * @copyright  Copyright (c) 2005-2015 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-2015 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 }