Untitled


<?php
// Make a MySQL Connection
$con = mysql_connect("DB", "volunteers2012", "xxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("volunteers2012", $con);

mysql_real_escape_string($unescaped_string, $con);


$sql="INSERT INTO vols2012 (id, agreeName, last_name, first_name, age, gender, phone, email, facebook, street_no, city, state, zip, attended, volbefore, volbeforeyes, cpr, tabc, skills, avail, shirt)

      VALUES ('', '$_POST[agreeName]', '$_POST[last_name]', '$_POST[first_name]', '$_POST[age]', '$_POST[gender]', '$_POST[phone]', '$_POST[email]', '$_POST[facebook]', '$_POST[street_no]', '$_POST[city]', '$_POST[state]', '$_POST[zip]', '$_POST[attended]', '$_POST[volbefore]', '$_POST[volbeforeyes]', '$_POST[cpr]', '$_POST[tabc]', '$_POST[skills]', '$_POST[avail]', '$_POST[shirt]')";

if(mysql_query($sql))
?>
<body>

<div id="navbar">
<ul>
<li class="first"><a href="index.php">HOME</a></li>
<li><a href="pass.php">GET A PASS</a></li>
<li><a href="lineup.php">LINE UP</a></li>
<li><a href="info.php">FEST INFO</a></li>
<li><a href="faq.php">FAQ</a></li>
<li><a href="vendors.php">VENDORS</a></li>
<li><a href="sponsors.php">SPONSORS</a></li>
<li class="last" ><a href="#contact">&nbsp;CONTACT&nbsp;&nbsp;</a></li>
</ul>
</div>

  <div id="main_wrap">

	 <div id="wrap_one">
		 <div class="container_wrap">

             <div id="header" class="black">
             <img src="images/headers/mainheader.png" />
             </div>

 <div class="colmask fullpage light_gray">
	<div class="col1">
		<!-- Column 1 start -->


    <div id="holding">
<span class="choice bigboldfont" style="font-size:22px">


<?php
$agreeName = check_input($_POST['agreeName'], "Form incomplete. You did not add your electronic signature. Please go back and sign the release at the end of the form.");
$lastname = check_input($_POST['last_name'], "Form incomplete. Enter your last name.");
$firstname = check_input($_POST['first_name'], "Form incomplete. Enter your first name.");
$age = check_input($_POST['age'], "Form incomplete. Enter your age.");
$gender = check_input($_POST['gender'], "Form incomplete. Enter your gender.");
$phone = check_input($_POST['phone'], "Form incomplete. Enter your phone number.");
$email = check_input($_POST['email'], "Form incomplete. Enter your email address.");
$street_no = check_input($_POST['street_no'], "Form incomplete. Please enter your address where you currently reside. This helps us when scheduling positions and meetings.");
$city = check_input($_POST['city'], "Form incomplete. Please enter your city.");
$state = check_input($_POST['state'], "Form incomplete. Please enter your state.");
$zip = check_input($_POST['zip'], "Form incomplete. Please enter your zipcode.");
$shirt = check_input($_POST['shirt'], "Form incomplete. Please enter your t-shirt size.");
?>


<p>Thank you <?php echo $_POST['agreeName'];?>! Your application to volunteer at the Free Press Summer Fest 2012 is being processed.</p>

<p>We will send you more information soon to your email address at <span class="font_orange"><?php echo $_POST['email'];?></span></p>

</span>

</div>
</div></div>
 </div>
 </div>
 </div>


 <div id="footer_wrap">

<div id="footer" class="black">
 <div id="footer_content" class="bigboldfont">

<div id="contact" class="colmask doublepage">
	<div class="colleft">
		<div class="col1 font_light_gray" style="left:51%">
			<!-- Column 1 start -->
			<p>GENERAL INQUIRIES:  PLEASE SEE <a href="faq.php">FAQ page</a> <br />
           OR WRITE TO <a href="mailto:info@freepresssummerfest.com">info@freepresssummerfest.com</a>
            </p>
			<p>PASS INQUIRIES<br />
            PLEASE VISIT <a href="http://www.stubwire.com/help.php">STUBWIRE.COM</a>
            </p>
             <p>SPONSORSHIP OPPORTUNITIES- SEE<a href="sponsors.php"> SPONSORS PAGE</a><br />
            CONTACT <a href="mailto:sponsors@freepresssummerfest.com">sponsors@freepresssummerfest.com</a>
             </p>
			<p>VENDORS- SEE<a href="vendors.php"> VENDORS PAGE</a><br />
             CONTACT <a href="mailto:vendors@freepresssummerfest.com">vendors@freepresssummerfest.com</a>
            </p>

			<!-- Column 1 end -->
		</div>
		<div class="col2 font_light_gray" style="left:58%">
			<!-- Column 2 start -->
			<p>BANDS INTERESTED IN PLAYING FPSF:<br />
            PLEASE VISIT <a href="http://www.sonicbids.com/Opportunity/OpportunityView.aspx?opportunity_id=105549">SONICBIDS.COM</a>
            </p>
            <p>VOLUNTEERS INTERESTED IN HELPING AT FPSF:<br />
            PLEASE FILL OUT THE APPLICATION <a href="index.php#volunteer">HERE</a>
            </p>
			<p>MEDIA INQUIRIES<br />
            PLEASE CONTACT <a href="mailto:Brigitte@YNHMedia.com">Brigitte@YNHMedia.com</a>
            </p>
			 <p>PHOTO/VIDEOGRAPHY<br />
            PLEASE CONTACT <a href="mailto:Brigitte@YNHMedia.com">Brigitte@YNHMedia.com</a>
            </p>

			<!-- Column 2 end -->
		</div>
	</div>


</div>

    </div>
</div>


</div>


	  <?php

      function createUser($email)
      {
           $sql = "SELECT * FROM vols2012 WHERE email='$email'" ;

           $result = mysql_query( $sql ) ;

           if( mysql_num_rows( $result ) > 0 )
           {
       die( "There is already a user with that email!" ) ;
           }//end if


      function check_input($data, $problem='')
      {
          $data = trim($data);
          $data = stripslashes($data);
          $data = htmlspecialchars($data);
          if ($problem && strlen($data) == 0)
          {
              show_error($problem);
          }
          return $data;
      }

      function show_error($myError)
      {

      }

      ?>


    <div id="holding2">
<span class="error_text">
    <b><i>Please correct the following error:</i></b><br /><br />
   <?php echo $myError; ?></span><br /><br />
   <a style="#fe1e2d" href="#" onclick="history.go(-1);return false;"><span class="error_text2 font_orange">Click back on your browser or here to return to form</span></a>
</div>

<?php
exit();
}
?>