Structures_DataGrid_DataSource_DBTable

Structures_DataGrid_DataSource_DBTable -- PEAR::DB_Table Data Source Driver

Description

This class is a data source driver for the PEAR::DB_Table object

Options

This driver accepts the following options:

Table 55-1. Options for this driver

OptionTypeDescriptionDefault Value
fieldsarrayWhich data fields to fetch from the datasource. An empty array means: all fields. Form: array(field1, field2, ...)array()
generate_columnsboolGenerate Structures_DataGrid_Column objects with labels. See the 'labels' option.false
labelsarrayData field to column label mapping. Only used when 'generate_columns' is true. Form: array(field => label, ...)array()
paramsarrayPlaceholder parameters for prepare/executearray()
viewstringThe view from $sql array in your DB_Table object. This option is required. 
wherestringA where clause for the SQL query.null

General notes

If you use aliases in the select part of your view, the count() method from DB_Table and, therefore, $datagrid->getRecordCount() might return a wrong result. To avoid this, DB_Table uses a special query for counting if it is given via a view that needs to be named as '__count_' followed by the name of the view that this counting view belongs to. (For example: if you have a view named 'all', the counting view needs to be named as '__count_all'.)