Joomla! API

Object constructor to set table and key fields. In most cases this will be overridden by child classes to explicitly set the table and key fields for a particular database table.

__construct(string $table, mixed $key, \JDatabaseDriver $db)

inherited

since	1.7.0

Arguments

$table: stringName of the table to model.
$key: mixedName of the primary key field in the table or array of field names that compose the primary key.
$db: \JDatabaseDriver\JDatabaseDriver object.

Method to compute the default name of the asset.

_getAssetName() : string

inherited

The default name is in the form table_name.id where id is the value of the primary key of the table.

since	1.7.0

Response

string

Method to get the parent asset under which to register this one.

_getAssetParentId(\Joomla\CMS\Table\Table $table = null, integer $id = null) : integer

inherited

By default, all assets are registered to the ROOT node with ID, which will default to 1 if none exists. An extended class can define a table and ID to lookup. If the asset does not exist it will be created.

since	1.7.0

Arguments

$table: \Joomla\CMS\Table\TableA Table object for the asset parent.
$id: integerId to look up

Response

integer

Method to return the title to use for the asset table.

_getAssetTitle() : string

inherited

In tracking the assets a title is kept for each asset so that there is some context available in a unified access manager. Usually this would just return $this->title or $this->name or whatever is being used for the primary name of the row. If this method is not overridden, the asset name is used.

since	1.7.0

Response

stringThe string to use as the title in the asset table.

Method to lock the database table for writing.

_lock() : boolean

inherited

since	1.7.0
throws	`\RuntimeException`

Response

booleanTrue on success.

Method to unlock the database table for writing.

_unlock() : boolean

inherited

since	1.7.0

Response

booleanTrue on success.

Add a filesystem path where Table should search for table class files.

addIncludePath(array|string $path = null) : array

inherited static

since	1.7.0

Arguments

$path: array|stringA filesystem path or array of filesystem paths to add.

Response

arrayAn array of filesystem paths to find Table classes in.

Method to append the primary keys for this table to a query.

appendPrimaryKeys(\JDatabaseQuery $query, mixed $pk = null) : void

inherited

since	3.1.4

Arguments

$query: \JDatabaseQueryA query object to append.
$pk: mixedOptional primary key parameter.

Implement \JObservableInterface: Adds an observer to this instance.

attachObserver(\JObserverInterface|\JTableObserver $observer) : void

inherited

This method will be called fron the constructor of classes implementing \JObserverInterface which is instanciated by the constructor of $this with \JObserverMapper::attachAllObservers($this)

since	3.1.2

Arguments

$observer: \JObserverInterface|\JTableObserverThe observer object

Method to bind an associative array or object to the Table instance.This method only binds properties that are publicly accessible and optionally takes an array of properties to ignore when binding.

bind(array|object $src, array|string $ignore = array()) : boolean

inherited

since	1.7.0
throws	`\InvalidArgumentException`

Arguments

$src: array|objectAn associative array or object to bind to the Table instance.
$ignore: array|stringAn optional array or space separated list of properties to ignore while binding.

Response

booleanTrue on success.

Method to perform sanity checks on the Table instance properties to ensure they are safe to store in the database.

check() : boolean

inherited

Child classes should override this method to make sure the data they are storing in the database is safe and as expected before storage.

since	1.7.0

Response

booleanTrue if the instance is sane and able to be stored in the database.

Method to check a row in if the necessary properties/fields exist.

checkIn(mixed $pk = null) : boolean

inherited

Checking a row in will allow other users the ability to edit the row.

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$pk: mixedAn optional primary key value to check out. If not set the instance property value is used.

Response

booleanTrue on success.

Method to check a row out if the necessary properties/fields exist.

checkOut(integer $userId, mixed $pk = null) : boolean

inherited

To prevent race conditions while editing rows in a database, a row can be checked out if the fields 'checked_out' and 'checked_out_time' are available. While a row is checked out, any attempt to store the row by a user other than the one who checked the row out should be held until the row is checked in again.

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$userId: integerThe Id of the user checking out the row.
$pk: mixedAn optional primary key value to check out. If not set the instance property value is used.

Response

booleanTrue on success.

Method to delete a row from the database table by primary key value.

delete(mixed $pk = null) : boolean

inherited

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$pk: mixedAn optional primary key value to delete. If not set the instance property value is used.

Response

booleanTrue on success.

Method to expand the field mapping

fieldmapExpand(boolean $assoc = true) : mixed

since	3.1

Arguments

$assoc: booleanTrue to return an associative array.

Response

mixedArray or object with field mappings. Defaults to object.

Method to return the real name of a "special" column such as ordering, hits, published etc etc. In this way you are free to follow your db naming convention and use the built in \Joomla functions.

getColumnAlias(string $column) : string

inherited

since	3.4

Arguments

