From 95849a4614a55b46214622f88bb6dbc66cb54725 Mon Sep 17 00:00:00 2001 From: Benjamin Franzke Date: Fri, 25 Jan 2013 08:33:05 +0100 Subject: Add settings page for database connection --- sqlbox/view.php | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'sqlbox/view.php') diff --git a/sqlbox/view.php b/sqlbox/view.php index 9efe93b..f79b8dc 100644 --- a/sqlbox/view.php +++ b/sqlbox/view.php @@ -87,7 +87,14 @@ $correct = true; if (isset($data->sqlbox_query)) { echo $OUTPUT->heading('SQL Query: '.$data->sqlbox_query); - $db = pg_connect("host=localhost dbname=sqlbox user=sqlbox password=foobar"); + + $con = sprintf("host=%s dbname=%s user=%s password=%s", + $CFG->sqlbox_hostname ? $CFG->sqlbox_hostname : "localhost", + $CFG->sqlbox_database ? $CFG->sqlbox_database : "sqlbox", + $CFG->sqlbox_user ? $CFG->sqlbox_user : "sqlbox", + $CFG->sqlbox_password ? $CFG->sqlbox_password : "sqlbox_pw" ); + + $db = pg_connect($con); if (!$db) error("Failed to connect to sqlbox db"); -- cgit