Txtdb-sample6

Package version/links

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

Txtdb - Sql query using form and txtdb directives

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


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

1.Set default PageVar
(:if equal {$txtdb_Edit} '':)
(:txtdbPageVar:)
(:lang: english :)
(:txtdbSet id3 'Cookbook.Txtdb-locale' Language:)
(:txtdbQuery id3 "SELECT keyword,{$:lang} FROM action WHERE keyword IN (Edit,Save,Delete,Read)":)
(:txtdbDraw id3 pagevar prefix=txtdb :)
(:txtdbPageVarEnd:)
(:ifend:)
2.Form Options
(:input form {$Name}:)
(:input hidden dbpage 'Cookbook.Txtdb-locale':)
(:input hidden dbname Language :)
(:FROM: FROM action WHERE keyword IN (Lang,Edit,Save,Delete,Read) :)
(:input select query "SELECT keyword,english {$:FROM}" English:)
(:input select query "SELECT keyword,french {$:FROM}" French:)
(:input select query "SELECT keyword,german {$:FROM}" German:)
(:input select query "SELECT keyword,spanish {$:FROM}" Spanish:)
(:input hidden txtdbFrmId TxtDbId1:)(:input submit txtdbSubmit value="View":)
(:input end:)
(:txtdbDrawVar TxtDbId1 sessionvar prefix=txtdb :)

3.Use PageVar
||border=1 bgcolor=beige
|| EDIT || SAVE || DELETE || READ ||
|| "{$txtdb_Edit}" || "{$txtdb_Save}" || "{$txtdb_Delete}" || "{$txtdb_Read}" ||
EDITSAVEDELETEREAD
"Edit""Save""Delete""Read"

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

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


See page source | See page data source(1)

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