$column: stringName of the "special" column (ie ordering, hits)

Response

stringThe string that identify the special

Method to get the Table object for the content type from the table object.

getContentTable() : mixed

since	3.2
throws	`\RuntimeException`

Response

mixedTable object on success, otherwise false.

Method to get the \JDatabaseDriver object.

getDbo() : \JDatabaseDriver

inherited

since	1.7.0

Response

\JDatabaseDriverThe internal database driver object.

Get the columns from database table.

getFields(boolean $reload = false) : mixed

inherited

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$reload: booleanflag to reload cache

Response

mixedAn array of the field names, or false if an error occurs.

Static method to get an instance of a Table class if it can be found in the table include paths.

getInstance(string $type, string $prefix = 'JTable', array $config = array()) : \Joomla\CMS\Table\Table|boolean

inherited static

To add include paths for searching for Table classes see Table::addIncludePath().

since	1.7.0

Arguments

$type: stringThe type (name) of the Table class to get an instance of.
$prefix: stringAn optional prefix for the table class name.
$config: arrayAn optional array of configuration values for the Table object.

Response

\Joomla\CMS\Table\Table|booleanA Table object if found or boolean false on failure.

Method to get the primary key field name for the table.

getKeyName(boolean $multiple = false) : mixed

inherited

since	1.7.0

Arguments

$multiple: booleanTrue to return all primary keys (as an array) or false to return just the first one (as a string).

Response

mixedArray of primary key field names or string containing the first primary key field.

Method to get the next ordering value for a group of rows defined by an SQL WHERE clause.

getNextOrder(string $where = '') : integer

inherited

This is useful for placing a new item last in a group of items in the table.

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$where: stringWHERE clause to use for selecting the MAX(ordering) for the table.

Response

integerThe next ordering value.

Gets the instance of the observer of class $observerClass

getObserverOfClass(string $observerClass) : \JTableObserver|null

inherited

since	3.1.2

Arguments

$observerClass: stringThe observer class-name to return the object of

Response

\JTableObserver|null

Get the primary key values for this table using passed in values as a default.

getPrimaryKey(array $keys = array()) : array

inherited

since	3.1.4

Arguments

$keys: arrayOptional primary key values to use.

Response

arrayAn array of primary key names and values.

Method to get the rules for the record.

getRules() : \JAccessRules

inherited

since	1.7.0

Response

\JAccessRulesobject

Method to get the database table name for the class.

getTableName() : string

inherited

since	1.7.0

Response

stringThe name of the database table being modeled.

Method to get the id given the type alias

getTypeId(string $typeAlias) : mixed

since	3.2

Arguments

$typeAlias: stringContent type alias (for example, 'com_content.article').

Response

mixedtype_id for this alias if successful, otherwise null.

Check if the record has a property (applying a column alias if it exists)

hasField(string $key) : boolean

inherited

since	3.9.11

Arguments

$key: stringkey to be checked

Response

boolean

Validate that the primary key has been set.

hasPrimaryKey() : boolean

inherited

since	3.1.4

Response

booleanTrue if the primary key(s) have been set.

Method to increment the hits for a row if the necessary property/field exists.

hit(mixed $pk = null) : boolean

inherited

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$pk: mixedAn optional primary key value to increment. If not set the instance property value is used.

Response

booleanTrue on success.

Method to determine if a row is checked out and therefore uneditable by a user.

isCheckedOut(integer $with, integer $against = null) : boolean

inherited

If the row is checked out by the same user, then it is considered not checked out -- as the user can still edit it.

since	1.7.0

Arguments

$with: integerThe user ID to preform the match with, if an item is checked out by this user the function will return false.
$against: integerThe user ID to perform the match against when the function is used as a static function.

Response

booleanTrue if checked out.

Method to load a row from the database by primary key and bind the fields to the Table instance properties.

load(mixed $keys = null, boolean $reset = true) : boolean

inherited

since

1.7.0

throws

\InvalidArgumentException

\RuntimeException

\UnexpectedValueException

Arguments

$keys: mixedAn optional primary key value to load the row by, or an array of fields to match. If not set the instance property value is used.
$reset: booleanTrue to reset the default values before loading the new row.

Response

booleanTrue if successful. False if row not found.

Method to move a row in the ordering sequence of a group of rows defined by an SQL WHERE clause.

move(integer $delta, string $where = '') : boolean

inherited

Negative numbers move the row up in the sequence and positive numbers move it down.

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$delta: integerThe direction and magnitude to move the row in the ordering sequence.
$where: stringWHERE clause to use for limiting the selection of rows to compact the ordering values.

Response

booleanTrue on success.

Method to set the publishing state for a row or list of rows in the database table.

publish(mixed $pks = null, integer $state = 1, integer $userId) : boolean

inherited

