Form data not saved

Ph

Phil91 17 Jul, 2009

Hello again,

Everything ok so far...Just figured one thing when associating a data table to my form: (I actually don't need this but I tried to see what the result was)

All "default" fields such as id etc... get written, but all my form fields (name, address etc...) don't get there...

I wonder if this is because I use the confirmation plugin or not....Browsing the forum, it looks like nobody really has this problem, so I wonder if I missed some kind of a "checked" checkbox to activate transfer to the DB or if the confirmation plugin somehow does skip one step or else...

Again, no sweat...Just to understand...

Philippe

Gr

GreyHead 17 Jul, 2009

Hi Philippe,

Are the columns in the database table (it's easy to create a table with only the default fields and none of the form fields)?

Do the field names match the column names exactly?

Do any of the field names include spaces, start with a number, or include any special characters other than _ ?

Bob

Ph

Phil91 17 Jul, 2009

Hi Bob,

Yes, they are in the database table.
Yes they exactly match the column names. Created the fields automatically from the CF setup page.
Yes they are exactly what the form code field names are, without spaces or unwanted chars...Just like txtName,txtEMail,txtPhone etc...

?

Phil

Ph

Phil91 18 Jul, 2009

Bob,

Did some more tests using my second site: turns out that the second uses CF WITHOUT the confirmation plugin...Just redirects to a thank you URL and sends the email...Well, this one sends data to the table, which leads me to think that the plugin kind of bypasses the data storage in the database...
I'll try to dig into the code to see what happens...

Philippe

Gr

GreyHead 19 Jul, 2009

Hi Philippe,

Hmmm . . . I've just taken a look at the Confirmation Page plugin and it looks as though it replicates all the OnSubmit code from ChronoForms - so I guess that there might be a bug in there. There are certainly section that *should* execute the Autogenerated Code and save the data.

The logical next step is probably to try adding debugging code to the plugin to see what is actually happening . . .

Bob

Max_admin 19 Jul, 2009

Hi Philippe,

Please show us your form code or even a sample so I can test it!

Regards,
Max

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

Ph

Phil91 20 Jul, 2009

Hi Max and Bob,

The form can be accessed at http://www.clubchevry2.com/preinscr
Thanks for looking at it...

Philippe

Here's the form code


<div class="form_item">
  <div class="form_element cf_heading">
    <h1 class="cf_text">Formulaire de préinscription 2009-2010 au Club Chevry</h1>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">NOTA : Ce formulaire de pré-inscription est transmis aux responsables de sections qui valideront la procédure à suivre pour l'inscription définitive dans la mesure des places disponibles selon leurs propres modalités....</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Merci de renseigner obligatoirement les champs en rouge suivis d'un astérisque</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px; color: red;"><b>Nom (*)</b></label>
    <input class="cf_inputbox required" maxlength="150" size="50" title="Merci de renseigner votre nom" id="text_4" name="txtNom" type="text" />
  <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
<div class="tooltipdiv">Nom :: Information obligatoire</div>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px; color: red"><b>Prénom (*)</b></label>
    <input class="cf_inputbox required" maxlength="150" size="50" title="Merci de renseigner votre prénom" id="text_5" name="txtPrenom" type="text" />
  <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
  <div class="tooltipdiv">Prénom :: Information obligatoire</div>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textarea">
    <label class="cf_label" style="width: 150px;">Adresse</label>
    <textarea class="cf_inputbox" rows="3" id="text_7" title="" cols="40" name="txtAdresse"></textarea>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Ville</label>
    <input class="cf_inputbox" maxlength="150" size="50" title="" id="text_8" name="txtVille" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">C.P.</label>
    <input class="cf_inputbox" maxlength="150" size="50" title="" id="text_9" name="txtCP" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px; color: red"><b>Téléphone (*)</b></label>
    <input class="cf_inputbox required" maxlength="150" size="50" title="Merci de renseigner votre téléphone" id="text_10" name="txtTel" type="text" />
  <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
				<div class="tooltipdiv">Téléphone :: Information obligatoire</div>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px; color: red"><b>Email (*)</b></label>
    <input class="cf_inputbox required validate-email" maxlength="150" size="50" title="Merci de renseigner votre adresse email" id="text_12" name="txtEmail" type="text" />
  <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
<div class="tooltipdiv">Email :: Information obligatoire</div>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px; color: red"><b>Date de naissance (*)</b></label>
    <input class="cf_inputbox required" maxlength="150" size="50" title="Merci de renseigner votre date de naissance" id="text_14" name="txtDate" type="text" />
  <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
<div class="tooltipdiv">Date de naissance :: Information obligatoire</div>  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Faites vos choix ci-dessous</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Les arts</label>
    <select class="cf_inputbox" id="select_17" size="10" title="" multiple="multiple" name="arts[]">
      <option value="Art floral">Art floral</option>
<option value="Beaux-arts">Beaux-arts</option>
<option value="Cuisine">Cuisine</option>
<option value="Musique">Musique</option>
<option value="Patchwork">Patchwork</option>
<option value="Peinture sur porcelaine">Peinture sur porcelaine</option>
<option value="Peinture sur soie">Peinture sur soie</option>
<option value="Scrapbooking">Scrapbooking</option>
<option value="Sculpture sur pierre">Sculpture sur pierre</option>
<option value="Terre et modelage">Terre et modelage</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Bibliothèques</label>
    <select class="cf_inputbox" id="select_18" size="2" title="" multiple="multiple" name="biblis[]">
      <option value="Adultes">Adultes</option>
      <option value="Enfants">Enfants</option>
    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Décoration</label>
    <select class="cf_inputbox" id="select_19" size=5" title="" multiple="multiple" name="deco[]">
      <option value="Abat-jour">Abat-jour</option>
<option value="Patine">Patine</option>
<option value="Réfection de sièges">Réfection de sièges</option>
<option value="Reliure">Reliure</option>
<option value="Restauration de meubles">Restauration de meubles</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Informatique</label>
    <select class="cf_inputbox" id="select_20" size="1" title=""  name="info">
      <option value="Oui">Oui</option>
      <option value="Non" selected="selected">Non</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Sports de l'esprit</label>
    <select class="cf_inputbox" id="select_21" size="3" title="" multiple="multiple" name="mind[]">
      <option value="Echecs">Echecs</option>
      <option value="Scrabble">Scrabble</option>
      <option value="Tarot">Tarot</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Théâtre, Comédie musicale, mime</label>
    <select class="cf_inputbox" id="select_22" size="3" title=""  name="theatre[]" multiple="multiple">
      <option value="Théâtre">Théâtre</option>
      <option value="Comédie musicale">Comédie musicale</option>
      <option value="Mime">Mime</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Danses</label>
    <select class="cf_inputbox" id="select_23" size="9" title="" multiple="multiple" name="danses[]">
      <option value="Capoeira">Capoeira</option>
      <option value="Claquettes">Claquettes</option>
      <option value="Danse classique">Danse classique</option>
      <option value="Danse enfants">Eveil musique</option>
<option value="Danses du monde">Danses du monde</option>
<option value="Danses orientales">Danse orientale</option>
<option value="Danses de salon">Danses de salon</option>
<option value="Hip hop">Hip-hop, Breakdance, Ragga</option>
<option value="Modern Jazz">Modern Jazz</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Remise en forme</label>
    <select class="cf_inputbox" id="select_24" size="8" title="" multiple="multiple" name="forme[]">
      <option value="Barres et assouplissement">Barres et assouplissement</option>
<option value="Fitness">Fitness</option>
<option value="Forme et bien-être">Forme et bien-être</option>
<option value="Musique et mouvements">Musique et mouvements</option>
<option value="Step">Step</option>
<option value="Table Penchenat">Table Penchenat</option>
<option value="Tai Chi Yang">Tai Chi Yang</option>
<option value="Yoga">Yoga</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Gymnastiques</label>
    <select class="cf_inputbox" id="select_25" size="5" title="" multiple="multiple" name="gym[]">
      <option value="Chi Kong">Chi Kong</option>
<option value="Forme et bien-être">Forme et bien-être</option>
<option value="Gym aux agrès">Gym aux agrès</option>
<option value="GRS">GRS</option>
<option value="Tai Chi Yang">Tai Chi Yang</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Arts martiaux</label>
    <select class="cf_inputbox" id="select_26" size="5" title="" multiple="multiple" name="combat[]">
      <option value="Aikido Aikikai">Aikido Aikikai</option>
<option value="Aikido Iwama">Aikido Iwama</option>
<option value="Judo">Judo</option>
<option value="Karaté">Karaté</option>
<option value="Tai Chi Yang">Tai Chi Yang</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Sports collectifs</label>
    <select class="cf_inputbox" id="select_27" size="2" title="" multiple="multiple" name="sportsco[]">
      <option value="Baseball-softball">Baseball-softball</option>
      <option value="Volley">Volley-ball</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Sports individuels</label>
    <select class="cf_inputbox" id="select_28" size="5" title="" multiple="multiple" name="sportsindiv[]">
      <option value="Escrime">Escrime</option>
<option value="Plongée">Plongée</option>
<option value="Roller">Roller</option>
<option value="Tennis">Tennis</option>
<option value="Tennis de table">Tennis de table</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textarea">
    <label class="cf_label" style="width: 150px;">Commentaires</label>
    <textarea class="cf_inputbox" rows="3" id="text_29" title="" cols="30" name="comments"></textarea>
    <a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
				<div class="tooltipdiv">Commentaires :: Indiquez ici p. ex. l'activité beaux-arts, musique ou l'horaire souhaité...</div>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Envoyer" name="button_32" type="submit" /><input type="reset" name="Effacer" value="Reset"/>
  </div>
  <div class="cfclear"> </div>
</div>

And the confirmation code is:


<h1>Formulaire de préinscription 2009-2010 au Club Chevry</h1>
<p><br /><br /></p>
<h3>Vous avez entré les informations suivantes :</h3>
<p><br /><br /> <strong>Nom :</strong> {txtNom}<br /> 
<strong>Prénom :</strong> {txtPrenom}<br /> 
<?php
if($_POST['txtAdresse'] != '')
     echo '<b>Adresse :</b> {txtAdresse}<br />';
if($_POST['txtVille'] != '')
     echo '<b>Ville :</b> {txtVille}<br />';
if($_POST['txtCP'] != '')
     echo '<b>Code postal :</b> {txtCP}<br />';
?>
<strong>Date de naissance :</strong> {txtDate}<br /> 
<strong>Téléphone :</strong> {txtTel}<br /> 
<strong>Email :</strong> {txtEmail}<br /> 
<strong>Date de naissance :</strong> {txtDate}<br /> 
<br />
<br />
<strong>Vos choix sont indiqués ci-dessous :</strong>
<br /> 
<br />
<?php
if($_POST['arts'] != '')
     echo '<b>Les arts :</b> {arts}<br />';
if($_POST['biblis'] != '')
     echo '<b>Bibliothèques :</b> {biblis}<br />';
if($_POST['deco'] != '')
     echo '<b>Décoration :</b> {deco}<br />';
if($_POST['info'] == 'Oui')
     echo '<b>Informatique :</b> {info}<br />';
if($_POST['mind'] != '')
     echo "<b>Sports de l'esprit :</b> {mind}<br />";
if($_POST['theatre'] != '')
     echo '<b>Théâtre :</b> {theatre}<br />';
if($_POST['danses'] != '')
     echo '<b>Les danses :</b> {danses}<br />';
if($_POST['forme'] != '')
     echo '<b>Remise en forme :</b> {forme}<br />';
if($_POST['gym'] != '')
     echo '<b>Gymnastiques :</b> {gym}<br />';
if($_POST['combat'] != '')
     echo '<b>Arts martiaux :</b> {combat}<br />';
if($_POST['sportsco'] != '')
     echo '<b>Sports collectifs :</b> {sportsco}<br />';
if($_POST['indiv'] != '')
     echo '<b>Sports individuels :</b> {sportsindiv}<br />';
if($_POST['comments'] != '')
     echo '<b>Vos commentaires :</b> {comments}<br />';
?>

<br /><br />
Vérifiez une dernière fois vos choix puis cliquez sur 'Submit' ou cliquez sur 'Back' pour revenir au formulaire !<br /><br /></p>

Forums

Form data not saved