<?php
	require_once ('authorize1.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US">

<head>
<title>Moreno Travel</title>
    <link href="style.css" rel="stylesheet" type="text/css" />
    <meta http-equiv="content-type"
        content="text/html; charset=utf-8" />
</head>





<?php include 'admin_header.php'; ?>

<h1></h1>
<?php


require_once('connectvars.php');

	

$dbh = mysql_connect(hostname, username, password)

	or die("Unable to connect to MySQL");

mysql_select_db (dbname, $dbh);



$hotel_name = $_POST['hotel_name'];
$hotel_address = $_POST['hotel_address'];
$hotel_city = $_POST['hotel_city'];
$hotel_state = $_POST['hotel_state'];
$hotel_country = $_POST['hotel_country'];
$hotel_phone = $_POST['hotel_phone'];
$hotel_features = $_POST['hotel_features'];
$hotel_pic = $_POST['hotel_pic'];
$hotel_rating = $_POST['hotel_rating'];
$hotel_green = $_POST['hotel_green'];
$location_id = $_POST['location_id'];
	

$query="INSERT INTO hotel (hotel_name, hotel_address, hotel_city, hotel_state, hotel_country, hotel_phone, hotel_features, hotel_pic, hotel_rating, hotel_green, location_id)

VALUES ('$hotel_name', '$hotel_address', '$hotel_city', '$hotel_state', '$hotel_country', '$hotel_phone', '$hotel_features', '$hotel_pic', '$hotel_rating','$hotel_green', '$location_id')";


echo "<p>The hotel ".$hotel_name." was successfully added.  Click <a href=\"admin_addhotel.php\">here</a> to add another hotel.";
   
 mysql_query($query) or die("MySQL error - ".mysql_errno()." - ".mysql_error());  

?>



</div>


</div>


</body>

</html>