LANIS-Statistik (Druckversion)
stri[0];
echo "Stand: ". date('d.m.y')."";
//$conn_string = "host=10.12.55.209 port=5433 dbname=osiris user=postgres password=ktWaPG53";
$dbconn = pg_connect($conn_string);
$sql_statistik1 = "select gebiete,anzahl,gesamtflaeche,durch_flaeche,prozent from statistik.uebersicht where typ = 1 order by subtyp";
$sql_statistik2 = "select gebiete,anzahl,gesamtflaeche,durch_flaeche,prozent from statistik.uebersicht where typ = 2 order by subtyp";
$sql_statistik3 = "select gebiete,anzahl,gesamtflaeche,durch_flaeche,prozent from statistik.uebersicht where typ = 3 order by subtyp";
?>
| Gebiet | Anzahl | Gesamtfläche | durchschn. Fläche | in Prozent der Landesfläche | Internationale Schutzgebiete | "; while ($row = pg_fetch_row($result_typ1)) { echo "
| "; echo $row[0]; echo " | "; echo ""; echo $row[1] ; echo " | "; echo ""; echo number_format($row[2],0,',','.') . " ha"; echo " | "; echo ""; if ($row[3]){ echo number_format($row[3],0,',','.'). " ha"; } echo " | "; echo ""; echo number_format($row[4],1,',','.'). " %"; echo " | "; echo "
| Nationale Schutzgebiete | ||||
| "; echo $row[0]; echo " | "; echo ""; echo $row[1] ; echo " | "; echo ""; echo number_format($row[2],0,',','.') . " ha"; echo " | "; echo ""; if ($row[3]){ echo number_format($row[3],0,',','.'). " ha"; } echo " | "; echo ""; echo number_format($row[4],1,',','.'). " %"; echo " | "; echo "
| Biotope | ||||
| "; echo $row[0]; echo " | "; echo ""; echo $row[1] ; echo " | "; echo ""; echo number_format($row[2],0,',','.') . " ha"; echo " | "; echo ""; if ($row[3]){ echo number_format($row[3],0,',','.'). " ha"; } echo " | "; echo ""; echo number_format($row[4],1,',','.'). " %"; echo " | "; echo "
Karte zum Vergleich"; ?>