Here is the code- no upload of the files: Registration FORM :
=================================================== Below =======================
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"
http://www.w3.org/TR...nsitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<title>MAC-Registration Form</title>
<link rel="stylesheet" type="text/css" href="../css/macreg.css" media="all">
<script type="text/javascript" src="../js/macreg.js"></script>
</script>
</head>
<body id="main_body">
<img id="top" src="top.png" alt="" name="top" />
<div id="form_container">
<h1><a>MAC Registration Form</a></h1>
<form id="form_545513" class="appnitro" method="post" action="RegSubmit.php">
<div class="form_description">
<h2>Swimmer Parent's Information</h2>
</div>
<ul >
<li id="li_1" >
<label class="description" for="element_1">Userid / Password </label>
</li>
<li id="li_2" >
<div class="left">
<input id="element_2" name="username" class="element text medium" type="text" maxlength="255" value=""/>
<label for="element_2">Userid</label>
</div>
<div class="right">
<input id="element_3" name="password" class="element text medium" type="password" maxlength="255" value=""/>
<label for="element_3">Password</label>
</div>
</li>
<li id="li_4" >
<label class="description" for="element_4">Swimmer Parent's Names</label>
<div class="left">
<span>
<input id="element_4_1" name= "mother_first_name" class="element text" maxlength="255" size="20" value=""/>
<label>Mother's First</label>
</span>
<span>
<input id="element_4_2" name= "mother_last_name" class="element text" maxlength="255" size="25" value=""/>
<label>Mother's Last</label>
</span>
</div>
<div class="right">
<span>
<input id="element_5_1" name= "father_first_name" class="element text" maxlength="255" size="20" value=""/>
<label>Father's First</label>
</span>
<span>
<input id="element_5_2" name= "father_last_name" class="element text" maxlength="255" size="25" value=""/>
<label>Father's Last</label>
</span>
</div>
</li>
<li id="li_6" >
<label class="description" for="element_6">Swimmer Parent's Emails </label>
<div class="left">
<input id="element_6" name="mother_email" class="element text medium" type="text" maxlength="255" value=""/>
<label for="element_6">Mother's Email</label>
</div>
<div class="right">
<input id="element_7" name="father_email" class="element text medium" type="text" maxlength="255" value=""/>
<label for="element_7">Father's Email</label>
</div>
</li>
<li id="li_8" >
<div class="left">
<label class="description" for="element_8">Swimmer Parent's Cell Phones </label>
<span>
<input id="element_8_1" name="element_8_1" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_8_1">(###)</label>
</span>
<span>
<input id="element_8_2" name="element_8_2" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_8_2">###</label>
</span>
<span>
<input id="element_8_3" name="element_8_3" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_8_3">####</label>
</span>
</div> <div></div>
<div class="right"></div>
<div class="right">
<span>
<input id="element_9_1" name="element_9_1" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_9_1">(###)</label>
</span>
<span>
<input id="element_9_2" name="element_9_2" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_9_2">###</label>
</span>
<span>
<input id="element_9_3" name="element_9_3" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_9_3">####</label>
</span>
</div>
</li>
<li id="li_10" >
<label class="description" for="element_10">Swimmer Parents Home Address </label>
<div>
<input id="element_10_1" name="address" class="element text large" value="" type="text">
<label for="element_10_1">Street Address</label>
</div>
<div>
<input id="element_10_2" name="element_10_2" class="element text large" value="" type="text">
<label for="element_10_2">Address Line 2</label>
</div>
<div class="left">
<input id="element_10_3" name="city" class="element text medium" value="" type="text">
<label for="element_10_3">City</label>
</div>
<div class="right">
<input id="element_10_4" name="state" class="element text medium" value="" type="text">
<label for="element_10_4">State / Province / Region</label>
</div>
<div class="left">
<input id="element_10_5" name="zip" class="element text medium" maxlength="15" value="" type="text">
<label for="element_10_5">Postal / Zip Code</label>
</div>
<select class="element select medium" id="element_10_6" name="element_9_6">
<option value="USA">USA</option>
</select>
<label for="element_10_6">Country</label>
</li>
<div></div>
<div class="form_description">
<h2>Swimmer's Information</h2>
</div>
<li id="li_11" >
<label class="description" for="element_11">Swimmer Name </label>
<span>
<input id="element_11_1" name= "swimmer_first_name" class="element text" maxlength="255" size="20" value=""/>
<label>First</label>
</span>
<span>
<input id="element_11_2" name= "swimmer_last_name" class="element text" maxlength="255" size="25" value=""/>
<label>Last</label>
</span>
<div class="right">
<span>
<input id="element_12_1" name="element_12_1" class="element text" size="2" maxlength="2" value="" type="text"> /
<label for="element_12_1">MM</label>
</span>
<span>
<input id="element_12_2" name="element_12_2" class="element text" size="2" maxlength="2" value="" type="text"> /
<label for="element_12_2">DD</label>
</span>
<span>
<input id="element_12_3" name="element_12_3" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_12_3">YYYY</label>
</span>
</div>
</li>
<li id="li_13" >
<label class="description" for="element_13">Permisson </label>
<span>
<input id="element_13_1" name="sal_reg_ok" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_13_1">Register with Suburban Aquatic League</label>
<input id="element_13_2" name="usa_reg_ok" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_13_3">Register with USA Swim</label>
<input id="element_13_3" name="pictures_ok" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_13_2">Picture of your swimmer</label>
</span>
<div class="right">
<select class="element select medium" id="element_13_4" name="Gender">
<option value="USA">Female</option>
<option value="USA">Male</option>
</select>
<label for="element_13_4">Gender</label>
</div>
</li>
<div></div>
<div class="form_description">
<h2>Swimmer's Emergency Contact Information</h2>
</div>
<li id="li_14" >
<label class="description" for="element_14">Emergency Contact Names </label>
<div class="left">
<span>
<input id="element_14_1" name= "element_14_1" class="element text" maxlength="255" size="20" value=""/>
<label>First</label>
</span>
<span>
<input id="element_14_2" name= "element_14_2" class="element text" maxlength="255" size="25" value=""/>
<label>Last</label>
</span>
</div>
<div class="right">
<span>
<input id="element_15_1" name= "element_15_1" class="element text" maxlength="255" size="20" value=""/>
<label>First</label>
</span>
<span>
<input id="element_15_2" name= "element_15_2" class="element text" maxlength="255" size="25" value=""/>
<label>Last</label>
</span>
</div>
</li>
<li id="li_16" >
<label class="description" for="element_16">Emergency Contact Phone Numbers </label>
<div class="left">
<span>
<input id="element_16_1" name="element_16_1" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_16_1">(###)</label>
</span>
<span>
<input id="element_16_2" name="element_16_2" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_16_2">###</label>
</span>
<span>
<input id="element_16_3" name="element_16_3" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_16_3">####</label>
</span>
</div>
<div class="right">
<span>
<input id="element_17_1" name="element_17_1" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_17_1">(###)</label>
</span>
<span>
<input id="element_17_2" name="element_17_2" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_17_2">###</label>
</span>
<span>
<input id="element_17_3" name="element_17_3" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_17_3">####</label>
</span>
</div>
</li>
<li id="li_18" >
<label class="description" for="element_18">Contact Relationship</label>
<div class="left">
<input id="element_18" name="emergency_relation1" class="element text medium" type="text" maxlength="255" value=""/>
</div>
<div class="right">
<input id="element_19" name="emergency_relation2" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li>
<div></div>
<div class="form_description">
<h2>Emergency Medical Information</h2>
</div>
<li id="li_11" >
<label class="description" for="element_11">Medical Policy Carrier </label>
<div>
<input id="element_11" name="medical_carrier" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li>
<li id="li_14" >
<label class="description" for="element_14">Medical Policy Number</label>
<div>
<input id="element_14" name="medical_policy" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li>
<li id="li_22" >
<label class="description" for="element_22">Medical Doctor's Name </label>
<div>
<input id="element_22" name="medical_doctor" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li>
<li id="li_23" >
<label class="description" for="element_23">Medical Doctor's Phone </label>
<span>
<input id="element_23_1" name="element_23_1" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_23_1">(###)</label>
</span>
<span>
<input id="element_23_2" name="element_23_2" class="element text" size="3" maxlength="3" value="" type="text"> -
<label for="element_23_2">###</label>
</span>
<span>
<input id="element_23_3" name="element_23_3" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_23_3">####</label>
</span>
</li>
<li id="li_24" >
<label class="description" for="element_24">Medical Hospital </label>
<div>
<input id="element_24" name="medical_hospital" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li>
<li id="li_25" >
<label class="description" for="element_25">Medical Conditions </label>
<div>
<textarea id="element_25" name="medical_conditions" class="element textarea medium"></textarea>
</div>
</li>
<li class="buttons">
<input type="hidden" name="form_id" value="545513" />
<input id="saveForm" class="button_text" type="submit" name="submit" value="Submit" />
</li>
</ul>
</form>
</div>
<img id="bottom" src="bottom.png" alt="" name="bottom" />
</body>
</html>
Here is the code- added form to database : RegSubmit.php from hell :
=================================================== Below =======================
include ("incecho.php");
include ("RegVariables.php");
include ("incecho2.php");
/* Database Connect */
include ("RegConnect.php");
/* Query for Parents record in database*/
include ("RegQueryParents.php");
/* Database Insert for Parents*/
include ("RegInsertParents.php");
/* Database Update for Parents*/
include ("RegUpdateParents.php");
/* Database Insert for Swimmers*/
include ("RegInsertSwimmer.php");
/* Database Insert for Medical*/
include ("RegInsertMedical.php");
mysql_free_result($result);
=========================================================================
The Echo includes are not getting fired off.
include ("incecho.php"); - echos all form entries
include ("RegVariables.php"); - Move all form entries to variables ( no validation yet )
include ("incecho2.php"); - Echo movement of the new variables
/* Database Connect */
include ("RegConnect.php"); - standard connect to database
/* Query for Parents record in database*/
include ("RegQueryParents.php"); - standard query for main table to check for parent ID (used in other tables) checking user name if already registered
/* Database Insert for Parents*/
include ("RegInsertParents.php"); - No ID - do insert
/* Database Update for Parents*/
include ("RegUpdateParents.php"); - If ID present than update information that is new
/* Database Insert for Swimmers*/
include ("RegInsertSwimmer.php"); - simple insert no validate yet
/* Database Insert for Medical*/
include ("RegInsertMedical.php") - simple insert no validate yet
I will include echo files below to test on your side.
======================================================================
echo 1
<?php
echo " " . $_POST['username'] ."<br>";
echo " " . $_POST['password'] ."<br>";
echo " " . $_POST['mother_first_name'] ."<br>";
echo " " . $_POST['mother_last_name'] ."<br>";
echo " " . $_POST['father_first_name'] ."<br>";
echo " " . $_POST['father_last_name'] ."<br>";
echo " " . $_POST['mother_email'] ."<br>";
echo " " . $_POST['father_email'] ."<br>";
echo " " . $_POST['element_8_1'] ."<br>";
echo " " . $_POST['element_8_2'] ."<br>";
echo " " . $_POST['element_8_3'] ."<br>";
echo " " . $_POST['element_9_1'] ."<br>";
echo " " . $_POST['element_9_2'] ."<br>";
echo " " . $_POST['element_9_3'] ."<br>";
echo " " . $_POST['address'] ."<br>";
echo " " . $_POST['element_10_2'] ."<br>";
echo " " . $_POST['city'] ."<br>";
echo " " . $_POST['state'] ."<br>";
echo " " . $_POST['zip'] ."<br>";
echo " " . $_POST['swimmer_first_name'] ."<br>";
echo " " . $_POST['swimmer_last_name'] ."<br>";
echo " " . $_POST['element_12_1'] ."<br>";
echo " " . $_POST['element_12_2'] ."<br>";
echo " " . $_POST['element_12_3'] ."<br>";
echo " " . $_POST['sal_reg_ok'] ."<br>";
echo " " . $_POST['usa_reg_ok'] ."<br>";
echo " " . $_POST['pictures_ok'] ."<br>";
echo " " . $_POST['element_14_1'] ."<br>";
echo " " . $_POST['element_14_2'] ."<br>";
echo " " . $_POST['element_15_1'] ."<br>";
echo " " . $_POST['element_15_2'] ."<br>";
echo " " . $_POST['element_16_1'] ."<br>";
echo " " . $_POST['element_16_2'] ."<br>";
echo " " . $_POST['element_16_3'] ."<br>";
echo " " . $_POST['element_17_1'] ."<br>";
echo " " . $_POST['element_17_2'] ."<br>";
echo " " . $_POST['element_17_3'] ."<br>";
echo " " . $_POST['emergency_relation1'] ."<br>";
echo " " . $_POST['emergency_relation2'] ."<br>";
echo " " . $_POST['medical_carrier'] ."<br>";
echo " " . $_POST['medical_policy'] ."<br>";
echo " " . $_POST['medical_doctor'] ."<br>";
echo " " . $_POST['element_23_1'] ."<br>";
echo " " . $_POST['element_23_2'] ."<br>";
echo " " . $_POST['element_23_3'] ."<br>";
echo " " . $_POST['medical_hospital'] ."<br>";
?>
====================================================================
<?php
echo " " . $username ."<br>";
echo " " . $password ."<br>";
echo " " . $mother_first_name ."<br>";
echo " " . $mother_last_name ."<br>";
echo " " . $father_first_name ."<br>";
echo " " . $father_last_name ."<br>";
echo " " . $mother_email ."<br>";
echo " " . $father_email ."<br>";
echo " " . $element_8_1 ."<br>";
echo " " . $element_8_2 ."<br>";
echo " " . $element_8_3 ."<br>";
echo " " . $element_9_1 ."<br>";
echo " " . $element_9_2 ."<br>";
echo " " . $element_9_3 ."<br>";
echo " " . $address ."<br>";
echo " " . $element_10_2 ."<br>";
echo " " . $city ."<br>";
echo " " . $state ."<br>";
echo " " . $zip ."<br>";
echo " " . $swimmer_first_name ."<br>";
echo " " . $swimmer_last_name ."<br>";
echo " " . $element_12_1 ."<br>";
echo " " . $element_12_2 ."<br>";
echo " " . $element_12_3 ."<br>";
echo " " . $sal_reg_ok ."<br>";
echo " " . $usa_reg_ok ."<br>";
echo " " . $pictures_ok ."<br>";
echo " " . $element_14_1 ."<br>";
echo " " . $element_14_2 ."<br>";
echo " " . $element_15_1 ."<br>";
echo " " . $element_15_2 ."<br>";
echo " " . $element_16_1 ."<br>";
echo " " . $element_16_2 ."<br>";
echo " " . $element_16_3 ."<br>";
echo " " . $element_17_1 ."<br>";
echo " " . $element_17_2 ."<br>";
echo " " . $element_17_3 ."<br>";
echo " " . $emergency_relation1 ."<br>";
echo " " . $emergency_relation2 ."<br>";
echo " " . $medical_carrier ."<br>";
echo " " . $medical_policy ."<br>";
echo " " . $medical_doctor ."<br>";
echo " " . $element_23_1 ."<br>";
echo " " . $element_23_2 ."<br>";
echo " " . $element_23_3 ."<br>";
echo " " . $medical_hospital ."<br>";
?>
=
================================================================================
variables
=====================
<?php
$username = $_POST['username'];
$password = $_POST['password'];
$mother_first_name = $_POST['mother_first_name'];
$mother_last_name = $_POST['mother_last_name'];
$father_first_name = $_POST['father_first_name'];
$father_last_name = $_POST['father_last_name'];
$mother_email = $_POST['mother_email'];
$father_email = $_POST['father_email'];
$element_8_1 = $_POST['element_8_1'];
$element_8_2 = $_POST['element_8_2'];
$element_8_3 = $_POST['element_8_3'];
$element_9_1 = $_POST['element_9_1'];
$element_9_2 = $_POST['element_9_2'];
$element_9_3 = $_POST['element_9_3'];
$address = $_POST['address'];
$element_10_2 = $_POST['element_10_2'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$swimmer_first_name = $_POST['swimmer_first_name'];
$swimmer_last_name = $_POST['swimmer_last_name'];
$element_12_1 = $_POST['element_12_1'];
$element_12_2 = $_POST['element_12_2'];
$element_12_3 = $_POST['element_12_3'];
$sal_reg_ok = $_POST['sal_reg_ok'];
$usa_reg_ok = $_POST['usa_reg_ok'];
$pictures_ok = $_POST['pictures_ok'];
$gender = $_POST['gender'];
$element_14_1 = $_POST['element_14_1'];
$element_14_2 = $_POST['element_14_2'];
$element_15_1 = $_POST['element_15_1'];
$element_15_2 = $_POST['element_15_2'];
$element_16_1 = $_POST['element_16_1'];
$element_16_2 = $_POST['element_16_2'];
$element_16_3 = $_POST['element_16_3'];
$element_17_1 = $_POST['element_17_1'];
$element_17_2 = $_POST['element_17_2'];
$element_17_3 = $_POST['element_17_3'];
$emergency_relation1 = $_POST['emergency_relation1'];
$emergency_relation2 = $_POST['emergency_relation2'];
$medical_carrier = $_POST['medical_carrier'];
$medical_policy = $_POST['medical_policy'];
$medical_doctor = $_POST['medical_doctor'];
$element_23_1 = $_POST['element_23_1'];
$element_23_2 = $_POST['element_23_2'];
$element_23_3 = $_POST['element_23_3'];
$medical_hospital = $_POST['medical_hospital'];
$medical_conditions = $_POST['medical_conditions'];
?>