<?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>Moreno Travel Admin Portal</h1>
<?php


require_once('connectvars.php');

	

$dbh = mysql_connect(hostname, username, password)

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

mysql_select_db (dbname, $dbh);



$city_name = $_POST['city_name'];
$city_state = $_POST['city_state'];
$city_details = $_POST['city_details'];
$city_pic = $_POST['city_pic'];
$location_id = $_POST['location_id'];
	

$query="INSERT INTO cities (city_name, city_state, city_details, city_pic, location_id)

VALUES ('$city_name', '$city_state', '$city_details', '$city_pic', '$location_id')";


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

?>



</div>
<?php include 'footer.php'; ?>

</div>


</body>

</html>