/
personalClassInfo.php
executable file
·65 lines (53 loc) · 2.2 KB
/
personalClassInfo.php
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
<?php
require_once("classMapping.php");
require_once("dbLogin.php");
require_once("sqlconnector.php");
require_once("fileEditor.php");
require_once("support.php");
function print_class_info() {
// SQL
$fe = new FileEditor('login-info.txt');
$credentials = $fe->readFile();
$login = new Credentials("terrapintango.cgpkve9uh8yp.us-east-1.rds.amazonaws.com", $credentials[0], $credentials[1], "tangodb");
$connector = new SQLConnector($login);
$connector->connect();
$query = "SELECT r.fname, r.lname, c.classes, c.passtype
FROM records r, classes c, confirmation f
WHERE r.registerid = c.registerid and r.registerid = f.registerid and
f.payment_status = 'Completed'";
try {
$result = $connector->retrieve($query);
} catch (Exception $e) {
echo $e->getMessage();
}
// END SQL
$person_classes = array();
$table = "<table border=\"1\">";
$table .= "<th>Name</th><th>Pass Type</th><th>Classes</th>";
echo "<h1>Class Mapping</h1>";
foreach ($result as $record) {
//print_r($record);
$person_classes[$record['fname']." ".$record['lname']] = array($record['passtype'],
parse_class_string($record['classes']));
// print_r($translated_classes);
// echo "<br>";
}
//print_r($person_classes);
foreach ($person_classes as $person => $class_ary) {
$table .= "<tr><td>$person</td>";
$table .= "<td>".$class_ary[0]."</td><td>";
$table .= implode(", ", $class_ary[1])."</td><tr>";
}
echo $table;
}
function parse_class_string($class_string) {
$c = explode(",", $class_string);
sort($c);
$translated_classes = array();
// make classes into nice words
foreach ($c as $class) {
array_push($translated_classes, get_classname($class));
}
return $translated_classes;
}
?>