Changeset 430 for trunk/info/info/alkisn/alkisnamstruk.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/alkisnamstruk.php (modified) (5 diffs)

trunk/info/info/alkisn/alkisnamstruk.php

@@ -15 +15 @@
         2021-12-09 Neue Parameter: $katAmtMix (Kataster-Amt-Mix), $PrntBtn (Drucken-SchaltflÀche). Gruppenwechsel Bezirk.
         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
 */
 ini_set("session.cookie_httponly", 1);
@@ -65 +66 @@
 if (!$con) "\n<p class='err'>Fehler beim Verbinden der DB</p>";
 
-$sql="SELECT p.nachnameoderfirma, p.anrede, p.vorname, p.geburtsname, to_char(cast(p.geburtsdatum AS date),'DD.MM.YYYY') AS geburtsdatum, 
-p.namensbestandteil, p.akademischergrad, a.beschreibung AS anrv
+$sql="SELECT p.nachnameoderfirma, p.anrede, coalesce(p.vorname, '') AS vorn, coalesce(p.geburtsname, '') AS geburts, to_char(cast(p.geburtsdatum AS date),'DD.MM.YYYY') AS geburtsdatum, 
+coalesce(p.namensbestandteil, '') AS nbest, coalesce(p.akademischergrad, '') AS aka, a.beschreibung AS anrv
 FROM ax_person p LEFT JOIN ax_anrede_person a ON p.anrede = a.wert WHERE gml_id= $1 AND p.endet IS NULL;";
 
 $v = array($gmlid);
-$res = pg_prepare("", $sql);
-$res = pg_execute("", $v);
+$res = pg_prepare($con, "", $sql);
+$res = pg_execute($con, "", $v);
 
 if (!$res) {
@@ -85 +86 @@
 }
 if ($row = pg_fetch_assoc($res)) {
-        $vor=htmlentities($row["vorname"], ENT_QUOTES, "UTF-8");
+        $vor=htmlentities($row["vorn"], ENT_QUOTES, "UTF-8");
         $nam=htmlentities($row["nachnameoderfirma"], ENT_QUOTES, "UTF-8");
-        $geb=htmlentities($row["geburtsname"], ENT_QUOTES, "UTF-8");
+        $geb=htmlentities($row["geburts"], ENT_QUOTES, "UTF-8");
         $anrk=$row["anrede"]; // Key
         $anr=$row["anrv"]; // Value
-        $nbest=htmlentities($row["namensbestandteil"], ENT_QUOTES, "UTF-8");
-        $aka=htmlentities($row["akademischergrad"], ENT_QUOTES, "UTF-8");
+        $nbest=htmlentities($row["nbest"], ENT_QUOTES, "UTF-8");
+        $aka=htmlentities($row["aka"], ENT_QUOTES, "UTF-8");
 
         echo "<table>"
@@ -114 +115 @@
 
         $v = array($gmlid);
-        $resa = pg_prepare("", $sqla);
-        $resa = pg_execute("", $v);
+        $resa = pg_prepare($con, "", $sqla);
+        $resa = pg_execute($con, "", $v);
         if (!$resa) {
                 echo "\n<p class='err'>Fehler bei Adressen</p>";
@@ -186 +187 @@
 
         $v = array($gmlid);
-        $resg = pg_prepare("", $sqlg);
-        $resg = pg_execute("", $v);
+        $resg = pg_prepare($con, "", $sqlg);
+        $resg = pg_execute($con, "", $v);
 
         if (!$resg) {