From 4d8bfd9942fc5801e048487a9cde91a64326e4d3 Mon Sep 17 00:00:00 2001
From: Olaf Bohlen <olbohlen@eenfach.de>
Date: Wed, 01 Mar 2023 09:50:30 +0100
Subject: [PATCH] minor update
---
index.php | 39 +++++++++++++++++++++++++++++++++------
1 files changed, 33 insertions(+), 6 deletions(-)
diff --git a/index.php b/index.php
index e2f3c54..dd752cc 100644
--- a/index.php
+++ b/index.php
@@ -5,17 +5,44 @@
<body>
<?php
echo '<p>hello world from ' .$_ENV["HOSTNAME"] . '</p>';
+ echo '<p>the current php version is ' . phpversion() . '</p>';
echo '<p>TEXT = ' .$_ENV["TEXT"] . '</p>';
echo '<p>PASSWORD = ' .$_ENV["PASSWORD"] . '</p>';
- echo '<p>'
- $filename = '/secretstore/filesecret';
-
- if (file_exists($filename)) {
+ echo '<p>';
+ if (file_exists('/secretstore/filesecret')) {
+ echo "secret file contains: ";
echo nl2br(file_get_contents( "/secretstore/filesecret" ));
} else {
- echo "no additional secrets found!"
+ echo "no additional secrets found!";
}
- echo '</p>'
+ echo '</p>';
+ echo '<p>';
+ if (file_exists('/pvcmount/pfile')) {
+ echo "file contains: ";
+ echo nl2br(file_get_contents( "/pvcmount/pfile" ));
+ } else {
+ echo "no other file found!";
+ }
+ echo '</p>';
+
+ $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");
+
+ $query = "SELECT * FROM foo LIMIT 5";
+
+ $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";
+ }
+ echo "</p>";
+ pg_close($con);
?>
</body>
</html>
--
Gitblit v1.9.3