Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

The JED needs volunteers!

Form Will Not Save to DB

pj
pjwirth 02 Jun, 2008
When I complete my form, it is not saved to my DB. It it will email me when a form is submitted but the only thing the emailed results says is the IP of who filled it out.

http://www.marcellomonteiro.com/index.php?option=com_chronocontact&chronoformname=academygetstarted

Debug is turned on.

The database fields are created and viewable through phpMyAdmin

Here is the code for my form. 

  <table width="95%" border="0" cellspacing="0" cellpadding="2">
    <tr>
      <td width="24%">Name:</td>
      <td width="76%"><input type="text" name="name" id="name" /></td>
    </tr>
    <tr>
      <td>Age:</td>
      <td><input type="text" name="age" id="age" /></td>
    </tr>
    <tr>
      <td>Gender:</td>
      <td><select name="gender" id="gender">
        <option selected="selected">Select One</option>
        <option>Female</option>
        <option>Male</option>
      </select></td>
    </tr>
    <tr>
      <td>Country:</td>
      <td><select name="country" id="country">
        <option value="American Samoa">American Samoa</option>
        <option value="Argentina" >Argentina</option>
        <option value="Australia" >Australia</option>
        <option value="Austria" >Austria</option>
        <option value="Belgium" >Belgium</option>
        <option value="Botswana" >Botswana</option>
        <option value="Brazil" >Brazil</option>
        <option value="Bulgaria" >Bulgaria</option>
        <option value="Burkina" faso="faso" >Burkina Faso</option>
        <option value="Canada" >Canada</option>
        <option value="Chile" >Chile</option>
        <option value="China" >China, P.R.</option>
        <option value="Colombia" >Colombia</option>
        <option value="Croatia" >Croatia</option>
        <option value="Cuba" >Cuba</option>
        <option value="Curacao - Netherlands Antilles" >Curacao - Netherlands Antilles</option>
        <option value="Czech" >Czech Republic</option>
        <option value="Denmark" >Denmark</option>
        <option value="Egypt" >Egypt</option>
        <option value="Federated States of Micronesia"  >Federated States of Micronesia </option>
        <option value="Fiji" >Fiji</option>
        <option value="Finland" >Finland</option>
        <option value="France" >France</option>
        <option value="Germany" >Germany</option>
        <option value="Ghana" >Ghana</option>
        <option value="Greece" >Greece</option>
        <option value="Guatemala" >Guatemala</option>
        <option value="Hong Kong" >Hong Kong</option>
        <option value="Hungary" >Hungary</option>
        <option value="India" >India</option>
        <option value="Ireland" >Ireland</option>
        <option value="Israel" >Israel</option>
        <option value="Italy" >Italy</option>
        <option value="Japan" >Japan</option>
        <option value="Kenya" >Kenya</option>
        <option value="Korea" >Korea, Republic of</option>
        <option value="Lithuania" >Lithuania</option>
        <option value="Macedonia" >Macedonia</option>
        <option value="Malaysia" >Malaysia</option>
        <option value="Marshall Islands" >Marshall Islands </option>
        <option value="Mexico" >Mexico</option>
        <option value="Mongolia" >Mongolia</option>
        <option value="Morocco" >Morocco</option>
        <option value="Netherlands" >Netherlands</option>
        <option value="New Zealand" >New Zealand</option>
        <option value="Nigeria" >Nigeria</option>
        <option value="Norway" >Norway</option>
        <option value="Palau Islands" >Palau Islands </option>
        <option value="Papua New Guinea" >Papua New Guinea</option>
        <option value="Philippines" >Philippines</option>
        <option value="Poland" >Poland</option>
        <option value="Portugal" >Portugal</option>
        <option value="Romania" >Romania</option>
        <option value="Russia" >Russian Federation</option>
        <option value="Singapore" >Singapore</option>
        <option value="Slovakia" >Slovakia</option>
        <option value="South Africa" >South Africa</option>
        <option value="Spain" >Spain</option>
        <option value="Sri Lanka" >Sri Lanka</option>
        <option value="Sweden" >Sweden</option>
        <option value="Switzerland" >Switzerland</option>
        <option value="Tanzania" >Tanzania</option>
        <option value="Thailand" >Thailand</option>
        <option value="Turkey" >Turkey</option>
        <option value="United Kingdom" >United Kingdom</option>
        <option value="US Virgin Islands" >US Virgin Islands </option>
        <option value="USA"  selected="selected">United States of America</option>
        <option value="Uruguay" >Uruguay</option>
        <option value="West Indies" >West Indies</option>
        <option value="Yugoslavia" >Yugoslavia</option>
        <option value="Zambia" >Zambia</option>
        <option value="Zimbabwe" >Zimbabwe</option>
      </select></td>
    </tr>
    <tr>
      <td colspan="2"></td>
    </tr>
    <tr>
      <td>State:</td>
      <td><select name="state" id="state">
        <option>Select One</option>
        <option>Outside of USA</option>
        <option>AL</option>
        <option>AK</option>
        <option>AZ</option>
        <option>AR</option>
        <option>CA</option>
        <option>CO</option>
        <option>CT</option>
        <option>DE</option>
        <option>DC</option>
        <option>FL</option>
        <option>GA</option>
        <option>HI</option>
        <option>ID</option>
        <option>IL</option>
        <option>IN</option>
        <option>IA</option>
        <option>KS</option>
        <option>KY</option>
        <option>LA</option>
        <option>ME</option>
        <option>MD</option>
        <option>MA</option>
        <option>MI</option>
        <option>MN</option>
        <option>MS</option>
        <option>MO</option>
        <option>MT</option>
        <option>NE</option>
        <option>NV</option>
        <option>NH</option>
        <option>NJ</option>
        <option>NM</option>
        <option>NY</option>
        <option>NC</option>
        <option>ND</option>
        <option>OH</option>
        <option>OK</option>
        <option>OR</option>
        <option>PA</option>
        <option>RI</option>
        <option>SC</option>
        <option>SD</option>
        <option>TN</option>
        <option>TX</option>
        <option>UT</option>
        <option>VT</option>
        <option>VA</option>
        <option>WA</option>
        <option>WV</option>
        <option>WI</option>
        <option>WY</option>
      </select></td>
    </tr>
    <tr>
      <td>City:</td>
      <td><input type="text" name="city" id="city" /></td>
    </tr>
    <tr>
      <td>E-Mail:</td>
      <td><input type="text" name="email" id="email" /></td>
    </tr>
    <tr>
      <td>Phone:</td>
      <td><input type="text" name="phone" id="phone" /></td>
    </tr>
    <tr>
      <td>Best way of contacting you:</td>
      <td><select name="bestway" id="bestway">
        <option>Select One</option>
        <option>Phone</option>
        <option>E-Mail</option>
      </select></td>
    </tr>
    <tr>
      <td colspan="2"></td>
    </tr>
    <tr>
      <td>Best time to contact you:</td>
      <td><select name="besttime" id="besttime">
        <option selected="selected">Select One</option>
        <option>Day</option>
        <option>Evening</option>
      </select></td>
    </tr>
    <tr>
      <td colspan="2">      </td>
    </tr>
    <tr>
      <td valign="top"><p>What are your goals for joining at Marcello C. Monteiro Brazilian Jiu-Jitsu academy? </p>
      </td>
      <td><table width="95%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
            <input type="checkbox" name="goals" id="selfdefense" />
            Self-Defense</td>
        </tr>
        <tr>
          <td>
            <input type="checkbox" name="goals" id="getinshape" />
            Get in shape / work-out / have fun</td>
        </tr>
        <tr>
          <td>
            <input type="checkbox" name="goals" id="sport" />
            Sport / Competition</td>
        </tr>
        <tr>
          <td>
            <input type="checkbox" name="goals" id="other" />
            Other</td>
        </tr>
      </table></td>
    </tr>
    <tr>
      <td valign="top">If you select other please especify:</td>
      <td><textarea name="ifother" id="ifother" cols="45" rows="5"></textarea></td>
    </tr>
    <tr>
      <td valign="top">Where did you hear  about Marcello C. Monteiro Brazilian Jiu-Jitsu academy?      </td>
      <td><table width="95%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><table width="95%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td>
                <input type="checkbox" name="hear" id="wordofmouth" />
                Word Of Mouth</td>
            </tr>
            <tr>
              <td>
                <input type="checkbox" name="hear" id="internet" />
                Internet</td>
            </tr>
            <tr>
              <td>
                <input type="checkbox" name="hear" id="yellow" />
                Yellow Pages</td>
            </tr>
            <tr>
              <td>
                <input type="checkbox" name="hear" id="valpack" />
                Val Packs</td>
            </tr>
            <tr>
              <td>
                <input type="checkbox" name="hear" id="telepostsign" />
                Telephone Post Sign</td>
            </tr>
            <tr>
              <td>
                <input type="checkbox" name="hear" id="academy" />
                Academy Sign</td>
            </tr>
            <tr>
              <td>
                <input type="checkbox" name="hear" id="referral" />
                Referral</td>
            </tr>
            <tr>
              <td>
                <input type="checkbox" name="hear" id="ifother2" />
                Other</td>
            </tr>
          </table></td>
        </tr>

      </table></td>
    </tr>
    <tr>
      <td valign="top">If you select other please especify:</td>
      <td><textarea name="why2" id="why2" cols="45" rows="5"></textarea></td>
    </tr>
    <tr>
      <td>Martial Arts Experience
          
      </td>
      <td><select name="maexperience" id="maexperience">
        <option selected="selected">Select One</option>
        <option>None</option>
        <option>Beginner</option>
        <option>Intermediate</option>
        <option>Advanced</option>
      </select></td>
    </tr>
    <tr>
      <td>What Martial Arts Experience have you had:</td>
      <td><input type="text" name="whatmaexperience" id="whatmaexperience" /></td>
    </tr>
    <tr>
      <td>Any experience with Brazilian Jiu-Jitsu?
          
      </td>
      <td><select name="bjjexperience" id="bjjexperience">
        <option>Select one</option>
        <option>Yes</option>
        <option>No</option>
      </select></td>
    </tr>
    <tr>
      <td>Team</td>
      <td><input type="text" name="team" id="team" /></td>
    </tr>
    <tr>
      <td>Rank</td>
      <td><select name="rank" id="rank">
        <option selected="selected">Select One</option>
        <option>Not Ranked</option>
        <option>White</option>
        <option>Blue</option>
        <option>Purple</option>
        <option>Brown</option>
        <option>Black</option>
      </select></td>
    </tr>
    <tr>
      <td colspan="2"><strong>Comments?</strong></td>
    </tr>
    <tr>
      <td valign="top">Write your comments here:</td>
      <td><textarea name="comments" id="comments" cols="45" rows="5"></textarea></td>
    </tr>
    <tr>
      <td colspan="2">
        <input type="submit" name="submit" value="Submit" />
      </td>
    </tr>
  </table>
