Pike v8.1 release 6

Method Mysql.SqlTable()->get()


Method get

mapping(string:mixed) get(mixed id, void|array(string) fields)

Description

Returns the record matched by a primary key value, or zero if there is no such record.

Parameter id

The value for the primary key.

If the table has a multicolumn primary key then id must be an array which has the values for the primary key columns in the same order as pk_cols. Otherwise id is taken directly as the value of the single primary key column.

Parameter fields

The fields to retrieve. All fields are retrieved if it's zero or left out.

For columns, the result mappings always have corresponding entries. Other fields, i.e. properties, only occur in the result mappings when they match fields in the prop_col column.

A 0 (zero) entry can be used in fields to return all properties without filtering.

See also

select, select1, get_multi