This class will convert mysql result resource to array suitable for passing to the external entities.

package Zend_Amf
subpackage Parse
copyright Copyright (c) 2005-2015 Zend Technologies USA Inc. (http://www.zend.com)
license New BSD License

 Methods

Parse resource into array

parse(resource $resource) : array

Parameters

$resource

resource

Returns

array

 Properties

 

$mysqli_to_php

$mysqli_to_php 

Default

array("MYSQLI_TYPE_DECIMAL" => 'float', "MYSQLI_TYPE_NEWDECIMAL" => 'float', "MYSQLI_TYPE_BIT" => 'integer', "MYSQLI_TYPE_TINYINT" => 'integer', "MYSQLI_TYPE_SMALLINT" => 'integer', "MYSQLI_TYPE_MEDIUMINT" => 'integer', "MYSQLI_TYPE_BIGINT" => 'integer', "MYSQLI_TYPE_INTEGER" => 'integer', "MYSQLI_TYPE_FLOAT" => 'float', "MYSQLI_TYPE_DOUBLE" => 'float', "MYSQLI_TYPE_NULL" => 'null', "MYSQLI_TYPE_TIMESTAMP" => 'string', "MYSQLI_TYPE_INT24" => 'integer', "MYSQLI_TYPE_DATE" => 'string', "MYSQLI_TYPE_TIME" => 'string', "MYSQLI_TYPE_DATETIME" => 'string', "MYSQLI_TYPE_YEAR" => 'string', "MYSQLI_TYPE_NEWDATE" => 'string', "MYSQLI_TYPE_ENUM" => 'string', "MYSQLI_TYPE_SET" => 'string', "MYSQLI_TYPE_TINYBLOB" => 'object', "MYSQLI_TYPE_MEDIUMBLOB" => 'object', "MYSQLI_TYPE_LONGBLOB" => 'object', "MYSQLI_TYPE_BLOB" => 'object', "MYSQLI_TYPE_CHAR" => 'string', "MYSQLI_TYPE_VARCHAR" => 'string', "MYSQLI_TYPE_GEOMETRY" => 'object', "MYSQLI_TYPE_BIT" => 'integer')
Static
 

mapping taken from http://forums.mysql.com/read.php?52,255868,255895#msg-255895

$mysqli_type 

Default

array(0 => "MYSQLI_TYPE_DECIMAL", 1 => "MYSQLI_TYPE_TINYINT", 2 => "MYSQLI_TYPE_SMALLINT", 3 => "MYSQLI_TYPE_INTEGER", 4 => "MYSQLI_TYPE_FLOAT", 5 => "MYSQLI_TYPE_DOUBLE", 7 => "MYSQLI_TYPE_TIMESTAMP", 8 => "MYSQLI_TYPE_BIGINT", 9 => "MYSQLI_TYPE_MEDIUMINT", 10 => "MYSQLI_TYPE_DATE", 11 => "MYSQLI_TYPE_TIME", 12 => "MYSQLI_TYPE_DATETIME", 13 => "MYSQLI_TYPE_YEAR", 14 => "MYSQLI_TYPE_DATE", 16 => "MYSQLI_TYPE_BIT", 246 => "MYSQLI_TYPE_DECIMAL", 247 => "MYSQLI_TYPE_ENUM", 248 => "MYSQLI_TYPE_SET", 249 => "MYSQLI_TYPE_TINYBLOB", 250 => "MYSQLI_TYPE_MEDIUMBLOB", 251 => "MYSQLI_TYPE_LONGBLOB", 252 => "MYSQLI_TYPE_BLOB", 253 => "MYSQLI_TYPE_VARCHAR", 254 => "MYSQLI_TYPE_CHAR", 255 => "MYSQLI_TYPE_GEOMETRY")
Static