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 "support.php"; require_once "dbLogin.php"; require_once "sqlconnector.php"; session_start(); echo "Sign up (placeholder)<br />"; if (isset($_POST['submit'])) { $host = "localhost"; $dbuser = "******"; $dbpassword = "******"; $database = "calendapp"; $table = "users"; $connector = new SQLConnector(new Credentials($host, $dbuser, $dbpassword, $database)); $connector->connect(); $username = trim($_POST["username"]); $email = trim($_POST['email']); $cryptpw = password_hash($_POST['password'], PASSWORD_DEFAULT); $date = date(DATE_ISO8601); $sqlQuery = "insert into users values('{$username}', '{$cryptpw}', 'temp', '{$date}', '{$email}')"; echo $sqlQuery . "<br />"; if ($connector->insert($sqlQuery)) { $_SESSION['loggedIn'] = true; //Stay logged in $_SESSION['username'] = $username; header("Location: main.php"); } } $body = <<<BODY <form action="signup.php" method="post"> Username: <input type="text" name="username" required="required"><br />
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; ?> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:fb="http://ogp.me/ns/fb#"> <head> <script source=></script>
function drawPage() { global $credentials; $body = ""; $login = new Credentials("terrapintango.cgpkve9uh8yp.us-east-1.rds.amazonaws.com", $credentials[0], $credentials[1], "tangodb"); $connector = new SQLConnector($login); $connector->connect(); //print_r($result); if (isset($_POST['submit'])) { $fields = $_POST['field']; $fieldsString = implode(", ", $fields); foreach ($fields as $table) { if ($table == "ConfirmedRegistrants") { $query = "SELECT r.fname, r.lname, r.partnerfname, r.email, c.classes, c.passtype, c.price\n FROM records r, classes c, confirmation f\n WHERE r.registerid = c.registerid and r.registerid = f.registerid and\n f.payment_status = 'Completed'"; } else { $query = "select * from {$table}"; } $result = $connector->retrieve($query); $body .= "<h1>" . ucfirst($table) . "</h1>" . drawTable($result); } } else { if (isset($_POST['arbsubmitr'])) { $query = $_POST['arbtext']; $result = $connector->retrieve($query); $body .= "<h1>{$query}</h1>" . drawTable($result); } else { if (isset($_POST['arbsubmiti'])) { $query = $_POST['arbtext']; $error = false; try { $result = $connector->insert($query); } catch (Exception $e) { echo $e->getMessage(); $error = true; } if (!$error) { $body .= "Query successful."; } $body .= "<p><form action='admin.php' method=POST><input type='submit' value='Back'></form></p>"; } else { if (isset($_POST['classprint'])) { header("Location: classBalanceInfo.php"); } else { if (isset($_POST['mapping'])) { echo print_class_info(); } else { if (isset($_POST['edit'])) { header("Location: editdb.php"); } else { $body = <<<BODY <h1> Database Access </h1> <form action="admin.php" method="post"> <p> <strong>Select tables to display</strong><br /> <select name="field[]" multiple="multiple"> <option value="records">Records</option> <option value="classes">Classes</option> <option value="confirmation">Confirmation</option> <option value="ConfirmedRegistrants">Confirmed registrations</option> </select> </p> <p> <input type="submit" name="submit" value="Display Tables"> </p> <p> <input type='text' name='arbtext'> </p> <p> <input type='submit' name='arbsubmitr' value='Submit arbitrary query (Get response)'> <input type='submit' name='arbsubmiti' value='Submit arbitrary query (Do not get response)'> </p> \t\t\t\t\t<p> \t\t\t\t\t\t<input type='submit' name='classprint' value='Class Balance Info'> \t\t\t\t\t</p> <p> \t\t\t\t\t\t<input type='submit' name='mapping' value='Confirmed Schedules'> \t\t\t\t\t</p> <p> \t\t\t\t\t\t<input type='submit' name='edit' value='Edit Classes'> \t\t\t\t\t</p> </form> BODY; } } } } } } echo generatePage($body, "Admin Panel"); }