<?php

	 	$host = "localhost";
		$username = "jacobban_week8";
		$password = "JzbsOQcU1h5A";
		$db = "jacobban_testimonials";

		$conn = mysqli_connect($host, $username, $password, $db);

	 	if(isset($_POST["f_submit"])){
	 		$tName = mysqli_real_escape_string($conn, $_POST["name"]);
	 		$tGender = mysqli_real_escape_string($conn, $_POST["gender"]);
	 		$tTestimonial = mysqli_real_escape_string($conn, $_POST["testimonial"]);
	 		$insert = "INSERT INTO testimonial_tb (gender, name, testimonial) VALUES ('".$tGender."', '".$tName."', '".$tTestimonial."')";
	 		$sendInsert = mysqli_query($conn, $insert);

	 	}


	?>
	<div class="page-container">
		<?php
			$host = "localhost";
		        $username = "jacobban_week8";
	                $password = "JzbsOQcU1h5A";
		        $db = "jacobban_testimonials";

			$conn = mysqli_connect($host, $username, $password, $db);

			if(!$conn){
				echo "<p>Connection failed</p>";
			}
			else{

				$query = "SELECT * FROM testimonial_tb";

				$queryResult = mysqli_query($conn, $query);

				$numRows = mysqli_num_rows($queryResult);

				if($numRows > 0){
					echo "<table>";
					echo "<tr> <th>Name</th> <th>Gender</th> <th>Testimonial</th> </tr>";

						while($row = mysqli_fetch_assoc($queryResult)){
							$gender = $row["gender"];
							$name = $row["name"];
							$testimonial = $row["testimonial"];

							echo "<tr>";
								echo "<td>" . $name . "</td>";
								echo "<td>" . $gender . "<td>";
								echo "<td>" . $testimonial . "</td>";
							echo "</tr>";

						}
					echo "</table>";
				}
			}
		 ?>