|
By: Rob
Date: 2003-11-14
Time: 12:35
|
Variables in Form
I have a Select field in a form, filled with data from MySQL. That works fine. My CGI-form script (bnbform.cgi) needs to validate an Input list with all fields that are to be sent to the email-address.
My problem is to get that list in the Input statement. Now it looks like this:
<INPUT TYPE="HIDDEN" NAME="data_order" VALUE="achternaam,telefoon,email,[blk1.datum;htmlconv=no]: [blk1.omschrijving]">
|
I tried to solve it with [block=begin] and [block=end] around blk1, around the Input statement and around the table. However, nothing works. The form is screwed up and does not give the list which should read something like this:
<INPUT TYPE="HIDDEN" NAME="data_order" VALUE="achternaam,telefoon,email,merge1,merge2,merge3">
|
where merge is the result of the data from the database.
Hopefully you can help me.
Thanks |
|
By: Rob
Date: 2003-11-14
Time: 17:26
|
Re: Variables in Form
Unfortunately not. My e-mail now looks like this:
....
achternaam = dv
telefoon = dvdv
email = vd
[blk1.block=begin][blk1.datum][blk1.block=end] =
|
My form looks like this:
<table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolor="#333333">
<tr>
<td bgcolor="#CCCCCC"> <b><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
Vul op dit formulier uw gegevens in (de onderdelen met een <font color="#FF0000">*</font>
zijn minimaal gewenst). </font></b>
<FORM METHOD="POST" ACTION="../cgi-bin/bnbform.cgi">
<table width="93%" border="0" cellspacing="10" cellpadding="0" align="left">
<tr align="left" valign="top">
<td width="23%">
<p align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" class="standaard">Naam<b><font color="#FF0000">*</font></b>:</font></p>
</td>
<td width="77%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="achternaam" size="30" maxlength="50">
<input type="radio" name="man_vrouw" value="man">
<span class="standaard">man
<input type="radio" name="man_vrouw" value="vrouw">
vrouw</span></font></td>
</tr>
<tr align="left" valign="top">
<td width="23%" class="standaard">
<p align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" class="standaard">Adres:</font></p>
</td>
<td width="77%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="adres" size="30" maxlength="50">
</font></td>
</tr>
<tr align="left" valign="top">
<td width="23%">
<p align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" class="standaard">Postcode/Plaats:</font></p>
</td>
<td width="77%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="pc_plaats" size="30" maxlength="50">
</font></td>
</tr>
<tr align="left" valign="top">
<td width="23%">
<p align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" class="standaard">Telefoon<b><font color="#FF0000">*</font></b>:</font></p>
</td>
<td width="77%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="telefoon" size="30">
</font></td>
</tr>
<tr align="left" valign="top">
<td width="23%">
<p align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" class="standaard">E-mail
adres<b><font color="#FF0000">*</font></b>:</font></p>
</td>
<td width="77%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="email" size="30" maxlength="50">
</font></td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="standaard">
Ik geef mij op voor de volgende activiteit:
</td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="standaard">
<select name="activiteit" size="4" id="list_2" multiple>
<option>Geen keuze</option>
<option>[blk1.datum;block=option]</option>
<option>[var.kies;selected]</option>
</select>
</td>
</tr>
<tr align="left" valign="top">
<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><span class="standaard">Uw vraag of opmerking:</span><br>
<textarea name="informatie" cols="60" rows="3" wrap="PHYSICAL"></textarea>
</font>
</td>
</tr>
<tr align="left" valign="top">
<td width="23%">
<p><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2">
<input type="submit" name="Submit" value="Verstuur gegevens">
</font></font></p>
</td>
<td width="77%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="reset" name="Reset" value="Verwijder gegevens">
</font></td>
</tr>
</table>
<!-- SCRIPT CONFIGURATION SECTION -->
<table width="100%" border="0" cellspacing="2" cellpadding="0">
<INPUT TYPE="HIDDEN" NAME="required" VALUE="achternaam,telefoon,email">
<INPUT TYPE="HIDDEN" NAME="submit_to" VALUE="info@nuver.nl">
<INPUT TYPE="HIDDEN" NAME="data_order" VALUE="achternaam,telefoon,email,[blk1.block=begin][blk1.datum][blk1.block=end]">
<INPUT TYPE="HIDDEN" NAME="form_id" VALUE="Hestarholt IJslandse paarden info-formulier.">
<INPUT TYPE="HIDDEN" NAME="ok_url" VALUE="http://www.hestarholt.nl/paginas/thanks.htm">
<INPUT TYPE="HIDDEN" NAME="not_ok_url" VALUE="http://www.hestarholt.nl/paginas/oops.htm">
</table>
<!-- END OF SCRIPT CONFIGURATION SECTION -->
</form>
</td>
</tr>
</table>
|
My PHP looks like this:
$kies = "Geen keuze" ;
$date = date("ymd");
$db_id = mysql_connect($db_srv,$db_usr,$db_pwd) ;
$db_ok = mysql_select_db($db_dbase,$db_id) ;
$ObjTBS = new clsTinyButStrong;
$ObjTBS->LoadTemplate("infoform.htm");
$ObjTBS->MergeBlock("blk1",$db_id,"SELECT * FROM activiteiten WHERE datum_show<=$date AND datum_noshow>$date AND vrijgeven='Ja' ORDER BY datum_noshow, volgnummer") ;
mysql_close($db_id);
$ObjTBS->Show() ;
|
Hope you can find it out.
Thanks very much for trying. |
|
By: Skrol29
Date: 2003-11-14
Time: 17:43
|
Re: Variables in Form
I made a misteak. It should be :
<INPUT TYPE="HIDDEN" NAME="data_order" VALUE="achternaam,telefoon,email[blk1;block=begin],[blk1.merge][blk1;block=end]">
|
[blk1;block=begin],[blk1.merge][blk1;block=end]
instead of
[blk1.block=begin],[blk1.merge][blk1.block=end]
But most of all, you must not have two different block with the same name. They will be considerated as two sections of the same block.
Change one of the block name and perform two BlockMerge(). |