pls help.form not saving to database.

Question

lwaterfo 0 Light Poster

14 Years Ago

HI,
I have a form with a huge textarea field and I am not sure how to format the textarea to make it work with php. The small textfields seem to work fine with adding information to my database, but as soon aas I add dropdown menus, a large textarea, radio buttons and check boxes, the database is not being updated.

Here is my html form code. I hope someone can help..:)

<form action="process.php" method="POST">
  <table width="200" border="0">
  <tr>
    <td>Fields with a <span class="req">*</span> are required.</td>
  </tr>
</table>
<p>
  <input type="hidden" name="recipient" value="xx"> 
  <input type="hidden" name="subject" value="resume"> 
  <input type="hidden" name="redirect" value="thankyou.html">
</p>
<table width="604" border="0">
  <tr>
    <td width="265"><span class="style2"><strong>Primary E-mail: </strong></span><span class="req"><strong>*</strong></span></td>
    <td width="329"><span id="sprytextfield1">
      <input type="text" name="E_mail" id="E_mail" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>First Name: </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield2">
      <input type="text" name="First_Name" id="First_Name" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>Last Name: </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield3">
      <input type="text" name="Last_Name" id="Last_Name" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>Street Address (1): </strong></span><span class="req"><strong>*</strong></span></td>
	<td><span id="sprytextfield5">
	<input name="Address1" type="text" id="Address1" size="30" maxlength="30" />
	<span class="textfieldRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>Street Address (2): </strong></span></td>
    <td>
	<input name="Address2" type="text" id="Address2" size="30" maxlength="30" /></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>State:</strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield6">
	<input name="state" type="text" id="state" size="2" maxlength="2" />
	<span class="textfieldRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>Zip: </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield7">
	<input name="zip" type="text" id="zip" size="5" maxlength="5" />
	<span class="textfieldRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>Primary Phone (no dashes): </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield4">
      <input name="Primary_Phone" type="text" id="Primary_Phone" size="10" maxlength="10" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>Secondary Phone: </strong></span></td>
    <td><input name="Secondary_Phone" type="text" id="Secondary_Phone" size="10" maxlength="10" /></td>
  </tr>
  <tr>
    <td height="41"><span class="style2"><strong>How did you find us?</strong></span><span class="req"><strong> *</strong></span></td>
    <td><span id="spryselect1">
      <select name="Advertising" id="Advertising">
        <option>Please Select</option>
        <option value="Craigslist">Craigslist</option>
        <option value="Monster">Monster</option>
        <option value="Careerbuilder">Careerbuilder</option>
        <option value="Print Advertisement">Print Advertisement</option>
        <option value="Corporation">Corporation</option>
        <option value="Other">Other</option>
      </select>
    </span></td>
    </tr>
  <tr>
    <td valign="top"><span class="style2"><strong>What type(s) of job(s) are you interested in? </strong></span> (To select more than one, press Ctrl)</td>
    <td><span id="spryselect2">
      <select name="Job_Type" size="6" multiple="multiple" id="Job_Type">
        <option value="Scientific/Lab/Research">Scientific Lab Research</option>
        <option value="Health Care/Medical/Information Systems">Health Care Medical Information Systems</option>
		<option value="Health Care/Medical/Pharmaceutical">Health Care Medical Pharmaceutical</option>
		<option value="Health Care/Medical Billing and Coding">Health Care Medical Billing and Coding</option>
        <option value="Computer Programming">Computer Programming</option>
        <option value="Computer Web Design">Computer Web Design</option>
		<option value="Computer Database Management Systems">Computer Database Management Systems</option>
        <option value="Office Secretarial">Office Secretarial</option>
        <option value="Office Data Entry">Office Data Entry</option>
		<option value="Real Estate">Real Estate</option>
		<option value="Accounting">Accounting</option>
		<option value="Hospitality/Tourism">Hospitality Tourism</option>
		<option value="Other">Other</option>
      </select>
      <span class="selectRequiredMsg">Please select an item.</span></span></td>
  </tr>
  <tr>
    <td height="50" valign="top">&nbsp;</td>
    <td valign="top"><p>
      <input name="other_jobtype" type="text" id="other_jobtype" value="If other, please type here." size="30" />
    </p>      </td>
    </tr>
  <tr>
    <td height="45" valign="top"><span class="style2"><strong>Can You Work Weekends?:</strong></span><span class="req"><strong> *</strong></span></td>
    <td><span id="spryradio1">
      <label>
        <input type="radio" name="Weekend_Availability" value="yes" id="Weekend_Availability" />
        Yes</label>
      <br />
      <label>
        <input type="radio" name="Weekend_Availability" value="no" id="Weekend_Availability" />
        No</label>
      <br />
      <span class="radioRequiredMsg">Please make a selection.</span></span></td>
    </tr>
  <tr>
    <td height="45" valign="top"><span class="style2"><strong>Can You Work Overnight?:</strong></span><span class="req"><strong> *</strong></span></td>
    <td><label>
      <input type="radio" name="Night_Availability" value="yes" id="Night_Availability" />
