“”

Table Library Table Library

table / stable

This contains a base class which you can use to make your extensions independant from any specific table. And it can be used to make multiple language support with a separate language overlay table or by a CSV file.

This version supports TYPO3

Older versions also support TYPO3

Composer support

composer req jambagecom/table

Last upload comment

Restore former sorting treatment.

Downloads by month

Download 0.13.2 Found an Issue? Code Insights Packagist.org
Author
Franz Holzinger
Company
jambage.com
Last update
15. Feb 2024
First upload
22. Oct 2005
Downloads
71,815
Category
Miscellaneous
Dependencies
  • TYPO3 (10.4.0 - 12.4.99)
  • div2007 (>= 1.15.0)

Installation

  1. Download ZIP file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the ZIP file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.
  1. Go to your folder where the root composer.json file is located
  2. Type: composer req jambagecom/table to get the latest version that runs on your TYPO3 version.
  1. Download T3X file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the T3X file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.

Other extensions by this user (52)

Version history

Version Upload comment Works with TYPO3 Download
0.13.2 / stable
February 15, 2024
Restore former sorting treatment.
10.4.0 - 12.4.99 Download
0.13.1 / stable
February 10, 2024
The sorting field is not required to be in the TCA.

10.4.0 - 12.4.99 Download
0.13.0 / stable
December 28, 2023
Improvements made by rector.
10.4.0 - 12.4.99 Download
0.12.1 / stable
May 16, 2023
supports TYPO3 12.4
10.4.0 - 12.4.99 Download
0.12.0 / stable
April 15, 2023
Deprecation: #92947 - TYPO3_MODE
10.4.0 - 12.3.99 Download
0.11.0 / stable
August 17, 2022
Breaking no.88143: Version-related database field “t3ver_id” removed.
Breaking no.87193: Deprecated functionality removed: database field “t3ver_label“ removed.

10.4.0 - 11.5.99 Download
0.10.4 / stable
June 15, 2022
support for TYPO3 backend

10.4.0 - 11.5.99 Download
0.10.3 / stable
March 08, 2022
bugfix php


10.4.0 - 11.5.99 Download
0.10.2 / stable
February 09, 2022
bugfix for PHP 8
10.4.0 - 11.5.99 Download
0.10.1 / stable
January 24, 2022
PHP 8
10.4.0 - 11.5.99 Download
0.10.0 / stable
January 10, 2022
support for PHP 8


10.4.0 - 11.5.99 Download
0.9.0 / stable
December 30, 2021
works with TYPO3 11.5

8.7.0 - 11.5.99 Download
0.8.0 / stable
February 18, 2021
works with TYPO3 10.4

8.7.0 - 10.4.99 Download
0.7.7 / stable
May 26, 2020
support for single quotes inside of variants

6.2.0 - 9.5.99 Download
0.7.6 / stable
May 25, 2020
bugfix for the last version
6.2.0 - 9.5.99 Download
0.7.5 / stable
May 20, 2020
Add backend support for the query generation methods.getWhere and getQueryConf.
6.2.0 - 9.5.99 Download
0.7.4 / stable
January 30, 2020
Some TYPO3 installations still need an autolog file.
6.2.0 - 9.5.99 Download
0.7.3 / stable
November 14, 2019
Support for sys_language_uid for TYPO3 9.4
6.2.0 - 9.5.99 Download
0.7.2 / stable
July 16, 2019
works under TYPO3 9.5 together with the extension typo3db_legacy
6.2.0 - 9.5.99 Download
0.7.1 / stable
September 20, 2018

Initialize all internal array variables.

6.2.0 - 8.99.99 Download
0.7.0 / stable
May 07, 2018

replace all t3lib_div calls by TYPO3\CMS\Core\Utility\GeneralUtility. TYPO3 6.1 is a minimum requirement now.

6.1.0 - 8.99.99 Download
0.6.2 / stable
April 14, 2017

bugfix in composer.json

4.5.0 - 8.99.99 Download
0.6.1 / stable
March 29, 2017

ready for TYPO3 8.x. Add a composer.json file.

