Ceci est une ancienne révision du document !
<php> Check for presence of data plugin $dataPluginFile = DOKU_PLUGIN.'data/syntax/table.php'; if(!file_exists($dataPluginFile)){ msg('Cannot find Data plugin.', -1); } require_once $dataPluginFile; $pdt = new syntax_plugin_data_table(); $data = array( 'classes' ⇒ 'association', 'limit' ⇒ 0, 'dynfilters' ⇒ false, 'summarize' ⇒ false, 'rownumbers' ⇒ false, 'sepbyheaders' ⇒ false, 'headers' ⇒ array(), 'widths' ⇒ array(), 'filter' ⇒ array() ); $column = $pdt→dthlp→_column('lat'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('lon'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('nom'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('adresse1'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('adresse2'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('adresse3'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('codepostal'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('ville'); $data['cols'][$column['key']] = $column; $column = $pdt→dthlp→_column('web'); $data['cols'][$column['key']] = $column; $sql = $pdt→_buildSQL($data); $sqlite = $pdt→dthlp→_getDB(); $res = $sqlite→query($sql); $rows = $sqlite→res2arr($res); $rowsCount = count($rows); echo “{ “type”:“FeatureCollection”, “features”: [\n”; foreach( $rows as $n ⇒ $row ){ $rowsCount – ; list($lat, $lon, $nom, $adr1, $adr2, $adr3, $cp, $ville, $web) = array_values($row); $addresse = $adr1.' '.$adr2.' '.$adr3.' '.$cp.' '.$ville ; if( $rowsCount>0 ) echo '{“type”:“Feature”,“properties”:{ “name”:“'.$nom.'”, “address”:“'.$addresse.'” }, “geometry”:{“type”:“Point”,“coordinates”:[“'.$lon.'”,“'.$lat.'”]} }'; } echo “] }\n”; </php>