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\r\n FROM records r, classes c, confirmation f\r\n WHERE r.registerid = c.registerid and r.registerid = f.registerid and\r\n 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;
}
-->
<?php
require_once "sqlconnector.php";
require_once "dbLogin.php";
require_once "fileEditor.php";
session_start();
// receive data
$selected_classes = implode(",", json_decode($_POST['class_string']));
$passtype = $_POST['passtype'];
$price = intval($_POST['price']);
$tax = round($price * 0.035 + 0.3, 2);
$id = $_SESSION['submission_id'];
// prep connecting to db
$fe = new FileEditor('login-info.txt');
$credentials = $fe->readFile();
$cred = new Credentials("terrapintango.cgpkve9uh8yp.us-east-1.rds.amazonaws.com", $credentials[0], $credentials[1], "tangodb", 3306);
//$cred = new Credentials("localhost", "tango", "tango", "test");
$connection = new SQLConnector($cred);
$connection->connect();
$query = "INSERT INTO `classes` (`registerid`, `classes`, `price`, `passtype`)\n VALUES ('{$id}', '{$selected_classes}', '{$price}', '{$passtype}');";
try {
$connection->insert($query);
} catch (Exception $e) {
$error = $e->getMessage();
header("Location: error.php?sql_error={$error}");
}
//print_r( $selected_classes);
//echo "<br />";
//echo $price;
?>