4.5.0 - 8.99.99 Download
0.6.0 / stable
October 13, 2016

* new feature: add COLLATE in SQL functions if the new parameter $collateConf has been set
* remove class.tx_table_div.php

4.5.0 - 7.99.99 Download
0.5.1 / stable
May 10, 2016

Ready for PHP 7. pid_list = -1 is supported with tt_products 2.12.0. This enables the products of all pages.

4.5.0 - 7.9.99 Download
0.5.0 / stable
December 21, 2015

New feature: language fallback. Change in REGEXP for search where.

4.5.0 - 7.7.99 Download
0.4.1 / stable
July 24, 2015

works under TYPO3 7.4

4.5.0 - 7.4.99 Download
0.4.0 / stable
June 13, 2015

It works also under TYPO3 7.2.
The constants TABLE_EXTkey and PATH_BE_table have been removed.

4.5.0 - 7.2.99 Download
0.3.2 / stable
November 27, 2014

Compatible with PHP 5.5. This extension is also callable from the TYPO3 backend.

4.5.0 - 6.2.99 Download
0.3.1 / stable
August 12, 2014

No t3lib_div::loadTCA for TYPO3 > 6.0
* Modify bug trail function to tx_div2007_core::debugTrail

4.5.0 - 6.2.99 Download
0.3.0 / stable
November 21, 2013

runs with TYPO3 4.5, 4.7, 6.0 - 6.2

4.5.0 - 6.2.99 Download
0.2.7 / stable
November 19, 2012
Replace deprecated function t3lib_div::intInRange

Download
0.2.6 / stable
October 13, 2012
fix bug with closing bracked in order by functions

3.5.0 - 4.7.99 Download
0.2.5 / stable
October 10, 2012
add support of SQL functions to transformOrderby


Download
0.2.4 / stable
September 26, 2012
enhance searchWhere with regular expression
Download
0.2.3 / stable
July 05, 2012
new feature: use searchWhere from tslib_content but consider the language table - support TYPO3 4.7

Download
0.2.2 / stable
May 12, 2012
Check the required fields by the $TCA - Fix bug in exec_SELECTquery to add the language table.
Download
0.2.1 / stable
May 12, 2012
Check the required fields by the $TCA - Fix bug in exec_SELECTquery to add the language table.
Download
0.2.0 / stable
September 10, 2011
PHP 5.2 is the minimum requirement.
Do not set pidInList automatically. This can be set from outside of function getQueryConf.
Download
0.1.37 / stable
August 05, 2010
fix bug with marker replacement
Download
0.1.36 / stable
June 21, 2010
bugfix for tt_products: The amount of items could not be updated in the basket view.
Download
0.1.35 / stable
May 10, 2010
Fix bug in function transformSelect: Allow an alias in the select parameter.

Download
0.1.34 / stable
April 06, 2010
ready for PHP 5.3

Download
0.1.33 / stable
February 08, 2010
fix bug in method transformOrderby
Download
0.1.32 / stable
July 31, 2009
undo the last change with alias in transformWhere because all fields might need a translation table
Download
0.1.31 / stable
July 31, 2009
do not change an already present alias in transformWhere
Download
0.1.30 / stable
July 31, 2009
support of config type group for the translation reference key

Download
0.1.29 / stable
July 29, 2009
Support the replacement of the table name with the language table name even if it has already been provided in the where clause of the method call.
Download
0.1.28 / stable
July 10, 2009
support for queries with text fields which consist of round brackets ()
Download
0.1.27 / stable
June 26, 2009
consider required fields in method transformSelect
Download
0.1.26 / stable
May 21, 2009
Fix memory bugs in PHP 5.2.3. If you get SQL errors in tt_products with multiple languages, then upgrade to this version of the 'Table Library'.
Download
0.1.25 / stable
May 09, 2009
enhance method transformLanguage to allow a JOIN to the language table
Download
0.1.24 / stable
April 30, 2009
new method bFieldExists to check if a field exists for a table. The info is taken from $TCA.
Download
0.1.23 / stable
March 13, 2009
New method transformLanguage to add the table name and where clause for a language table.
Download
0.1.22 / stable
February 16, 2009
add parameter $aliasPostfix as a postfix to the table alias

