having php form data populate SQL database

**kairick** · 06-29-2010, 11:11 AM

Thanks to everyone who puts up with my occasionally stupid queries.

I have a form script that some of you may remember. I now need to populate user input on the form to a table, "registrations". I inserted some INSERT TO code (used w3c example as reference). I'm not getting any errors, but it's not populating the table with the information. INSERT TO code begins with $con below.

Code:

<?php
print_r($_POST);

{   
 if(($_POST['college']=="")||($_POST['streetaddress']=="")||($_POST['city']=="")||($_POST['zip']=="")||($_POST['state']=="")||($_POST['contactperson']=="")||($_POST['contactemail']=="")||($_POST['phone']=="")||($_POST['fax']=="")||($_POST['giss1']=="")||($_POST['giss2']==""))
 {
  echo "<html><body><p>The following fields are <strong>required</strong>.</p><ul>";
  if($_POST['college'] == ""){ echo "<li>*College</li>"; }
  if($_POST['streetaddress'] == ""){ echo "<li>*Street Address</li>"; }
  if($_POST['city'] == ""){ echo "<li>*City</li>"; }
  if($_POST['zip'] == ""){ echo "<li>*Zip</li>"; }
  if($_POST['state'] == ""){ echo "<li>*State</li>"; }
  if($_POST['contactperson'] == ""){ echo "<li>*Contact Person</li>"; }
  if($_POST['contactemail'] == ""){ echo "<li>*Contact Email</li>"; }
  if($_POST['phone'] == ""){ echo "<li>*Phone</li>"; }
  if($_POST['session'] == "unchecked") { echo "<li>You must select a GISS session</li>"; }
echo "</ul><p>Please use your browsers <a href=\"javascript:history.back();\">Back</a> button and fill out these fields.</p></body></html>";
 }
 
 if ($selected_radio == 'giss1') {
$giss1_status = 'checked';
}
else if ($selected_radio == 'giss2') {
$giss2_status = 'checked';
}
 
 if(isset($_POST['submit'])) {

    $to = "me@email.com"; 
    $subject = "Contact Has Registered";
    $college = $_POST['college'];
    $streetaddress = $_POST['streetaddress'];
    $city = $_POST['city'];
    $state = $_POST['state'];
	$zip = $_POST['zip'];
    $contactperson = $_POST['contactperson'];
    $contactemail = $_POST['contactemail'];
	$phone = $_POST['phone'];
$selected_radio = $_POST['session'];
print $session;
}    
    $body = "From:$college
    Street Address:$streetaddress
	City:$city
	State:$state
	Zip Code:$zip
    E-Mail:$contactemail
    Phone Number:$phone
    Contact Email:$contactemail
    GISS Session:$selected_radio";
    
    mail($to, $subject, $body);     

$sendto = $_POST['contactemail']; 
$ccto = "me@email.com"; 
$subject = "Registration"; 
$message = "Thank you for registering";

if(mail($sendto, $subject, $message, $header)) header("location: attendee.html"); 
} 

$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("registrations", $con);

$sql="INSERT INTO attendee_registrants (college, street_address, city, state, zip, contact_person, contact_email, phone, fax, session)
VALUES
('$_POST[college]','$_POST[streetaddress]','$_POST[city]'$_POST[state]','$_POST[zip]','$_POST[contactperson]','$_POST[contactemail]','$_POST[phone]','$_POST[fax]','$_POST[session]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)

?>
<script type=text/javascript>
setTimeout("location.href='index.html'", [3000]);
</script>

Thread: having php form data populate SQL database

Thread Tools

Search Thread

having php form data populate SQL database

Bookmarks

Bookmarks

Posting Permissions