Hello all! I have written a form and a form processor that takes all the visitors information and emails a confirmation to the user and emails the contents of the form to myself. I would like to take it one step further and insert the contents of the form into a database without losing any of the current functionality. I'm not sure where to get started?!? Below are the two files, form.php and form_process.php
FORM.PHP
<table width="785" border="0" align="left" cellpadding="1" cellspacing="0">
<tr>
<td width="782" height="939" bgcolor="#FFFFFF">
<form name="form" method="post" action="form_process.php" >
<p align="center"> </p>
<p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong></strong></font></p>
<p align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FF0000">*
</font>Full Name: <br>
<input name="UserName" type="text" >
</strong></font></p>
<p align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FF0000">*</font>
User Email: <br>
<input type="text" name="UserEmail">
</strong></font></p>
<p align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>
</strong></font></p>
<p align="left"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Company:<br>
<input name="Company" type="text" id="Company">
</font></strong></p>
<p align="left"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Discipline:
<br>
<select name="Discipline">
<option>Please select a Discipline
<option>Agricultural
<option>Analytical Chemistry
<option>Other
</select>
</font></strong></p>
<p align="left"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FF0000">*
</font></strong>Address: <br>
<input name="Address" type="text" id="Address4">
</font></strong></p>
<p align="left"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Address
2: <br>
<input name="Address2" type="text" id="Address22">
</font></strong></p>
<p align="left"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FF0000">*
</font></strong>City: <br>
<input name="City" type="text" id="City2">
</font></strong></p>
<p align="left"><b><font face=Verdana, arial, helvetica, sans-serif size=2>
</font><font face=Verdana, arial, helvetica, sans-serif size=2>State:
<br>
<select name=State select class=flipper2>
<option value= notselected>Select a State
<option value= Alabama>Alabama
<option value= Alaska> Alaska
<option value= Arizona>Arizona
<option value= Arkansas>Arkansas
<option value= Wisconsin>Wisconsin
<option value= Wyoming>Wyoming
</select>
</font></b></p>
<p align="left"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FF0000">*
</font></strong></font><font size="2" face="Verdana,">Zip Code: <br>
<input name="ZipCode" type="text" >
</font></b></p>
<p align="left"><b><font face=Verdana, arial, helvetica, sans-serif size=2>
</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FF0000">*</font></strong></font>
<font face=Verdana, arial, helvetica, sans-serif size=2>Country: <br>
<select name=Country class=flipper2 id="select" select>
<option value= blank>Select a Country
<option value=USA>United States of America
<option value=Algeria>Algeria
</select>
</font></b></p>
<p align="left"><b><font size="2" face="Verdana,">Phone: <br>
<input name="Phone" type="text" id="Phone2">
</font></b></p>
<p align="left"><b><font size="2" face="Verdana,">Fax: <br>
<input name="Fax" type="text" id="Fax2">
</font></b></p>
<p align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Please
add me to the mailing list: <br>
<input name="MailingList" type="checkbox">
</strong></font></p>
<p align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font></p>
<div align="left"><font color="#000000" size="2"><strong><font color="#FF0000">*</font>
denotes manadatory field</strong></font></div>
<p align="left">
<input type="submit" name="Submit" value="Submit">
</p>
</form>
<div align="left"></div></td>
<td width="1" bgcolor="#CCCCCC"></td>
</tr>
</table>
FORM_PROCESS.PHP
<?php require_once('Connections/form.php'); ?>
<?
{
require("../newsite/php/current/header.html");
}
?>
<?
$SiteName = "Mysite.com";
$SiteEmail = "my@emailaddress.com";
$ThankYouMessage = "Thank You ";
$SiteUserName = "Site Username";
$Error = "The following Error has occurred:";
?><head>
<TITLE>
<?php
?>
<?php echo $SiteName?> - Contact Us! </TITLE>
<table width="785" border="0" cellspacing="0" cellpadding="1">
<tr>
<td bgcolor="#FFFFFF"> <CENTER>
<p> </p>
<p><font face="Verdana, Arial, Helvetica, sans-serif" size="2"></p>
<p> </p>
<?php
/* Start Form Validation */
if($UserName =="") {
echo $Error;
echo '<br><font color="#FF0000">Please enter your Full Name.</font><br>' ;
}
/* next statement */
elseif($UserEmail == "") {
echo $Error;
echo '<br><font color="#FF0000">Please enter your Email Address. </font><br>' ;
}
/* next statement */
elseif($Address == "") {
echo $Error;
echo '<br><font color="#FF0000">Please enter your Address. </font><br>' ;
}
/* next statement */
elseif($City == "") {
echo $Error;
echo '<br><font color="#FF0000">Please enter your City. </font><br>' ;
}
/* next statement */
elseif($Country == 'blank') {
echo $Error;
echo '<br><font color="#FF0000">Please select a Country. </font><br>' ;
}
/* next statement */
elseif($Country == 'USA' AND $State == 'notselected') {
echo $Error;
echo '<br><font color="#FF0000">Please go back and select a State. </font><br>' ;
}
/* next statement */
elseif($Country == 'USA' AND $ZipCode == "") {
echo $Error;
echo '<br><font color="#FF0000">Please go back and enter your Zip Code. </font><br>' ;
}
else
{
echo '<font color="#FF0000">Thank you for registering with our site!</font><BR><BR>';
echo 'Your submission has been sent to: ';
echo $UserEmail;
echo ' as a confirmation email</b></font><b>. </b> </p>';
echo '</CENTER><b> ';
$UserMessage = "Message Line 1.\n";
$UserMessage .= "Message Line 2.\n";
$UserMessage .= "Message Line 3..\n ";
mail("$UserEmail", "$ThankYouMessage", $UserMessage, "From: $SiteEmail");
$AdminMessage = "$UserEmail, submitted the following information:\n\n";
$AdminMessage .= "User Name: $UserName\n\n";
$AdminMessage .= "Email Address: $UserEmail\n\n";
$AdminMessage .= "Discipline: $Discipline\n\n";
$AdminMessage .= "Address: $Address\n\n";
$AdminMessage .= "Address 2: $Address2\n\n";
$AdminMessage .= "City: $City\n\n";
$AdminMessage .= "State: $State\n\n";
$AdminMessage .= "Zip Code: $ZipCode\n\n";
$AdminMessage .= "Country: $Country\n\n";
$AdminMessage .= "Phone: $Phone\n\n";
$AdminMessage .= "Fax: $Fax\n\n";
$AdminMessage .= "Comments: $Comments\n\n";
$AdminMessage .= "Mailing List: $MailingList\n\n";
mail("$SiteEmail", "$SiteName - Literature Request", $AdminMessage, "From: $UserEmail");
}
?>
</b>
<td>
</tr>
</table>
<p>
</font>
Any help is greatly appreciated!
Thanks in advance,
bobII
