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-2010 Zend Technologies USA Inc. (http://www.zend.com)

    19  * @license    http://framework.zend.com/license/new-bsd     New BSD License

    20  * @version    $Id: MysqlResult.php 20096 2010-01-06 02:05:09Z bkarwin $

    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 }