File: AAmessageboard.php
<?php
include "mconnect.php";
include "getcity.php";
?>
<html>
<head>
<title> Amateur Astronomer Message Board </title>
<style>
#container {
background-color: #6a6b89;
font-family: Arial, Helvitica;
width: 800px;
margin: 0 auto;
color: #fff;
}
#container h1 {
color: #fff;
padding-left: 10px;
padding-top: 10px;
text-align: center;
margin-bottom: 0;
}
#mcontainer {
left: 100px;
top: 50px;
width: 600px;
height: 300px;
font-size: 18px;
background-color: #000;
margin-left: auto;
margin: center;
margin-right: auto;
overflow: auto;
scrollbar-3dlight-color: #FFF;
scrollbar-arrow-color: #000;
scrollbar-base-color: #000;
scrollbar-darkshadow-color: #000;
scrollbar-face-color: #7BF915;
scrollbar-highlight-color: #FFF;
scrollbar-shadow-color: #000;
font-family: Synchro LET;
}
.mname {
font-size: 18px;
}
.tcontainer {
left: 100px;
width: 600px;
height: 100px;
background-color: #000;
border: 10px;
border-color: #3E2D51;
margin-left: auto;
margin-right: auto;
font-family: Synchro LET;
color: #fff;
font-size: 14px;
}
.orangecolor {
color: #F0581C;
}
.dkpurplecolor {
color: #3E2D51;
font-size: 24px;
text-align: left;
padding-left: 100px;
}
.ltgreencolor {
color: #7BF915;
font-family:
}
.submittextzip {
background-color:#000;
color: #FFF;
font-family: Arial, Helvitica;
border: 2px solid #999;
font-size: 12px;
width: 50px;
}
.submittextname {
background-color:#000;
color: #FFF;
font-family: Arial, Helvitica;
border: 2px solid #999;
font-size: 12px;
width: 150px;
}
.submittextemail {
background-color:#000;
color: #FFF;
font-family: Arial, Helvitica;
border: 2px solid #999;
font-size: 12px;
width: 150px;
}
.submittextweb {
background-color:#000;
color: #FFF;
font-family: Arial, Helvitica;
border: 2px solid #999;
font-size: 12px;
width: 150px;
}
.submittextlocation {
background-color: #F5F682;
font-weight: bold;
font-size: 13px;
}
</style>
</head>
<body>
<div id="container">
<h1>Amateur Astronomer<span class="orangecolor">Message Board</span></h1><p>
<div style="text-align: right; margin-top: .5em; padding-right: 100px; font-size: 12px;">
<div id="submittext" class="forms">
<form method="get" action="">
Enter Zipcode
<input type="text" name="zip" value="" class="submittextzip">
</p> <p>
<input type="submit" value="Change Location" class="submittextlocation">
</form>
</div>
</div>
<p>
<p>
<div id="location" class="dkpurplecolor"><?php echo $cityname; ?></div>
<div id="mcontainer" class="ltgreencolor">
<?php
$query = "select * from AAmessageboard where zip in (\"{$_GET['zip']}\")";
$result = @mysql_query($query, $connection);
while($row = @mysql_fetch_array($result)) {
echo "<div><a href=\"mailto:{$row['email']}\">{$row['username']}</a> of</div>";
echo "<div>{$row['website']}</div>";
echo "<div>{$row['comment']}</div>";
echo "<hr>";
}
?>
</div><p></p>
<div style="text-align: right; margin-top: 1em; padding-bottom: 10px; padding-right: 100px; font-size: 12px;">
<form method="post" action="AAprocess.php">
<input type="textarea" class="tcontainer" name="comment"/><p>
Fill out required* fields before submitting text to message board. <p>
<div id="submittext" class="forms">
Name*
<input type="text" name="username" value="" class="submittextname">
<p>
Email Address*
<input type="text" name="email" value="" class="submittextemail">
<p>
Web Site
<input type="text" name="website" value="" class="submittextweb">
<p>
<input type="hidden" value="<?php echo $_GET['zip']; ?>" name="zip">
<input type="submit" value="Submit" class="submittextlocation">
<p>
</form>
</div>
</div>
</div>
</div>
</body>
</html>