Recent Changes - Search:

Site

Dev

pmwiki.org

WikiSandbox edit SideBar
Version: Php-5.2.17
Version: pmwiki-2.2.5

Txtdb-sample6

Package version/links:

pmwiki-2.2.5
Skin - pmwiki
txtdb-2.2.0-alpha-6-20100212

Txtdb - Sql query using form and txtdb directives

  • Data source in Csv in wikipage and 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 :)
(:input select query "SELECT keyword,english FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" English:)
(:input select query "SELECT keyword,french FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" French:)
(:input select query "SELECT keyword,german FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" German:)
(:input select query "SELECT keyword,spanish FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" Spanish:)
(:input hidden txtdbFrmId TxtDbId1:)(:input submit txtdbSubmit
value="View":)
(:input end:)
(:txtdbDrawVar TxtDbId1 sessionvar prefix=txtdb :)

3.Using PageVar
||border=1
|| 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:)
(:sortable:)
idkeywordenglishfrenchgermanspanish
5EditEditÉditezRedigieren SieCorrija
8DeleteDeleteSuppressionLöschungCancelación
9SaveSaveSaufAußerReserva
10ReadReadLuGelesenLeído


Edit - History - Print - Recent Changes - Search
Page last modified on March 31, 2010, at 05:41 AM