provide_feedback.php

<?php
	/**
	 * Version : 0.1
	 * Author: Luka Antolic-Soban
	 */

	/* get connect to MYSQL server */
	require 'connect.php';

	session_start();

	/* instances for search engine */
	$location = "";
	$rating ="";
	$comment = "";
	$query = "";
	$result = "";
	$error_msg = "";

	/* User clicks the return button to go back to panel page */
	if(isset($_POST['goBack'])) {
		//go back to menu since it worked
		header("Location: customer_panel.php");
	}


	if (isset($_POST['Submit'])) {
		$location = $_POST['location'];	//location
		$rating = $_POST['rating'];	//rating
		$comment = $_POST['comment']; //comment
		$user = $_SESSION['username'];

		$query .= "INSERT INTO Review (Comment, Rating, Location, Username) VALUES ('$comment', '$rating', '$location', '$user');";

		$result=mysql_query($query);

		if (empty($result)) {
			$error_msg = "An ERROR has occured with your submisson";
			echo "<script type='text/javascript'>alert('$error_msg');</script>";
		} else {
			header("Location: customer_panel.php");
		}
	}


?>
<!DOCTYPE html>
<html>
	<head>
		<title>Provide Feedback</title>
	</head>
	<body>
		<div style="text-align:center">PROVIDE FEEDBACK</div>
		Location:
		<form method="post">
			<select name="location">
				<option value="Atlanta">Atlanta</option>
				<option value="Charlotte">Charlotte</option>
				<option value="Savannah">Savannah</option>
				<option value="Orlando">Orlando</option>
				<option value="Miami">Miami</option>
			</select><br />
		Rating:
			<select name="rating">
				<option value="Excellent">Excellent</option>
				<option value="Good">Good</option>
				<option value="Bad">Bad</option>
				<option value="Very Bad">Very Bad</option>
				<option value="Neutral">Neutral</option>
			</select>
			<br />
		Comment: <input type='text' name='comment' id='comment' />
		<input type='submit' name='Submit' />
		</form>
		<form method="post">
			<input type='submit' name='goBack' value="Back to Customer Panel" />
		</form>
	</body>
</html>