[TYPO3-dev] Typoscript MySQL

Ralf-Rene Schröder ralf.rene at online.de
Fri Oct 9 13:40:25 CEST 2015


Am 09.10.2015 um 13:18 schrieb Marvin Arets Dev:
> Is there in typoscript any possibility to get any MySQL data? I want to
> show all records from a SQL table on my typo3 site.
sure...
https://docs.typo3.org/typo3cms/TyposcriptReference/latest/ContentObjects/Content/Index.html

> Then for each record I want to show a HTML code with that record in it.
renderObj is that you are looking for

lib.XXX = CONTENT
lib.XXX {
  wrap = <div class="list"> | </div>
  table = yourtable
  select {
    pidInList = yourpagewithrecords
    ...
  }
  renderObj = TEXT
  renderObj {
    wrap = <div class="item"> | </div>
    field = yourfield
    ...
  }
}

another possibility is RECORDS
https://docs.typo3.org/typo3cms/TyposcriptReference/latest/ContentObjects/Records/Index.html

-- 
image[FORMAT] - Ralf-René Schröder
http://www.image-format.eu ... Wir geben Ihrem Image das richtige Format



More information about the TYPO3-dev mailing list