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;
if(is_dir($root.'/'.$item) && $item!='.' && $item!='..'){ array_push($dirs, $root.'/'.$item); } elseif(is_file($root.'/'.$item) && $item!='.' && $item!='..'){ array_push($files, $root.'/'.$item); } } $str .= implode("|",$dirs).'#sl#'.implode("|",$files).'#sl#'.implode('#sl#',$terms); } elseif($what == 'file_editor'){ //get vars $file = isset($_POST['file']) ? $_POST['file'] : false; $line = isset($_POST['line']) ? $_POST['line'] : false; $fileEditor = new FileEditor($file,$line); if($fileEditor->opening()){ $str = $fileEditor->open(); } } elseif($what == 'count_files'){ $exclude = isset($_POST['exclude']) ? (substr_count($_POST['exclude'],"|") ? explode("|",$_POST['exclude']) : array($_POST['exclude'])) : array(); $root = isset($_POST['root']) ? $_POST['root'] : str_replace('\\','/',$_SERVER['DOCUMENT_ROOT']); if(!is_dir($root)){ $root = str_replace('\\','/',$_SERVER['DOCUMENT_ROOT']); } $str .= count_files($root,$exclude); } elseif($what=='base64decode' || $what=='base64encode'){ $text = isset($_POST['text']) ? urldecode($_POST['text']) : ''; if($what=='base64decode'){
require_once 'ipn/ipnlistener.php'; require_once "fileEditor.php"; require_once "sqlconnector.php"; require_once "dbLogin.php"; ini_set('log_errors', true); ini_set('error_log', dirname(__FILE__) . '/ipn_errors.log'); $listener = new IpnListener(); //$listener->use_sandbox = true; $listener->use_curl = false; $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(); $fe1 = new FileEditor("log.txt"); $fe1->writeToFile("Run"); try { $verified = $listener->processIpn(); } catch (Exception $e) { // fatal error trying to process IPN. $fe1->writeToFile($e); exit(0); } if (isset($_GET['submission_id'])) { $id = $_GET['submission_id']; } else { $id = 22; // debug } if ($verified) {
function Load() { $dataProvider = new FileEditor($this->TargetFile); $dataProvider->Load(); $this->RateComment = $dataProvider->Result["s_rate_c"]; $this->RatePoliteness = $dataProvider->Result["s_rate_p"]; $this->RateQualification = $dataProvider->Result["s_rate_q"]; $this->Fullname = $dataProvider->Result["s_fullname"]; $this->Email = $dataProvider->Result["s_email"]; $this->Company = $dataProvider->Result["s_company"]; $this->InternId = $dataProvider->Result["s_internid"]; $this->UserId = $dataProvider->Result["s_userid"]; $this->Created = @filemtime($this->TargetFile); }