PF2 Regel Wiki

Dies ist eine alte Version des Dokuments!

load the helper plugin / @var helper_plugin_sqlite $sqlite */ $sqlite = plugin_load('helper', 'sqlite'); if(!$sqlite){ msg('This plugin requires the sqlite plugin. Please install it', -1); return; } initialize the database connection if(!$sqlite→init('struct',DOKU_PLUGIN.'struct/db/')){ return; } use the plugin $res = $sqlite→query(„select * from data_talent left join (select rid, count(*) as zahl from multi_talent where value In („Abstammung“,“Elf„) group by rid) as m on data_talent.rid = m.rid where zahl = 2“); $arr = $sqlite→res2arr($res); print_r($val); foreach($arr ⇒ $val) { print_r($val); } <php> print(phpversion()); </php> <php> load the helper plugin /** @var helper_plugin_sqlite $sqlite */ $sqlite = plugin_load('helper', 'sqlite'); if(!$sqlite){ msg('This plugin requires the sqlite plugin. Please install it', -1); return; } initialize the database connection if(!$sqlite→init('struct',DOKU_PLUGIN.'struct/db/')){ return; } use the plugin $res = $sqlite→query(„select * from data_talent left join (select rid, count(*) as zahl from multi_talent where value In („Abstammung“,“Elf„) group by rid) as m on data_talent.rid = m.rid where zahl = 2“); $arr = $sqlite→res2arr($res); print_r($val); foreach($arr ⇒ $val) { print_r($val); } </php>