yii mysql 查询 类型转换_Yii2 对数据库INT类型转换PHP类型

Yii2对于数据库的int类型转换到php类型时，会根据server 环境，决定是integer还是string。

如果是32位服务器， PHP_INT_SIZE=4, 64位服务器，PHP_INT_SIZE=8.

也就是说，如果DB的int类型超过了PHP的int最大值，则会转为string。

if ($column->type === 'bigint') {

return PHP_INT_SIZE === 8 && !$column->unsigned ? 'integer' : 'string';

} elseif ($column->type === 'integer') {

return PHP_INT_SIZE === 4 && $column->unsigned ? 'string' : 'integer';

}

/**

* Extracts the PHP type from abstract DB type.

* @param ColumnSchema $column the column schema information

* @return string PHP type name

*/

protected function getColumnPhpType($column)

{

static $typeMap = [

// abstract type => php type

self::TYPE_TINYINT => 'integer',

self::TYPE_SMALLINT => 'integer',

self::TYPE_INTEGER => 'integer',

self::TYPE_BIGINT => 'integer',

self::TYPE_BOOLEAN => 'boolean',

self::TYPE_FLOAT => 'double',

self::TYPE_DOUBLE => 'double',

self::TYPE_BINARY => 'resource',

self::TYPE_JSON => 'array',

];

if (isset($typeMap[$column->type])) {

if ($column->type === 'bigint') {

return PHP_INT_SIZE === 8 && !$column->unsigned ? 'integer' : 'string';

} elseif ($column->type === 'integer') {

return PHP_INT_SIZE === 4 && $column->unsigned ? 'string' : 'integer';

}

return $typeMap[$column->type];

}

return 'string';

}