Download
0.1.21 / stable
January 03, 2009
rename getAliasName to getAlias
Download
0.1.20 / stable
December 31, 2008
fix bug in transformOrderby: non TCA fields must be considered and the table name added
Download
0.1.19 / stable
September 17, 2008
Remove unneccessary loop from enableFields and add table as parameter to make it usable also for other tables, e.g. a mm table.
Download
0.1.18 / stable
September 06, 2008
Modify function use function setTCAFieldArray.
Download
0.1.17 / stable
June 21, 2008
remove debug output
Download
0.1.16 / stable
June 20, 2008
Fix bug with not working enable fields in class tx_table_db_access
Download
0.1.15 / stable
June 02, 2008
Fix in init function which is needed for tt_products 2.8.0.
Download
0.1.14 / beta
May 21, 2008
some bugs fixed.
Download
0.1.13 / beta
July 20, 2007
Fix bug with missing alias with translation tables and bug in PHP 5.2.1.
Download
0.1.12 / beta
March 17, 2007
New function substituteMarkerArray to substitute markers inside of table record fields.
Download
0.1.11 / beta
March 17, 2007
New function substituteMarkerArray to substitute markers inside of table record fields.
Download
0.1.10 / beta
March 14, 2007
enhance the exec_SELECT_queryArray that no table name needs to be provided.
Download
0.1.9 / beta
December 13, 2006
Small bug fixed.

Download
0.1.8 / beta
November 24, 2006
Use this only for tt_products 2.5.1 and later. Additive where clauses in tx_table_db_access. Some corrections for OUTER LEFT JOIN queries.
Download
0.1.7 / beta
September 27, 2006
Use this only for tt_products 2.5.1 and later. Additive where clauses in tx_table_db_access. Some corrections for OUTER LEFT JOIN queries.
Download
0.1.6 / beta
September 20, 2006
Use this only for tt_products 2.5.2 and later.
Additive where clauses in tx_table_db_access.
Download
0.1.5 / beta
June 28, 2006
new function addRequiredFieldArray.
Use this for tt_products 2.5.1
Download
0.1.4 / beta
June 14, 2006
use this for tt_products 2.4.11
Download
0.1.3 / beta
June 07, 2006
consider hidden field
Download
0.1.2 / beta
May 13, 2006
This version is needed for tt_products 2.4.10 .
Download
0.1.1 / beta
April 20, 2006
correction with 'ORDER BY'
Download
0.1.0 / beta
April 05, 2006
consider SQL ORDER BY and GROUP BY clauses.
Download
0.0.10 / alpha
March 31, 2006
Now it is possible to prepend the alias column name with a prefix.
Download
0.0.9 / alpha
March 22, 2006
new function setRequiredFieldArray for fields which must always get loaded in views
Download
0.0.8 / beta
January 31, 2006
Multiple languages are possible now. Use this extension to make your extension independant from any language. This can also be used to JOIN a table with an extension table in order to have more fields there.
Download
0.0.7 / alpha
December 08, 2005
Multiple languages are possible now. Use this extension to make your extension independant from any language. This can also be used to JOIN a table with an extension table in order to have more fields there.
Download
0.0.6 / alpha
November 29, 2005
Multiple languages are possible now.
Use this extension to make your extension independant from any language. This can also be used to JOIN a table with an extension table in order to have more fields there.
Download
0.0.5 / alpha
October 31, 2005
make setting of default fields possible
Download
0.0.4 / alpha
October 31, 2005
more queries possible now
Download
0.0.3 / alpha
October 28, 2005
This containts a base class which you can use to make your extensions independant from any specific table. And it can be used to make multiple language support with a separate language overlay table.
Download
0.0.2 / alpha
October 22, 2005
This containts a base class which you can use to make your extensions independant from any specific table. And it can be used to make multiple language support with a separate language overlay table.
Download