CODEWITHSUNDEEP
mysqlsqlphpmyadmintypo3
Black
Black

Reputation: 20322

Find out which database entry has changed

I have a field in my typo3 backend. If i add something to the field and click "save" then an entry in the database is created.

What i try is to find out which table is modified in my database, after i add a new item to the field and click save.

I found out that there is a tracking option in phpmyadmin, but im not sure if this function is what i am searching for.

enter image description here

My ui is in german, "Nachverfolgung" means "tracking".

How can i find this out?

Upvotes: 0

Views: 218

Answers (1)

Jost
Jost

Reputation: 5840

Open one of the records containing the field in question in the TYPO3 backend, and inspect the field using the developer tools of your browser.

In TYPO3 7.6 and upwards check the attribute data-formengine-input-name of the input field, in TYPO3 6.2 and downwards check the name attribute of the input field (or sometimes a hidden field besides it). Its value will look somehow like this:

data[tx_news_domain_model_news][6][author_email]

The value in the first pair of brackets is the table name, the value in the second pair is the records uid, and the value between the last pair is the field name. So in the example, the table name would be tx_news_domain_model_news and the field name is author_email.

Upvotes: 1

Related Questions