Cookbook /
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}" || | ||||||||
|
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:) | ||||||||||||||||||||||||||||||
|