Changeset 430 for trunk/info/info/alkisn/alkisfshist.php

Timestamp:

07/07/22 08:51:44 (22 months ago)

Author:

frank.jaeger

Message:

ALKIS-Auskunft angepasst an PHP 8

File:

• trunk/info/info/alkisn/alkisfshist.php (modified) (5 diffs)

trunk/info/info/alkisn/alkisfshist.php

@@ -15 +15 @@
         2021-12-09 Neuer Parameter $PrntBtn (Drucken-SchaltflÀche)
         2022-01-13 Neue Functions LnkStf(), DsKy()
+        2022-07-05 PHP 8.1: Connection verwenden bei "pg_prepare" und "pg_execute", keine NULL-Werte in String-Functions verwenden
 */
 
@@ -52 +53 @@
         $sql ="SELECT bezeichnung FROM ax_gemarkung g WHERE g.gemarkungsnummer= $1 AND g.endet IS NULL LIMIT 1;";
         $v=array($gkey);
-        $res=pg_prepare("", $sql);
-        $res=pg_execute("", $v);
+        $res=pg_prepare($con, "", $sql);
+        $res=pg_execute($con, "", $v);
         if (!$res) {echo "\n<p class='err'>Fehler bei Gemarkung.</p>";}
         $gmkg="";
@@ -81 +82 @@
 
         $v=array($fsk);
-        $resv = pg_prepare("", $sqlv);
-        $resv = pg_execute("", $v);
+        $resv = pg_prepare($con, "", $sqlv);
+        $resv = pg_execute($con, "", $v);
         if (!$resv) {
                 echo "\n<p class='err'>Fehler bei Vorg&auml;nger-FS.</p>";
@@ -186 +187 @@
         ."UNION SELECT 'o' AS ftyp, ".$felder."nachfolgerflurstueckskennzeichen AS nach, vorgaengerflurstueckskennzeichen AS vor, zeigtaufexternes_art AS zart, zeigtaufexternes_name AS zname FROM ax_historischesflurstueckohneraumbezug o ".$whereclause.$whereo." AND o.endet IS NULL;";
 
-        $resu = pg_prepare("", $sqlu);
-        $resu = pg_execute("", $v);
+        $resu = pg_prepare($con, "", $sqlu);
+        $resu = pg_execute($con, "", $v);
         if ($rowu = pg_fetch_assoc($resu)) {
                 $ftyp=$rowu["ftyp"];
@@ -204 +205 @@
                 $zeart=$rowu["zart"];
                 $zename=$rowu["zname"];
+                if (is_null($zename)) {$zename="";}
                 if ($gmlid == "") {$gmlid=$rowu["gml_id"];} // fÃŒr selbst-link-Umschalter ÃŒber footer