PHP form data not populating table

**kairick** · 06-30-2010, 06:44 PM

I need to populate user input on this 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>

**bluewalrus** · 06-30-2010, 06:56 PM

If you echo $sql; is the statement appearing as you'd expect it to (with the values)?

You also may want to use javascript for the validation that all fields are entered, but that's something else...

**kairick** · 06-30-2010, 08:43 PM

Thanks for responding.

Nothing's appearing at all. I originally had the form working to just send the confirmation emails and later added in the INSERT TO. The form is still behaving as though I never entered that extra code, so nothing is different.

**bluewalrus** · 07-01-2010, 02:10 AM

The blankness than is from an error(s) with your php. I've rewritten parts of your code and put in notes.

PHP 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']=="") {

 ?>

 <html>

 <body>

 <p>The following fields are <strong>required</strong>.</p>

 <ul>

 <?php

 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>"; }

?>

</ul>

<p>Please use your browsers <a href=\"javascript:history.back();\">Back</a> button and fill out these fields.</p>

</body>

</html>

<?php 

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'];

    $fax = $_POST['fax'];

//print $session; session is never set and you don't need to print it

    echo $selected_radio;// remove this if using header.

//} why close the if here? 

    $body = "From:$college\nStreet Address:$streetaddress\nCity:$city\nState:$state\nZip Code:$zip\nE-Mail:$contactemail\nPhone Number:$phone\nContact Email:$contactemail\nGISS Session:$selected_radio";

    mail($to, $subject, $body);

$sendto = $_POST['contactemail']; 

$ccto = "me@email.com"; 

$subject = "Registration"; 

$message = "Thank you for registering";

$header = "From: me@me.com";

// this is jambled are you trying to redirect them if the email is sent? this can't be achieved because you are echoing the selected radio and printing the posts above there are also missing brackets

//assuming you dont echo selected radio and print the posts though...

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 ('$college','$streetaddress','$city'$state','$zip','$contactperson','$contactemail','$phone','$fax','$selected_radio')";

if (!mysql_query($sql,$con)) {

    die('Error: ' . mysql_error());

}

mysql_close($con);

?>

1 record added

<?php

}

?>

<script type=text/javascript>

setTimeout("location.href='index.html'", [3000]);

</script>

**kairick** · 07-01-2010, 04:31 AM

Thanks for putting in the time to edit my code

The parts you noted for correction are functioning/were functioning fine (confirmation emails). I tried to remove/alter the options you suggested and got T_variable errors. It's the INSERT TO stuff that's not working. The form is sending correctly and confirmation emails are sending fine with the code I posted. I'm not getting any errors as-is. The table's just not populating.

**nextdownload** · 01-06-2011, 06:14 PM

Replace

Code:

$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]')";

with

Code:

$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]')";

Thread: PHP form data not populating table

Thread Tools

Search Thread

PHP form data not populating table

Bookmarks

Bookmarks

Posting Permissions