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