Solar_Sql_Table
Overview

Next Page
Constants

Solar_Sql_Table

Class for representing an SQL table.

Catalog

This class is part of the Solar_Sql package.

Inheritance:

Constants

None.

Public Properties

The Solar_Sql_Table class has no public properties; try the list of all properties.

Public Methods

These are all the public methods in the Solar_Sql_Table class.

You can also view the list of all public, protected, and private methods.

[[Solar_Sql_Table::__construct() | __construct()]]
Constructor.
[[Solar_Sql_Table::__get() | __get()]]
Allows reading of protected properties.
[[Solar_Sql_Table::apiVersion() | apiVersion()]]
Reports the API version for this class.
[[Solar_Sql_Table::delete() | delete()]]
Deletes rows in the table based on a WHERE clause.
[[Solar_Sql_Table::dump() | dump()]]
Convenience method for getting a dump the whole object, or one of its properties, or an external variable.
[[Solar_Sql_Table::fetch() | fetch()]]
Fetches one row from the table by its primary key ID.
[[Solar_Sql_Table::fetchAll() | fetchAll()]]
Fetches all rows by arbitrary criteria.
[[Solar_Sql_Table::fetchNew() | fetchNew()]]
Returns a new row of column keys and default values.
[[Solar_Sql_Table::fetchRow() | fetchRow()]]
Fetches one row by arbitrary criteria.
[[Solar_Sql_Table::fetchWhere() | fetchWhere()]]
Fetches one row by arbitrary criteria.
[[Solar_Sql_Table::getColName() | getColName()]]
Returns a fully-qualified column name ("tablename.colname").
[[Solar_Sql_Table::increment() | increment()]]
Increments and returns the sequence value for a column.
[[Solar_Sql_Table::insert() | insert()]]
Validates and inserts data into the table.
[[Solar_Sql_Table::locale() | locale()]]
Looks up locale strings based on a key.
[[Solar_Sql_Table::save() | save()]]
Inserts or updates a single row based on its ID.
[[Solar_Sql_Table::select() | select()]]
Convenience method to select rows from this table.
[[Solar_Sql_Table::setFetchAllClass() | setFetchAllClass()]]
Sets the class returned by fetchAll() calls.
[[Solar_Sql_Table::setFetchRowClass() | setFetchRowClass()]]
Sets the class returned by fetchRow() calls.
[[Solar_Sql_Table::setPaging() | setPaging()]]
Sets the number of rows per page.
[[Solar_Sql_Table::update() | update()]]
Validates and updates data in the table based on a WHERE clause.