Txtdb-sample5

Package version/links

pmwiki-2.3.13
Skin - notebook-nt
txtdb-2.2.1-alpha-2-20230215

Txtdb - Sql query using txtdb directives

  • Data source in 'Csv in wikipage' or 'PmWiki simple table'
  • Output as 'PageVars'


Table(from PmWiki Simple Table) - Output(PageVar)

(:txtdbPageVar:)
(:txtdbSet id3 'Cookbook.Txtdb-locale' Language:)
(:txtdbQuery id3 "SELECT keyword,french FROM action WHERE keyword IN (Edit,Save,Delete,Read)":)
(:txtdbDraw id3 pagevar prefix=txtdb :)
(:txtdbPageVarEnd:)
----
||border=1 width=50%
||! EDIT ||! SAVE ||! DELETE ||! READ ||
|| "{$txtdb_Edit}" || "{$txtdb_Save}" || "{$txtdb_Delete}" || "{$txtdb_Read}" ||


EDITSAVEDELETEREAD
"Éditez""Sauf""Suppression""Lu"

Table(from PmWiki Simple Table) - Output(PageVar from Transposed row)

(:txtdbPageVar:)
(:txtdbSet id4 'Cookbook.Txtdb-sample3' mydb2:)
(:txtdbQuery id4 "SELECT * FROM GreekAlphabet LIMIT 1":)
(:txtdbDraw id4 pagevar 'transpose' UseFirstAsKey=0:)
(:txtdbPageVarEnd:)

||bgcolor=beige width=50% border=1
|| col1 || col2 || col3 || col4 || col5 ||
|| {$col1} || {$col2} || {$col3} || {$col4} || {$col5} ||

col1col2col3col4col5
zetaetathetaiotakappa

Reference Table(from PmWiki Simple Table) - Output(Wikitable,Sortable)

(:table:action:)
:lang: spanish
(:txtdbSet id2 'Cookbook.Txtdb-locale' Language:)
(:txtdbQuery id2 "SELECT keyword,{$:lang} FROM {$:table} WHERE keyword IN (Edit,Save,Delete,Read)":)
(:txtdbDraw id2 wikitable sortable id=id100:)
lang
spanish
keywordspanish
EditCorrija
DeleteCancelación
SaveReserva
ReadLeído

Reference Table(from PmWiki Simple Table) - Output(Wikitable,Sortable)

(:txtdbSet id1 'Cookbook.Txtdb-locale' Language:)
(:txtdbQuery id1 "SELECT * FROM action WHERE keyword IN (Edit,Save,Delete,Read)":)
(:txtdbDraw id1 wikitable sortable id=id101:)
idkeywordenglishfrenchgermanspanish
6EditEditÉditezRedigieren SieCorrija
9DeleteDeleteSuppressionLöschungCancelación
10SaveSaveSaufAußerReserva
11ReadReadLuGelesenLeído

Reference Table(from PmWiki Simple Table) - Output(Wikitable,Sortable)

(:txtdbSet id10 'Cookbook.Txtdb-sample3' mydb2:)
(:txtdbQuery id10 "SELECT * FROM GreekAlphabet LIMIT 3":)
(:txtdbDraw id10 wikitable 'sortable' id=id102 :)
col1col2col3col4col5
zetaetathetaiotakappa
lamdamunuxiomikron
pirhosigmatauupsilon


See page data source(1) | See page data source(2)

Edit - History - Print - Recent Changes - Search
Page last modified on November 08, 2022, at 11:38 AM