The method respects checked out rows by other users and will attempt to checkin rows that it can after adjustments are made.

since	1.7.0

Arguments

$pks: mixedAn optional array of primary key values to update. If not set the instance property value is used.
$state: integerThe publishing state. eg. [0 = unpublished, 1 = published]
$userId: integerThe user ID of the user performing the operation.

Response

booleanTrue on success; false if $pks is empty.

Method to compact the ordering values of rows in a group of rows defined by an SQL WHERE clause.

reorder(string $where = '') : mixed

inherited

since	1.7.0
throws	`\UnexpectedValueException`

Arguments

$where: stringWHERE clause to use for limiting the selection of rows to compact the ordering values.

Response

mixedBoolean True on success.

Method to reset class properties to the defaults set in the class definition. It will ignore the primary key as well as any private class properties (except $_errors).

reset() : void

inherited

since	1.7.0

Method to provide a shortcut to binding, checking and storing a Table instance to the database table.

save(array|object $src, string $orderingFilter = '', array|string $ignore = '') : boolean

inherited

The method will check a row in once the data has been stored and if an ordering filter is present will attempt to reorder the table rows based on the filter. The ordering filter is an instance property name. The rows that will be reordered are those whose value matches the Table instance for the property specified.

since	1.7.0

Arguments

$src: array|objectAn associative array or object to bind to the Table instance.
$orderingFilter: stringFilter for the order updating
$ignore: array|stringAn optional array or space separated list of properties to ignore while binding.

Response

booleanTrue on success.

Method to register a column alias for a "special" column.

setColumnAlias(string $column, string $columnAlias) : void

inherited

since	3.4

Arguments

$column: stringThe "special" column (ie ordering)
$columnAlias: stringThe real column name (ie foo_ordering)

Method to set the \JDatabaseDriver object.

setDbo(\JDatabaseDriver $db) : boolean

inherited

since	1.7.0

Arguments

$db: \JDatabaseDriverA \JDatabaseDriver object to be used by the table object.

Response

booleanTrue on success.

Method to set rules for the record.

setRules(mixed $input) : void

inherited

since	1.7.0

Arguments

$input: mixedA \JAccessRules object, JSON string, or array.

Method to store a row in the database from the Table instance properties.

store(boolean $updateNulls = false) : boolean

inherited

If a primary key value is set the row with that primary key value will be updated with the instance property values. If no primary key value is set a new row will be inserted into the database with the properties from the Table instance.

since	1.7.0

Arguments

$updateNulls: booleanTrue to update fields even if they are null.

Response

booleanTrue on success.

Include paths for searching for Table classes.

inherited static

since	3.0.0

Type(s)

array

Table fields cache

inherited static

since	3.10.4

Type(s)

array

Name of the database table to model.

inherited

since	1.7.0

Type(s)

string

Name of the primary key field in the table.

inherited

since	1.7.0

Type(s)

string

Name of the primary key fields in the table.

inherited

since	3.0.1

Type(s)

array

\JDatabaseDriver object.

inherited

since	1.7.0

Type(s)

\JDatabaseDriver

Should rows be tracked as ACL assets?

inherited

since	1.7.0

Type(s)

boolean

The rules associated with this record.

inherited

since	1.7.0

Type(s)

\JAccessRules

Indicator that the tables have been locked.

inherited

since	1.7.0

Type(s)

boolean

Indicates that the primary keys autoincrement.

inherited

since	3.1.4

Type(s)

boolean

Generic observers for this Table (Used e.g. for tags Processing)

inherited

since	3.1.2

Type(s)

\JObserverUpdater

Array with alias for "special" columns such as ordering, hits etc etc

inherited

since	3.4.0

Type(s)

array

An array of key names to be json encoded in the bind function

inherited

since	3.3

Type(s)

array

Indicates that columns fully support the NULL value in the database

inherited

since	3.10.0

Type(s)

boolean

ContentType

Methods

__construct

Arguments

_getAssetName

Response

_getAssetParentId

Arguments

Response

_getAssetTitle

Response

_lock

Response

_unlock

Response

addIncludePath

Arguments

Response

appendPrimaryKeys

Arguments

attachObserver

Arguments

bind

Arguments

Response

check

Response

checkIn

Arguments

Response

checkOut

Arguments

Response

delete

Arguments

Response

fieldmapExpand

Arguments

Response

getColumnAlias

Arguments

Response

getContentTable

Response

getDbo

Response

getFields

Arguments

Response

getInstance

Arguments

Response

getKeyName

Arguments

Response

getNextOrder

Arguments

Response

getObserverOfClass

Arguments

Response

getPrimaryKey

Arguments

Response

getRules

Response

getTableName

Response

getTypeId

Arguments

Response

hasField

Arguments

Response

hasPrimaryKey

Response

hit

Arguments

Response

isCheckedOut