Docs For Class MDB2_TableBrowser_InterfaceSingleTableBrowser

deleteRow [line 474]

int deleteRow(
mixed
$rowID)

Deletes a single row with the specified rowId.

Return: The number of affected rows (0 or 1)
Access: public

Parameters:

mixed $rowID — The primary key value

[ Top ]

getColumnValues [line 427]

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 497]

string getLastSQL(
)

Returns the last sql statement

Access: public

[ Top ]

getRow [line 457]

array getRow(
mixed
$rowID)

Returns a single row in the table with the primary key value specified.

This method ignores the currently defined filters.

Return: The row data
Access: public

Parameters:

mixed $rowID — The primary_key value

[ Top ]

getRows [line 448]

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 ]

getRowsSQL [line 438]

string getRowsSQL(
)

Identical to calling getRows, but instead of excecuting the query it returns the sql that would have been generated from a getRows call.

This method is useful for debugging and building complex sql constructs that involve sub-selects.

Access: public

[ Top ]

insertRow [line 482]

int insertRow(
array
$rowData)

Inserts a row

Return: The number of affected rows (0 or 1)
Access: public

Parameters:

array $rowData — The new row data

[ Top ]

insertRows [line 491]

int insertRows(
array
$columns, array
$rowData)

Inserts multiple rows to the table

Return: The number of inserted rows
Access: public

Parameters:

array	`$columns`	—	The list of colums in the data
array	`$rowData`	—	The array containing the row data

[ Top ]

setDistinct [line 409]

void setDistinct(
)

Sets browser to return only unique results

Access: public

[ Top ]

unsetDistinct [line 416]

void unsetDistinct(
)

Sets the browser to return duplicate results

Access: public

[ Top ]

updateRow [line 466]

int updateRow(
mixed
$rowID, array
$rowData)

Updates a row

Return: The number of affected rows (0 or 1)
Access: public

Parameters:

mixed	`$rowID`	—	The primary key value
array	`$rowData`	—	The new row values

[ Top ]

Class: MDB2_TableBrowser_InterfaceSingleTableBrowser

Class Overview

Author(s):

Version:

Copyright:

Methods

Inherited Variables

Inherited Methods

Class Details

Method Detail

deleteRow [line 474]

Parameters:

getColumnValues [line 427]

Parameters:

getLastSQL [line 497]

getRow [line 457]

Parameters:

getRows [line 448]

Parameters:

getRowsSQL [line 438]

insertRow [line 482]

Parameters:

insertRows [line 491]

Parameters:

setDistinct [line 409]

unsetDistinct [line 416]

updateRow [line 466]

Parameters: