Untitled

<html>
	<head>
		<meta charset="UTF-8">
		<title>Homework 5 CS 4620</title>
		<meta name="author" content="Isaiah Boyce">

	</head>

	<body>
		<form action="" method="post">
			<div class="row">
				<h1> CS 4620 - Homework 5</h1>
			</div>
			<div class= "row">
				<label for="name">Name: </lable>
				<input type = "text" name="name" id="name"/>
			</div>

			<div class= "row">
				<lable for="username"> MySql Username: </label>
				<input type="text" name="username" id="username"/>
			</div>
			<div class= "row">
				<lable for="password"> MySql Password: </label>
				<input type="password" name="password" id="password"/>
			</div>
			<div class= "row">
				<lable for="query1"> Query 1 = </label>
				<input type="text" name="query1" id="query1"/>
			</div>
			<div class= "row">
				<lable for="query2"> Query 2 = </label>
				<input type="text" name="query2" id="query2"/>
			</div>
			<div class= "row">
				<button type="submit" name="submitform" id="submitform">Submit</button>
			</div>
		</form>
	</body>

	<?PHP
		if(isset($_POST['submitform'])) {
			echo '<div class="results-wrapper">';
			echo '<div class="results">';
			$dbhost = '127.0.0.1';
			$dbname = 'cs4620e1';
			$dbuser = $_POST['username'];
			$dbpass = $_POST['password'];

			try {
				$dp_connection = PDO('mysql:host=' . $dbhost . ';dbname=' . $dbname . ';charset=utf8', $dbuser, $dbpass);
				$db_connection->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
			} catch (PDOException $e) {
				echo $e->getMessage();
				die();
			}

			$que1 = $_POST['query1'];
			$que2 = $_POST['query2'];

			//Query 1 = SELECT AN,AD,BT,DATE_FORMAT(publDate, '%Y-%m-%d') as publDate FROM auth JOIN book on book.BA = auth.AN WHERE BT BETWEEN 'R1' and 'T2' OR publDate >= (now() - INTERVAL 60 DAY);
			echo '<h2>Query 1</h2>';
			echo '<p>'.$que1.'</p>';

			try {
				$pre = $db_connection->prepare($que1, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
				$pre->execute();
			} catch (Exception $e) {
				echo $e->getMessage();
				die();
			}

			$data = $pre->fetchALL(PDO::FETCH_ASSOC);
			echo '<pre>'.print_r($data,true).'</pre>';

			//========================================
			//Query 2 = SELECT AN,AA,AD,BT,publDate,PD FROM auth JOIN book on book.BA = auth.AN JOIN publ on publ.PN = book.BP WHERE publDATE >= '2014-01-01 00:00:00' AND publDate < '2015-01-01 00:00:00';

			echo '<h2>Query 2</h2>';
			echo '<p>'.$que2.'</p>';

			try {
				$pre = $db_connection->prepare($que2, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
				$pre->execute();
			} catch (Exception $e) {
				echo $e->getMessage();
				die();
			}

			$data = $pre->fetchAll(PDO::FETCH_ASSOC);
			echo '<pre>'.print_r($data,true).'</pre>';

			echo '</div>';
			echo '</div>';

			//print
			print "<xmp>\n";
			$printFile = file_get_contents('index.php');
			echo $printFile;
		}
	?>
</html>