1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
/**
* Prints a particular instance of sqlbox
*
* You can have a rather longer description of the file as well,
* if you like, and it can span multiple lines.
*
* @package mod
* @subpackage sqlbox
* @copyright 2012 Jan Klemkow, Benjamin Franzke
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
/// (Replace sqlbox with the name of your module and remove this line)
require_once(dirname(dirname(dirname(__FILE__))).'/config.php');
require_once(dirname(__FILE__).'/lib.php');
require_once(dirname(__FILE__).'/sqlbox_form.php');
$id = optional_param('id', 0, PARAM_INT); // course_module ID, or
$n = optional_param('n', 0, PARAM_INT); // sqlbox instance ID - it should be named as the first character of the module
if ($id) {
$cm = get_coursemodule_from_id('sqlbox', $id, 0, false, MUST_EXIST);
$course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST);
$sqlbox = $DB->get_record('sqlbox', array('id' => $cm->instance), '*', MUST_EXIST);
} elseif ($n) {
$sqlbox = $DB->get_record('sqlbox', array('id' => $n), '*', MUST_EXIST);
$course = $DB->get_record('course', array('id' => $sqlbox->course), '*', MUST_EXIST);
$cm = get_coursemodule_from_instance('sqlbox', $sqlbox->id, $course->id, false, MUST_EXIST);
} else {
error('You must specify a course_module ID or an instance ID');
}
require_login($course, true, $cm);
$context = get_context_instance(CONTEXT_MODULE, $cm->id);
add_to_log($course->id, 'sqlbox', 'view', "view.php?id={$cm->id}", $sqlbox->name, $cm->id);
/// Print the page header
$PAGE->set_url('/mod/sqlbox/view.php', array('id' => $cm->id));
$PAGE->set_title(format_string($sqlbox->name));
$PAGE->set_heading(format_string($course->fullname));
$PAGE->set_context($context);
// other things you may want to set - remove if not needed
//$PAGE->set_cacheable(false);
//$PAGE->set_focuscontrol('some-html-id');
//$PAGE->add_body_class('sqlbox-'.$somevar);
// Output starts here
echo $OUTPUT->header();
if ($sqlbox->intro) { // Conditions to show the intro can change to look for own settings or whatever
echo $OUTPUT->box(format_module_intro('sqlbox', $sqlbox, $cm->id), 'generalbox mod_introbox', 'sqlboxintro');
}
// Replace the following lines with you own code
$form = new mod_sqlbox_form($PAGE->url->out(false));
$form->display();
$data = $form->get_data();
echo $OUTPUT->heading('SQL Query: '.$data->sqlbox_query);
if (isset($data->sqlbox_query)) {
$db = pg_connect("host=localhost dbname=sqlbox user=sqlbox password=foobar");
if (!db)
error("Failed to connect to sqlbox db");
$table = db_get_table_from_query($db, $data->sqlbox_query);
$table_orig = db_get_table_from_query($db, $sqlbox->query);
pg_close($db);
echo html_writer::table($table);
if ($table->data == $table_orig->data && $table->head == $table->head)
echo $OUTPUT->heading("Correct!");
else
echo $OUTPUT->heading("Incorrect!");
}
// Finish the page
echo $OUTPUT->footer();
function db_get_table_from_query($db, $query) {
$table = new html_table;
$result = pg_query($db, $query);
if (!$result)
error("Query failed: ".pg_last_error($db));
$table = new html_table;
$n = pg_num_fields($result);
for ($i = 0; $i < $n; $i++)
$table->head[] = pg_field_name($result, $i);
$table->align = array_fill(0, $n, 'left');
while ($row = pg_fetch_row($result))
$table->data[] = $row;
return $table;
}
|