| | |
| | | <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>'; |
| | |
| | | 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> |