The Joomla Table class provides a framework which enables you to do CRUD operations and more on database tables. This class can be used for single record only and it doesn't support SQL operations on multiple records.
Many Joomla items include the concept of ordering. This is governed by a field called ordering in the database table.
This determines the max value of the ordering field among the records included by the optional where clause $where, and returns this max + 1.
This function reads the set of N records defined by the where clause $where, using ORDER BY `ordering` and then writes them back with the ordering fields nicely numbered from 1 to N.
move(integer $delta, string $where)
This function basically finds the record with the next greater (if $delta is positive) or lesser (if $delta is negative) value of the ordering field, and it then swaps the ordering values of the two records.
publish(mixed $pks = null, integer $state = 1, integer $userId)
This sets the publish field to $state for the set of records identified by the $pks array.
hit(mixed $pk = null)
A hits counter is usually used to count the number of times a webpage is visited. In Joomla you can record how many times a component is displayed on the frontend by using adding a hits column to the component's database table, and calling this function each time the component is displayed.
It returns the name of the table.
It returns the name of the primary key field.
It returns an array of the primary keys and values.
It returns an array of the names of the columns of the database table.
It checks if the primary key has a value set.
It checks if the table has a field of that $name.