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