Yes</label>
      <br />
      <label>
      <input type="radio" name="Night_Availability" value="no" id="Night_Availability" />
No</label>
      <br />
      <span class="radioRequiredMsg">Please make a selection.</span></td>
  </tr>
  <tr>
    <td height="65" valign="top"><span class="style2"><strong>Preferred Shift:</strong></span><span class="req"><strong> *</strong></span></td>
    <td align="right"><span id="spryradio2">
      <label>
        <div align="left">
          <input type="radio" name="Shift" value="PT" id="Shift" />
          Part Time
        <div align="left">
          <input type="radio" name="Shift" value="FT" id="Shift" />
          Full Time</div>
      </label>
      <br />
      <span class="radioRequiredMsg">Please make a selection.</span></div>
    </span></td>
  </tr>
  <tr>
    <td height="139" colspan="2" valign="top"><p><span class="style2"><strong>Days Availabile <span class="style4">(check all that apply)</span>:</strong></span><span class="req"><strong> *</strong></span></p>
      <table width="238" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="125"><div align="right">Monday
            <input name="Monday[]" type="checkbox" id="Monday" value="yes" />
          </div></td>
          <td width="113"><div align="right">Friday
            <input name="Friday[]" type="checkbox" id="Friday" value="yes" />
          </div></td>
          </tr>
        <tr>
          <td><div align="right">Tuesday
            <input name="Tuesday[]" type="checkbox" id="Tuesday" value="yes" />
          </div></td>
          <td><div align="right">Saturday
            <input name="Saturday[]" type="checkbox" id="Saturday" value="yes" />
          </div></td>
          </tr>
        <tr>
          <td><div align="right">Wednesday
            <input name="Wednesday[]" type="checkbox" id="Wednesday" value="yes" />
          </div></td>
          <td><div align="right">Sunday
            <input name="Sunday[]" type="checkbox" id="Sunday" value="yes" />
          </div></td>
          </tr>
        <tr>
          <td><div align="right">Thursday
            <input name="Thursday[]" type="checkbox" id="Thursday" value="yes" />
          </div></td>
          <td>&nbsp;</td>
          </tr>
      </table></td>
    </tr>
  <tr>
    <td height="154" valign="top"><span class="style2"><strong>Your Career Objective (copy and paste):</strong></span><span class="req"><strong> *</strong></span></td>
    <td height="154" valign="top"><span id="sprytextarea2">
	<textarea name="objective" cols="60" rows="10" wrap="physical" id="objective">Please specifiy your career goal(s) and objective(s) shere.</textarea>
	<span class="textareaRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td height="31" valign="top"><span class="style2"><strong>Your CV/Resume (copy and paste):</strong></span><span class="req"><strong> *</strong></span></td>
    <td align="right"><div align="left"><span id="sprytextarea1">
      <textarea name="Resume" cols="60" rows="20" wrap="physical" id="Resume">Please include all past jobs, education and skills that attribute to your selected job type.</textarea>
      <span class="textareaRequiredMsg">A value is required.</span></span></div></td>
  </tr>
  <tr>
    <td height="31" valign="top">&nbsp;</td>
    <td align="right"><input name="Submit" type="submit" onclick="MM_validateForm('E_mail','','RisEmail','First_Name','','R','Last_Name','','R','Primary_Phone','','NisNum','Resume','','R');MM_validateForm('Address1','','R');return document.MM_returnValue" value="Submit" /></td>
  </tr>
  <tr>
    <td height="31" valign="top">&nbsp;</td>
    <blockquote>&nbsp;			</blockquote>
    <td align="right">&nbsp;</td>
  </tr>
  <tr>
    <td height="31" valign="top">&nbsp;</td>
    <td align="right">&nbsp;</td>
  </tr>
</table>
</form>

.

php

2 Contributors
2 Replies
90 Views
10 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by lwaterfo