Gr
GreyHead 03 Jun, 2008
Hi pjwirth,

The form code looks OK. You will need array names for your checkboxes like 
name="check_box[]"
or you will only get the value of the last box checked.

I can't load your site at all at the moment. My guess is that you have 'email template' selected in the General tab but haven't defined a template in the Form Code tab.

Bob
pj
pjwirth 03 Jun, 2008
Thank you. My form is now emailing correctly but still will not save to my database. The fields in the database are still being created though, but no information entering into them. I can provide you backend access if need be.

Another quick question about the check boxes though. When I get my emails, all it returns is something like this

goals on, on, on

Is there a way to change it to be more descriptive then "on" or do I have to make a template?

Here is a snippet of my code 

<td valign="top"><p>What are your goals for joining at Marcello C. Monteiro Brazilian Jiu-Jitsu academy? </p>
      </td>
      <td><table width="95%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
            <input type="checkbox" name="goals[]" id="selfdefense" />
            Self-Defense</td>
        </tr>
        <tr>
          <td>
            <input type="checkbox" name="goals[]" id="getinshape" />
            Get in shape / work-out / have fun</td>
        </tr>
        <tr>
          <td>
            <input type="checkbox" name="goals[]" id="sport" />
            Sport / Competition</td>
        </tr>
        <tr>
          <td>
            <input type="checkbox" name="goals[]" id="other" />
            Other</td>
        </tr>
      </table>
Gr
GreyHead 04 Jun, 2008
Hi pjwirth,

Have you got a ReDirect URL set? There is a buggy version of chronocontact.php which causes problems if you do. There are several threads with teh fixed version.

For your checkboxes you need to add a value attribute:
<input type="checkbox" name="goals[]" id="other" value="other" />
Bob
pj
pjwirth 04 Jun, 2008
Bob,

Thank you very much for your help, everything works great now! Attached is a version of the new file for anyone who has the same problem and stumbles across my post.

Regards,

Perry

[file name=chronocontact_31b61995388673d6680229bf768cd79a.zip size=5739]http://www.chronoengine.com/images/fbfiles/files/chronocontact_31b61995388673d6680229bf768cd79a.zip[/file]
This topic is locked and no more replies can be posted.