From d14b81bc0242cfb49229571f38eb26fa7de43b2b Mon Sep 17 00:00:00 2001
From: Olaf Bohlen <olbohlen@eenfach.de>
Date: Fri, 16 Jun 2023 13:01:28 +0200
Subject: [PATCH] init vars to empty value

---
 index.php |   14 ++++++++++----
 1 files changed, 10 insertions(+), 4 deletions(-)

diff --git a/index.php b/index.php
index fc5482d..f1b6ebd 100644
--- a/index.php
+++ b/index.php
@@ -24,12 +24,17 @@
       echo "no other file found!";
     }
     echo '</p>';
- 
+
+    $host = "";
+    $user = "";
+    $pass = "";
+    $db = "";
+
     $host = $_ENV["DBHOST"]; 
     $user = $_ENV["DBUSER"]; 
     $pass = $_ENV["DBPASS"]; 
     $db = $_ENV["DBNAME"]; 
-
+    echo '<p>Connecting to database at ' .$host . '</p>';
     $con = pg_connect("host=$host dbname=$db user=$user password=$pass")
         or die ("Could not connect to server\n"); 
 
@@ -37,11 +42,12 @@
 
     $rs = pg_query($con, $query) or die("Cannot execute query: $query\n");
 
+    echo '<p>Database results:<hr>';
     while ($row = pg_fetch_row($rs)) {
       echo "$row[0]\n";
     }
-
-    pg_close($con); 
+    echo "</p>";
+    pg_close($con);
 ?>
  </body>
 </html>

--
Gitblit v1.9.3