Reference documentation and code samples for the Cloud Spanner Client class ValueMapper.
Manage value mappings between Google Cloud PHP and Cloud Spanner
Namespace
Google \ Cloud \ Spanner
Methods
__construct
Parameter
Name
Description
returnInt64AsObject
bool
formatParamsForExecuteSql
Accepts an array of key/value pairs, where the key is a SQL parameter
name and the value is the value interpolated by the server, and returns
an array of parameters and inferred parameter types.
Parameters
Name
Description
parameters
array
The key/value parameters.
types
array
The types of values.
Returns
Type
Description
array
An associative array containing params and paramTypes.
encodeValuesAsSimpleType
Accepts a list of values and encodes the value into a format accepted by
the Spanner API.
Parameters
Name
Description
values
array
The list of values
allowMixedArrayType
bool
If true, array values may be of mixed type.
Defaults to* false.
Returns
Type
Description
array
The encoded values
decodeValues
Accepts a list of columns (with name and type) and a row from read or
executeSql and decodes each value to its corresponding PHP type.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[],[],null,["# Cloud Spanner Client - Class ValueMapper (1.104.0)\n\nVersion latestkeyboard_arrow_down\n\n- [1.104.0 (latest)](/php/docs/reference/cloud-spanner/latest/ValueMapper)\n- [1.103.0](/php/docs/reference/cloud-spanner/1.103.0/ValueMapper)\n- [1.102.0](/php/docs/reference/cloud-spanner/1.102.0/ValueMapper)\n- [1.101.0](/php/docs/reference/cloud-spanner/1.101.0/ValueMapper)\n- [1.100.0](/php/docs/reference/cloud-spanner/1.100.0/ValueMapper)\n- [1.98.0](/php/docs/reference/cloud-spanner/1.98.0/ValueMapper)\n- [1.97.0](/php/docs/reference/cloud-spanner/1.97.0/ValueMapper)\n- [1.96.0](/php/docs/reference/cloud-spanner/1.96.0/ValueMapper)\n- [1.95.0](/php/docs/reference/cloud-spanner/1.95.0/ValueMapper)\n- [1.94.0](/php/docs/reference/cloud-spanner/1.94.0/ValueMapper)\n- [1.93.1](/php/docs/reference/cloud-spanner/1.93.1/ValueMapper)\n- [1.92.1](/php/docs/reference/cloud-spanner/1.92.1/ValueMapper)\n- [1.91.0](/php/docs/reference/cloud-spanner/1.91.0/ValueMapper)\n- [1.90.0](/php/docs/reference/cloud-spanner/1.90.0/ValueMapper)\n- [1.89.0](/php/docs/reference/cloud-spanner/1.89.0/ValueMapper)\n- [1.88.0](/php/docs/reference/cloud-spanner/1.88.0/ValueMapper)\n- [1.87.0](/php/docs/reference/cloud-spanner/1.87.0/ValueMapper)\n- [1.86.0](/php/docs/reference/cloud-spanner/1.86.0/ValueMapper)\n- [1.85.0](/php/docs/reference/cloud-spanner/1.85.0/ValueMapper)\n- [1.84.0](/php/docs/reference/cloud-spanner/1.84.0/ValueMapper)\n- [1.83.0](/php/docs/reference/cloud-spanner/1.83.0/ValueMapper)\n- [1.82.0](/php/docs/reference/cloud-spanner/1.82.0/ValueMapper)\n- [1.81.0](/php/docs/reference/cloud-spanner/1.81.0/ValueMapper)\n- [1.80.0](/php/docs/reference/cloud-spanner/1.80.0/ValueMapper)\n- [1.79.0](/php/docs/reference/cloud-spanner/1.79.0/ValueMapper)\n- [1.78.0](/php/docs/reference/cloud-spanner/1.78.0/ValueMapper)\n- [1.77.0](/php/docs/reference/cloud-spanner/1.77.0/ValueMapper)\n- [1.76.1](/php/docs/reference/cloud-spanner/1.76.1/ValueMapper)\n- [1.68.0](/php/docs/reference/cloud-spanner/1.68.0/ValueMapper)\n- [1.67.0](/php/docs/reference/cloud-spanner/1.67.0/ValueMapper)\n- [1.66.0](/php/docs/reference/cloud-spanner/1.66.0/ValueMapper)\n- [1.65.0](/php/docs/reference/cloud-spanner/1.65.0/ValueMapper)\n- [1.64.0](/php/docs/reference/cloud-spanner/1.64.0/ValueMapper)\n- [1.63.2](/php/docs/reference/cloud-spanner/1.63.2/ValueMapper)\n- [1.62.1](/php/docs/reference/cloud-spanner/1.62.1/ValueMapper)\n- [1.61.0](/php/docs/reference/cloud-spanner/1.61.0/ValueMapper)\n- [1.60.0](/php/docs/reference/cloud-spanner/1.60.0/ValueMapper)\n- [1.59.0](/php/docs/reference/cloud-spanner/1.59.0/ValueMapper)\n- [1.58.4](/php/docs/reference/cloud-spanner/1.58.4/ValueMapper)\n- [1.57.0](/php/docs/reference/cloud-spanner/1.57.0/ValueMapper)\n- [1.56.0](/php/docs/reference/cloud-spanner/1.56.0/ValueMapper)\n- [1.55.0](/php/docs/reference/cloud-spanner/1.55.0/ValueMapper)\n- [1.54.2](/php/docs/reference/cloud-spanner/1.54.2/ValueMapper) \nReference documentation and code samples for the Cloud Spanner Client class ValueMapper.\n\nManage value mappings between Google Cloud PHP and Cloud Spanner\n\nNamespace\n---------\n\nGoogle \\\\ Cloud \\\\ Spanner\n\nMethods\n-------\n\n### __construct\n\n### formatParamsForExecuteSql\n\nAccepts an array of key/value pairs, where the key is a SQL parameter\nname and the value is the value interpolated by the server, and returns\nan array of parameters and inferred parameter types.\n\n### encodeValuesAsSimpleType\n\nAccepts a list of values and encodes the value into a format accepted by\nthe Spanner API.\n\n### decodeValues\n\nAccepts a list of columns (with name and type) and a row from read or\nexecuteSql and decodes each value to its corresponding PHP type.\n\nConstants\n---------\n\n### TYPE_BOOL\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::BOOL\n\n### TYPE_INT64\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::INT64\n\n### TYPE_FLOAT32\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::FLOAT32\n\n### TYPE_FLOAT64\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::FLOAT64\n\n### TYPE_TIMESTAMP\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::TIMESTAMP\n\n### TYPE_DATE\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::DATE\n\n### TYPE_STRING\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::STRING\n\n### TYPE_BYTES\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::BYTES\n\n### TYPE_ARRAY\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::PBARRAY\n\n### TYPE_STRUCT\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::STRUCT\n\n### TYPE_NUMERIC\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::NUMERIC\n\n### TYPE_JSON\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::JSON\n\n### TYPE_PROTO\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::PROTO\n\n### TYPE_INTERVAL\n\n Value: \\Google\\Cloud\\Spanner\\V1\\TypeCode::INTERVAL\n\n### TYPE_PG_NUMERIC\n\n Value: 'pgNumeric'\n\n### TYPE_PG_JSONB\n\n Value: 'pgJsonb'\n\n### TYPE_PG_OID\n\n Value: 'pgOid'"]]
