Docs For Class MDB2_TableBrowser_InterfaceMultiTableBrowser

Class: MDB2_TableBrowser_InterfaceMultiTableBrowser

Class Overview

This interface defines the set of methods(operations) that can be performed by the multi-tableBrowser. This interface allows for the addtion of multiple tables to the tableBrowser. Tables are added one at a time.

Author(s):

Isaac Tewolde, <isaac at ticklespace.com>

Version:

Release: <package_version>

Copyright:

2007-2012 Isaac Tewolde

Methods

Inherited Variables

Inherited Methods

Class Details

[line 513]
This interface defines the set of methods(operations) that can be performed by the multi-tableBrowser. This interface allows for the addtion of multiple tables to the tableBrowser. Tables are added one at a time.

Author: Isaac Tewolde, <isaac@ticklespace.com>
Version: Release: <package_version>
Copyright: 2007-2012 Isaac Tewolde
Link: http://code.google.com/p/mdb2tablebrowser/source/browse/trunk/MDB2_TableBrowser/TableBrowser/Interfaces.php
License: LGPL v3.0

Method Detail

addTable [line 548]

void addTable(
string
$table1, string
$table1Column, string
$table2, string
$table2Column, [string
$joinType = 'JOIN'])

Adds a table to the multiTable browser. This method will actually add one or both tables. Internally they are created as single tableBrowsers and the columns $table1Column & $table2Column are added to the join expression.

Joins are added one at a time and are specified in the sql in the order they are created.

Access: public

Parameters:

string	`$table1`	—	The table1 name
string	`$table1Column`	—	The table1 column
string	`$table2`	—	The table2 name
string	`$table2Column`	—	The table2 column
string	`$joinType`	—	The join type (optional)

[ Top ]

getColumnValues [line 559]

array getColumnValues(
string
$columnName, [integer
$limit = DEFAULT_MAX_ROWS], [integer
$offset = 0])

Returns the different values a table column has. It also uses the currently defined filters to constrain the results returned.

Return: The column value
Access: public

Parameters:

string	`$columnName`	—	The column name
integer	`$limit`	—	Limit the number of results returned
integer	`$offset`	—	Offset

[ Top ]

getLastSQL [line 575]

string getLastSQL(
)

Returns the last sql statement

Access: public

[ Top ]

getRows [line 569]

an getRows(
[int
$limit = DEFAULT_MAX_ROWS], [int
$offset = 0])

Reterives the rows in the table. It uses the currently defined filters to constrain the results returned.

Return: MDB2_Result object
Access: public

Parameters:

int	`$limit`	—	Limit results
int	`$offset`	—	Offset

[ Top ]

setDistinct [line 523]

void setDistinct(
)

Sets browser to return only unique results

Access: public

[ Top ]

unsetDistinct [line 530]

void unsetDistinct(
)

Sets the browser to return duplicate results

Access: public

[ Top ]