Lsmjudoka 0 Junior Poster in Training

14 Years Ago

Where is your PHP code?

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

lwaterfo 0 Light Poster · Answer 1 · 2010-08-01T06:54:52+00:00

Hi,
Heres my php code. i took out the two radio buttons called weekend_availability, night_availability and shift. The new html code is below the php code. ...

<? $firstname=$_POST['First_Name']; $email=$_POST['E_mail']; $lastname=$_POST['Last_Name']; $address=$_POST['Address1']; $addressii=$_POST['Address2']; 
$state=$_POST['state']; $zip=$_POST['zip']; $phone=$_POST['Primary_Phone']; $phoneii=$_POST['Secondary_Phone']; $advertising=$_POST['Advertising'];  $jobtype=$_POST['Job_Type']; $otherjobtype=$_POST['other_jobtype']; $mon=$_POST['Monday[]']; $tues=$_POST['Tuesday[]']; $wed=$_POST['Wednesday[]']; $thurs=$_POST['Thursday[]']; $fri=$_POST['Friday[]']; $sat=$_POST['Saturday[]']; $sun=$_POST['Sunday[]']; $objective=$_POST['objective']; $resume=$_POST['Resume']; mysql_connect("localhost", "waterxx_admin", "xxxxxxx") or die(mysql_error()); mysql_select_db("waterfor_app1") or die(mysql_error ()); mysql_query("INSERT INTO `data` VALUES ('$firstname', '$email', '$lastname', '$address', '$addressii', '$state','$zip', '$phone', '$phoneii', '$advertising','$jobtype','$otherjobtype','$mon', '$tues', '$wed', '$thurs', '$fri','$sat', '$sun', '$objective', '$resume')"); Print "Your information has been successfully added to the database."; ?>

html form:

<form action="process.php" method="POST">
  <table width="200" border="0">
  <tr>
    <td>Fields with a <span class="req">*</span> are required.</td>
  </tr>
</table>
<p>
  <input type="hidden" name="recipient" value="admin@mydomain.com"> 
  <input type="hidden" name="subject" value="resume"> 
  <input type="hidden" name="redirect" value="thankyou.html">
