Formhandler › Finisher\DifferentDB

Finisher\DifferentDB

Saves the submitted values into a specified DB table using a database other than the TYPO3 database.

This component requires the extension adodb to be installed.

Version added

1.0.0

TypoScript path

plugin.Tx_Formhandler.settings.finishers.x copy to clipboard

Properties

.host

Host of the databse

Data type

String | cObj

Version added

1.0.0

.port

Port to use

Data type

String | cObj

Version added

1.0.0

.db

Name of the database

Data type

String | cObj

Version added

1.0.0

.driver

Driver to use

Data type

String | cObj

Version added

1.0.0

Example code

driver = oci8

.username

Username for the DB

Data type

String | cObj

Version added

1.0.0

.password

Password for the DB user

Data type

String | cObj

Version added

1.0.0

.table

The name of the table to store the data into.

Data type

String | cObj

Version added

1.0.0

.key

The field with the primary key.

Data type

String | cObj

Default value

uid

Version added

1.0.0

Example code

key = uid

.updateInsteadOfInsert

Does not store the values as a new row in the table, but tries to update an existing record. Needs a uid set in GET/POST parameters.
Add a hidden field named in accordance with the value entered in “key” to your form. Don't forget to add the formValuesPrefix!

Data type

Integer (0,1,2)

Version added

1.0.0

.fields

Have a look at the config section of Finisher\DB

Data type

Boolean | cObj

Version added

1.0.0