Untitled

<!DOCTYPE html>

<html>
<head>

 <meta charset=”UTF-8">
 <title>Week 24 & 25 - SCC130</title>

</head>


<body>

<!-- (PART ONE - FIRST NAME, LAST NAME, EMAIL ADDRESS) (PART ONE - FIRST NAME, LAST NAME, EMAIL ADDRESS) -->

	<form action="home.php" method="post">
		First Name  	: <input type="text" name="first_name" id="first_name" value="<?php if(isset($_POST['first_name'])){echo $_POST['first_name'];} ?>"required><br>
		Second Name 	: <input type="text" name="second_name" id="second_name" value="<?php if(isset($_POST['second_name'])){echo $_POST['second_name'];} ?>" required><br>
		Email Address 	: <input type="text" name="email" id="email" value="<?php if(isset($_POST['email'])){echo $_POST['email'];} ?>" required><br>
		SCC DB Login	: <input type="text" name="login" id="login"><br>
		SCC Password	: <input type="password" name="password" id="password"><br>
		<input type="submit" name = "form 1"><br><br>
	</form>

	<?php
    $first_name = $_POST["first_name"];
	$second_name = $_POST["second_name"];

	if (!empty($_POST["first_name"])) {
		if (!preg_match("/^[a-zA-Z ]*$/", $first_name)) {
			echo "Only letters are allowed for first name.";
		}
		else if (!empty($_POST["second_name"])) {
			if (!preg_match("/^[a-zA-Z ]*$/", $second_name)) {
				echo "Only letters are allowed for second name. ";
			}else{
				echo "Hello " , $first_name, " ", $second_name, ".";
			}
		}else{
			echo "Second name has not been entered. Please enter both names.";
		}
	}else{
		echo "First name has not been entered. Please enter both names.";
	}
	?><br><br>

	<?php
    $email = $_POST["email"];
	if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
		echo "Email isn't in an email format. (May contain illegal characters)";
    }else{
		if (!empty($_POST["email"])) {
		echo "Your email is: " , $email;
	}else{
		echo "Email has not been entered. Please enter second name.";
	}
	}
	?><br><br>

<!-- (PART ONE - FIRST NAME, LAST NAME, EMAIL ADDRESS) (PART ONE - FIRST NAME, LAST NAME, EMAIL ADDRESS) -->


<!-- (PART TWO ) -->

	<?php

	if(empty ($_POST["login"]) && ($_POST["password"])){

		echo "Please enter both Username and Password";

	}

	$username = $_POST["login"];
	$password = $_POST["password"];

	$DB_USER = $username;
	$DB_PASSWORD = $password;
	$DB_HOST = 'localhost';
	$DB_NAME = 'scc_130';

	try{
		$db=new PDO("mysql:host=$DB_HOST;dbname=$DB_NAME;charset=utf8", $DB_USER, $DB_PASSWORD); //connect to the database
		$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);  //throw exceptions when an error occurs
	}catch(PDOException $e){
		echo "Your Username and Password is incorrect.";
	}
	?>

<!-- (PART TWO ) -->

<!-- (PART THREE ) -->
	<p>
		What table would you like to view?
		<form action="home.php" method = "post">
		<select name="table" onchange="this.form.submit()">
		<option value="">Select...</option>
		<option value="Company">Company</option>
		<option value="Fruits">Fruits</option>
		<option value="Population">Population</option>
		<br><br>
		</select>

	</p>

	<?php
	$tableSelect = $_POST["table"];
		if(strcmp($tableSelect, 'Company') == 0){
			require_once('connect.php');
			try{
				$query = 'SELECT * FROM company';
				$statement = $db->query($query);
				while($row = $statement->fetch(PDO::FETCH_ASSOC)){
					echo $row['Year'] . ' , ';
					echo '&nbsp';
					echo $row['Sales'];
					echo '&nbsp';
					echo $row['Expenses'];
					echo '<br>';
					echo '<br>';
				}
			}catch(PDOException $e){
				$message = '<p>Something went wrong!</p><p>' . $e->getMessage(). '</p>';
			}
		}
		else if(strcmp($tableSelect, 'Fruits') == 0){
			require_once('connect.php');
			try{
				$query = 'SELECT * FROM fruits';
				$statement = $db->query($query);
				while($row = $statement->fetch(PDO::FETCH_ASSOC)){
					echo $row['fruit_name'] . ' , ';
					echo '&nbsp';
					echo $row['amount'];
					echo '<br>';
					echo '<br>';
				}
			}catch(PDOException $e){
				$message = '<p>Something went wrong!</p><p>' . $e->getMessage(). '</p>';
			}
		}
		else if(strcmp($tableSelect, 'Population') == 0){
			require_once('connect.php');
			try{
				$query = 'SELECT * FROM population';
				$statement = $db->query($query);
				while($row = $statement->fetch(PDO::FETCH_ASSOC)){
					echo $row['City'] . ' , ';
					echo '&nbsp';
					echo $row['People'];
					echo '<br>';
					echo '<br>';
				}
			}catch(PDOException $e){
				$message = '<p>Something went wrong!</p><p>' . $e->getMessage(). '</p>';
			}
		}


	?>

<!-- (PART THREE ) -->

</body>


</html>