</p>
<table width="604" border="0">
  <tr>
    <td width="265"><span class="style2"><strong>Primary E-mail: </strong></span><span class="req"><strong>*</strong></span></td>
    <td width="329"><span id="sprytextfield1">
      <input type="text" name="E_mail" id="E_mail" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>First Name: </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield2">
      <input type="text" name="First_Name" id="First_Name" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>Last Name: </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield3">
      <input type="text" name="Last_Name" id="Last_Name" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>Street Address (1): </strong></span><span class="req"><strong>*</strong></span></td>
	<td><span id="sprytextfield5">
	<input name="Address1" type="text" id="Address1" size="30" maxlength="30" />
	<span class="textfieldRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>Street Address (2): </strong></span></td>
    <td>
	<input name="Address2" type="text" id="Address2" size="30" maxlength="30" /></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>State:</strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield6">
	<input name="state" type="text" id="state" size="2" maxlength="2" />
	<span class="textfieldRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>Zip: </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield7">
	<input name="zip" type="text" id="zip" size="5" maxlength="5" />
	<span class="textfieldRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td><span class="style2"><strong>Primary Phone (no dashes): </strong></span><span class="req"><strong>*</strong></span></td>
    <td><span id="sprytextfield4">
      <input name="Primary_Phone" type="text" id="Primary_Phone" size="10" maxlength="10" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></td>
    </tr>
  <tr>
    <td><span class="style2"><strong>Secondary Phone: </strong></span></td>
    <td><input name="Secondary_Phone" type="text" id="Secondary_Phone" size="10" maxlength="10" /></td>
  </tr>
  <tr>
    <td height="41"><span class="style2"><strong>How did you find us?</strong></span><span class="req"><strong> *</strong></span></td>
    <td><span id="spryselect1">
      <select name="Advertising" id="Advertising">
        <option>Please Select</option>
        <option value="Craigslist">Craigslist</option>
        <option value="Monster">Monster</option>
        <option value="Careerbuilder">Careerbuilder</option>
        <option value="Print Advertisement">Print Advertisement</option>
        <option value="Corporation">Corporation</option>
        <option value="Other">Other</option>
      </select>
    </span></td>
    </tr>
  <tr>
    <td valign="top"><span class="style2"><strong>What type(s) of job(s) are you interested in? </strong></span> (To select more than one, press Ctrl)</td>
    <td><span id="spryselect2">
      <select name="Job_Type" size="6" multiple="multiple" id="Job_Type">
        <option value="Scientific/Lab/Research">Scientific/Lab/Research</option>
        <option value="Health Care/Medical/Information Systems">Health Care/Medical/Information Systems</option>
		<option value="Health Care/Medical/Pharmaceutical">Health Care/Medical/Pharmaceutical</option>
		<option value="Health Care/Medical Billing and Coding">Health Care/Medical Billing and Coding</option>
        <option value="Computer Programming">Computer Programming</option>
        <option value="Computer Web Design">Computer Web Design</option>
		<option value="Computer Database Management Systems">Computer Database Management Systems</option>
        <option value="Office Secretarial">Office Secretarial</option>
        <option value="Office Data Entry">Office Data Entry</option>
		<option value="Real Estate">Real Estate</option>
		<option value="Accounting">Accounting</option>
		<option value="Hospitality/Tourism">Hospitality/Tourism</option>
		<option value="Other">Other</option>
      </select>
      <span class="selectRequiredMsg">Please select an item.</span></span></td>
  </tr>
  <tr>
    <td height="50" valign="top">&nbsp;</td>
    <td valign="top"><p>
      <input name="other_jobtype" type="text" id="other_jobtype" value="If other, please type here." />
    </p>      </td>
    </tr>
  
  <tr>
    <td height="45" valign="top"><span class="style2"><strong>Can You Work Overnight?:</strong></span><span class="req"><strong> *</strong></span></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td height="65" valign="top"><span class="style2"><strong>Preferred Shift:</strong></span><span class="req"><strong> *</strong></span></td>
    <td align="right">&nbsp;</td>
  </tr>
  <tr>
    <td height="154" colspan="2" valign="top"><p><span class="style2"><strong>Days Availabile <span class="style4">(check all that apply)</span>:</strong></span><span class="req"><strong> *</strong></span></p>
      <table width="238" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="125"><div align="right">Monday
            <input name="Monday[]" type="checkbox" id="Monday[]" value="Monday" />
          </div></td>
          <td width="113"><div align="right">Friday
            <input name="Friday[]" type="checkbox" id="Friday[]" value="Friday" />
          </div></td>
          </tr>
        <tr>
          <td><div align="right">Tuesday
            <input name="Tuesday[]" type="checkbox" id="Tuesday[]" value="Tuesday" />
          </div></td>
          <td><div align="right">Saturday
            <input name="Saturday[]" type="checkbox" id="Saturday[]" value="Saturday" />
          </div></td>
          </tr>
        <tr>
          <td><div align="right">Wednesday
            <input name="Wednesday[]" type="checkbox" id="Wednesday[]" value="Wednesday" />
          </div></td>
          <td><div align="right">Sunday
            <input name="Sunday" type="checkbox" id="Sunday" value="Sunday[]" />
          </div></td>
          </tr>
        <tr>
          <td><div align="right">Thursday
            <input name="Thursday[]" type="checkbox" id="Thursday[]" value="Wednesday" />
          </div></td>
          <td>&nbsp;</td>
          </tr>
      </table></td>
    </tr>
  <tr>
    <td height="154" valign="top"><span class="style2"><strong>Your Career Objective (copy and paste):</strong></span><span class="req"><strong> *</strong></span></td>
    <td height="154" valign="top"><span id="sprytextarea2">
	<textarea name="objective" cols="60" rows="15" id="objective">Please specifiy your career goal and objective here.</textarea>
	<span class="textareaRequiredMsg">A value is required.</span></span></td>
  </tr>
  <tr>
    <td height="31" valign="top"><span class="style2"><strong>Your CV/Resume (copy and paste):</strong></span><span class="req"><strong> *</strong></span></td>
    <td align="right"><div align="left"><span id="sprytextarea1">
      <textarea name="Resume" id="Resume" cols="60" rows="20">Please include all past jobs, education and skills that attribute to your selected job type.</textarea>
      <span class="textareaRequiredMsg">A value is required.</span></span></div></td>
  </tr>
  <tr>
    <td height="31" valign="top">&nbsp;</td>
    <td align="right"><input name="Submit" type="submit" onclick="MM_validateForm('E_mail','','RisEmail','First_Name','','R','Last_Name','','R','Primary_Phone','','NisNum','Resume','','R');MM_validateForm('Address1','','R');return document.MM_returnValue" value="Submit" />