Retrieve DB table values from CB to hidden fields

ia

iaweb2 29 Feb, 2008

Hello and thanks for a nice easy piece of form creation...

OK, now to the more difficult part (for me at least)...

I have a form which shall collect a total of 11 different fields from the Community Builder tables inside my Joomla DB and 1 field (the email address) from the users table and fill them into hidden fields inside my form.

I figured out the email address thing with a set-up like this inside the HTML for the form:

<?php global $my; ?>
<input type="hidden" id="GuestEmail" name="GuestEmail" value="<?php echo $my->email; ?>" />

However that is a global value so that was pretty easy.. and now I am stucked on retrieving fields like Firstname and Lastname from the jos_comprofiler table for the logged-on user, and honestly I have absolutely no clue how to achieve this and any advice would be highly appreciated.

Thanks

iaweb

Max_admin 01 Mar, 2008

Hi iaweb,

with the help of the profiler plugin at the latest chronoforms release you can do this VERY EASY, search the forums for 'profiler plugin', there is some post where I gave a detailed guide on how to retrieve data from a table, for your info, if the form will be viewed by logged in users only then you won't need the parameter at the URL, it will be filled in automatically from the global parameter!🙂

Cheers,

Max

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

ia

iaweb2 01 Mar, 2008

EDIT:::

Nevermind what I wrote below, I am an idiot and officially proclaim it. Of course nothing can be filled in when the fields are empty in the table.

I forgot to use a user who actually has entries in the jos_comprofiler table:blink: :blink:

Everything works like a charm, thanks a million Max, its some great piece of software and as soon as I sort out some other things I want to do with it, you will get my payment for the purchase, it's worth much more than the requested 25 bucks, as it solved something I was unsuccessfully trying to do for 4 weeks with other form components...

iaweb

Hey Max

Thanks for the answer and for the point into the Profiler Plug-In direction.

I found the following post by you (I think that is what you were referring to):

#1- Table name : select the table which will be queried to get the data!
#2- REQUEST Parameter name : enter the parameter name which will come at the URL of your candidate, I guess you will send a link to your candidate with something like this :
http://www.chronoengine.com/index.php?option=com_fireboard&func=view&id=5646

as you can see above there is a parameter called id to define the number, so in your case you will add the parameter name, in the url above its "id"

#3- Target field name: this is the field name at the database, like the table primary column or whatever uniques the database record to be selected!

I tried to implement this, however I am not really sure what to fill in into the fields and if there is something else I need to activate?

I have choosen the jos_comprofiler table as the Table name, however I have no idea what to fill into the REQUEST Parameter name (I tried "$my->id" but somehow that does not work) and honestly I have no idea what to fill into the Target field name, as nothing shall be stored in that table, it shall be read from the table only and than sent via the form to a third party site for processing.

Sorry to hump around here with this, but I am somehow lost.

Thanks

iaweb Post edited by: iaweb2, at: 2008/03/01 07:53

ia

iaweb2 01 Mar, 2008

Hey Max:

Now that I have all values retrieved from the tables I wanted (see previous post) I am facing two different issues:

1) Joomla suddenly masks the retrieved email address with the following code:

<script language='JavaScript' type='text/javascript'>
 <!--
 var prefix = 'ma' + 'il' + 'to';
 var path = 'hr' + 'ef' + '=';
 var addy69375 = 'evp' + '@';
 addy69375 = addy69375 + 'eclipsehotels' + '.' + 'com';
 document.write( '<a ' + path + '\'' + prefix + ':' + addy69375 + '\'>' );
 document.write( addy69375 );
 document.write( '<\/a>' );
 //-->\n </script><script language='JavaScript' type='text/javascript'>
 <!--
 document.write( '<span style=\'display: none;\'>' );
 //-->
 </script>This e-mail address is being protected from spam bots, 
you need JavaScript enabled to view it
 <script language='JavaScript' type='text/javascript'>
 <!--
 document.write( '</' );
 document.write( 'span>' );
 //-->
 </script>">

and instead of sending the actual email address to my third party site, all that code is sent.

Is there a way to go around this or disable the masking for the forms?

2) As the form perfectly retrieves the values from my CB table when a user is logged in, when you are not logged in the values show the code:

{firstname}

and send this information over to our third party, however if a user is not logged on the value should be empty and not the actual code.

Here again, any way I can change the set-up that this code is not shown when a user is not logged on.

Thanks a million,

iaweb

Gr

GreyHead 01 Mar, 2008

Hi iaweb,

The JavaScript problem is most likely the Site 'Email cloaking' mambot.

For the second question: will a conditional use of the form work

<?php
global $my;
if ( $my->id ) {
  // user is logged in
  . . . show this form code . . .
} else {
  // user is not logged is
  . . .show this form code
}
?>

Bob

ia

iaweb2 01 Mar, 2008

Bob

Thanks for the reply, and yes it is the email Cloaking Mambot, however that happens only when I call the form with the chronoforms mambot inside the frontpage, when I call the form directly via the form Link ...

index.php?option=com_chronocontact&chronoformname=Search

than the email cloaking does not happen .... strange...

For the time being I have unpublished the email cloaking mambot, however I am not 100% that this is a good idea...

I will look at the conditional use (if I can put that in my form... remember I proclaimed already before that I am an idiot;) ) and will post again if it worked...

Thanks

iaweb

ia

iaweb2 01 Mar, 2008

Ok Bob, that is what I ried with the conditional form:

<?php
global $my;
if ( $my->id ) {
  // user is logged in
<input type="hidden" id="PropertyID" name="PropertyID" value="3083">
<input type="hidden" id="SubSource" name="SubSource" value="BookingEngine">
<input type="hidden" id="Action" name="Action" value="Book">
<input type="hidden" id="CnfNum" name="CnfNum" value="">
<input type="hidden" id="PlanCode" name="PlanCode" value="">
<input type="hidden" id="FirstName" name="FirstName" value="{firstname}">
<input type="hidden" id="LastName" name="LastName" value="{lastname}">
<input type="hidden" id="GuestEmail" name="GuestEmail" value="<?php echo $my->email; ?>">
<input type="hidden" id="GuestPhone" name="GuestPhone" value="{phone}">
<input type="hidden" id="GuestAddressLine1" name="GuestAddressLine1" value="{address}">
<input type="hidden" id="GuestAddressLine2" name="GuestAddressLine2" value="{cb_privaddress}">
<input type="hidden" id="GuestCity" name="GuestCity" value="{city}">
<input type="hidden" id="GuestState" name="GuestState" value="{state}">
<input type="hidden" id="GuestCountry" name="GuestCountry" value="{country}">
<input type="hidden" id="GuestZIP" name="GuestZIP" value="{zipcode}">
<input type="hidden" id="CCType" name="CCType" value="">
<input type="hidden" id="CCNumber" name="CCNumber" value="">
<input type="hidden" id="CCName" name="CCName" value="">
<input type="hidden" id="CCExpMonth" name="CCExpMonth" value="">
<input type="hidden" id="CCExpYear" name="CCExpYear" value="">
<input type="hidden" id="FrequentGuestID" name="FrequentGuestID" value="{cb_memberno}">
<input type="hidden" id="IATA" name="IATA" value="">
<input type="hidden" id="ReferralCode" name="ReferralCode" value="">
<input type="hidden" id="Currency" name="Currency" value="USD">
	<tr>
		<td class="style3">Arrival Date</td>
	</tr>
	<tr>
		<td class="style3">
<span class="style3">
</span>
<nobr><span class="style1"><span class="style2">
		<select name="ArrivalDateMonth"  onchange id="ArrivalDateMonth" class="style3">
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select><select name="ArrivalDateDay"  onchange id="ArrivalDateDay" class="style3">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select><select name="ArrivalDateYear"  onchange id="ArrivalDateYear" class="style3">
<option value="2008">2008</option>
<option value="2009">2009</option>
</select> </span></span> </nobr>
		</td>
	</tr>
	<tr>
		<td class="style3">Departure Date</td>
	</tr>


	<tr>
		<td class="style3"><span class="style1"><span class="style2">
		</span></span>
<nobr><span class="style1"><span class="style2">
		<select name="DepartureDateMonth"  onchange id="DepartureDateMonth" class="style3">
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select><select name="DepartureDateDay"  onchange id="DepartureDateDay" class="style3">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select><select name="DepartureDateYear"  onchange id="DepartureDateYear" class="style3">
<option value="2008">2008</option>
<option value="2009">2009</option>
</select> </span></span> </nobr>
		</td>
	</tr>


<tr>
   <td class="style3">No. of Adults</td>
</tr>


<tr>
   <td class="style3">
	<select name="NumberOfAdults"  id="NumberOfAdults" class="style3">
<option selected="selected" value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select></td>
</tr>
<tr>
   <td class="style3">No. of Children</td>
</tr>
<tr>
   <td class="style3">
	<select name="NumberOfChildren"  id="NumberOfChildren" class="style3">
<option selected="selected" value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select></td>
</tr>
<tr>
   <td class="style3">No. of Rooms</td>
</tr>
<tr>
   <td class="style3">
	<select name="NumberOfRooms"  id="NumberOfRooms" class="style3">
<option selected="selected" value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select></td>
</tr>
<tr>
	<td class="style3">Rate Category:</td>
</tr>
<tr>
	<td class-"style3"><select name="RateCat"  id="RateCat">
<option value="">All</option>
<option value="COR">Corporate</option>
<option value="CVN">Convention</option>
<option value="FAM">Family</option>
<option value="GOV">Government</option>
<option value="MIL">Military</option>
<option value="PKG">Package</option>
<option value="PRO">Promotion</option>
<option value="RAC">Rack</option>
<option value="SNR">Senior</option>
<option value="TRV">Travel</option>
<option value="TUR">Tour</option>
<option value="WKD">Weekend</option>
</select></td>
</tr>
<tr>
   <td class="style3">Promo/Negotiated Code</td>
</tr>
<tr>
   <td class="style3">
	<input type="text" id="PromoCode" name="PromoCode" size="15" maxlength="20" value="" class="style3"></td>
</tr>
<tr>
   <td class="style3">Group ID:</td>
</tr>
<tr>
   <td class="style3">
	<input type="text" id="GroupCode" name="GroupCode" size="15" maxlength="20" value="" class="style3"></td>
</tr>
<tr>
   <td class="style4">
      <input type="submit" name="submitButton" value="Search" id="submitButton" class="style3" />
   </td>
</tr>
} else {
  // user is not logged is
<input type="hidden" id="PropertyID" name="PropertyID" value="3083">
<input type="hidden" id="SubSource" name="SubSource" value="BookingEngine">
<input type="hidden" id="Action" name="Action" value="Book">
<input type="hidden" id="CnfNum" name="CnfNum" value="">
<input type="hidden" id="PlanCode" name="PlanCode" value="">
<input type="hidden" id="FirstName" name="FirstName" value="">
<input type="hidden" id="LastName" name="LastName" value="">
<input type="hidden" id="GuestEmail" name="GuestEmail" value="">
<input type="hidden" id="GuestPhone" name="GuestPhone" value="">
<input type="hidden" id="GuestAddressLine1" name="GuestAddressLine1" value="">
<input type="hidden" id="GuestAddressLine2" name="GuestAddressLine2" value="">
<input type="hidden" id="GuestCity" name="GuestCity" value="">
<input type="hidden" id="GuestState" name="GuestState" value="">
<input type="hidden" id="GuestCountry" name="GuestCountry" value="">
<input type="hidden" id="GuestZIP" name="GuestZIP" value="">
<input type="hidden" id="CCType" name="CCType" value="">
<input type="hidden" id="CCNumber" name="CCNumber" value="">
<input type="hidden" id="CCName" name="CCName" value="">
<input type="hidden" id="CCExpMonth" name="CCExpMonth" value="">
<input type="hidden" id="CCExpYear" name="CCExpYear" value="">
<input type="hidden" id="FrequentGuestID" name="FrequentGuestID" value="">
<input type="hidden" id="IATA" name="IATA" value="">
<input type="hidden" id="ReferralCode" name="ReferralCode" value="">
<input type="hidden" id="Currency" name="Currency" value="USD">
	<tr>
		<td class="style3">Arrival Date</td>
	</tr>
	<tr>
		<td class="style3">
<span class="style3">
</span>
<nobr><span class="style1"><span class="style2">
		<select name="ArrivalDateMonth"  onchange id="ArrivalDateMonth" class="style3">
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select><select name="ArrivalDateDay"  onchange id="ArrivalDateDay" class="style3">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select><select name="ArrivalDateYear"  onchange id="ArrivalDateYear" class="style3">
<option value="2008">2008</option>
<option value="2009">2009</option>
</select> </span></span> </nobr>
		</td>
	</tr>
	<tr>
		<td class="style3">Departure Date</td>
	</tr>


	<tr>
		<td class="style3"><span class="style1"><span class="style2">
		</span></span>
<nobr><span class="style1"><span class="style2">
		<select name="DepartureDateMonth"  onchange id="DepartureDateMonth" class="style3">
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select><select name="DepartureDateDay"  onchange id="DepartureDateDay" class="style3">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select><select name="DepartureDateYear"  onchange id="DepartureDateYear" class="style3">
<option value="2008">2008</option>
<option value="2009">2009</option>
</select> </span></span> </nobr>
		</td>
	</tr>


<tr>
   <td class="style3">No. of Adults</td>
</tr>


<tr>
   <td class="style3">
	<select name="NumberOfAdults"  id="NumberOfAdults" class="style3">
<option selected="selected" value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select></td>
</tr>
<tr>
   <td class="style3">No. of Children</td>
</tr>
<tr>
   <td class="style3">
	<select name="NumberOfChildren"  id="NumberOfChildren" class="style3">
<option selected="selected" value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select></td>
</tr>
<tr>
   <td class="style3">No. of Rooms</td>
</tr>
<tr>
   <td class="style3">
	<select name="NumberOfRooms"  id="NumberOfRooms" class="style3">
<option selected="selected" value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select></td>
</tr>
<tr>
	<td class="style3">Rate Category:</td>
</tr>
<tr>
	<td class-"style3"><select name="RateCat"  id="RateCat">
<option value="">All</option>
<option value="COR">Corporate</option>
<option value="CVN">Convention</option>
<option value="FAM">Family</option>
<option value="GOV">Government</option>
<option value="MIL">Military</option>
<option value="PKG">Package</option>
<option value="PRO">Promotion</option>
<option value="RAC">Rack</option>
<option value="SNR">Senior</option>
<option value="TRV">Travel</option>
<option value="TUR">Tour</option>
<option value="WKD">Weekend</option>
</select></td>
</tr>
<tr>
   <td class="style3">Promo/Negotiated Code</td>
</tr>
<tr>
   <td class="style3">
	<input type="text" id="PromoCode" name="PromoCode" size="15" maxlength="20" value="" class="style3"></td>
</tr>
<tr>
   <td class="style3">Group ID:</td>
</tr>
<tr>
   <td class="style3">
	<input type="text" id="GroupCode" name="GroupCode" size="15" maxlength="20" value="" class="style3"></td>
</tr>
<tr>
   <td class="style4">
      <input type="submit" name="submitButton" value="Search" id="submitButton" class="style3" />
   </td>
</tr>
}
?>

However now my form does not show anymore, except for the link to the ChronoEngine.com website... and that is happening if I am logged on or not, same ... same...

So, somehow I must have a mistake in there...

I just realized that I have a php command inside a php command, so I tried to take them apart as follows:

<?php
global $my;
if ( $my->id ) {
  // user is logged in
<input type="hidden" id="PropertyID" name="PropertyID" value="3083">
<input type="hidden" id="SubSource" name="SubSource" value="BookingEngine">
<input type="hidden" id="Action" name="Action" value="Book">
<input type="hidden" id="CnfNum" name="CnfNum" value="">
<input type="hidden" id="PlanCode" name="PlanCode" value="">
<input type="hidden" id="FirstName" name="FirstName" value="{firstname}">
<input type="hidden" id="LastName" name="LastName" value="{lastname}">
<input type="hidden" id="GuestPhone" name="GuestPhone" value="{phone}">
<input type="hidden" id="GuestAddressLine1" name="GuestAddressLine1" value="{address}">
<input type="hidden" id="GuestAddressLine2" name="GuestAddressLine2" value="{cb_privaddress}">
<input type="hidden" id="GuestCity" name="GuestCity" value="{city}">
<input type="hidden" id="GuestState" name="GuestState" value="{state}">
<input type="hidden" id="GuestCountry" name="GuestCountry" value="{country}">
<input type="hidden" id="GuestZIP" name="GuestZIP" value="{zipcode}">
<input type="hidden" id="CCType" name="CCType" value="">
<input type="hidden" id="CCNumber" name="CCNumber" value="">
<input type="hidden" id="CCName" name="CCName" value="">
<input type="hidden" id="CCExpMonth" name="CCExpMonth" value="">
<input type="hidden" id="CCExpYear" name="CCExpYear" value="">
<input type="hidden" id="FrequentGuestID" name="FrequentGuestID" value="{cb_memberno}">
<input type="hidden" id="IATA" name="IATA" value="">
<input type="hidden" id="ReferralCode" name="ReferralCode" value="">
<input type="hidden" id="Currency" name="Currency" value="USD">
} else {
  // user is not logged in
<input type="hidden" id="PropertyID" name="PropertyID" value="3083">
<input type="hidden" id="SubSource" name="SubSource" value="BookingEngine">
<input type="hidden" id="Action" name="Action" value="Book">
<input type="hidden" id="CnfNum" name="CnfNum" value="">
<input type="hidden" id="PlanCode" name="PlanCode" value="">
<input type="hidden" id="FirstName" name="FirstName" value="">
<input type="hidden" id="LastName" name="LastName" value="">
<input type="hidden" id="GuestEmail" name="GuestEmail" value="">
<input type="hidden" id="GuestPhone" name="GuestPhone" value="">
<input type="hidden" id="GuestAddressLine1" name="GuestAddressLine1" value="">
<input type="hidden" id="GuestAddressLine2" name="GuestAddressLine2" value="">
<input type="hidden" id="GuestCity" name="GuestCity" value="">
<input type="hidden" id="GuestState" name="GuestState" value="">
<input type="hidden" id="GuestCountry" name="GuestCountry" value="">
<input type="hidden" id="GuestZIP" name="GuestZIP" value="">
<input type="hidden" id="CCType" name="CCType" value="">
<input type="hidden" id="CCNumber" name="CCNumber" value="">
<input type="hidden" id="CCName" name="CCName" value="">
<input type="hidden" id="CCExpMonth" name="CCExpMonth" value="">
<input type="hidden" id="CCExpYear" name="CCExpYear" value="">
<input type="hidden" id="FrequentGuestID" name="FrequentGuestID" value="">
<input type="hidden" id="IATA" name="IATA" value="">
<input type="hidden" id="ReferralCode" name="ReferralCode" value="">
<input type="hidden" id="Currency" name="Currency" value="USD">
}
?>

<input type="hidden" id="GuestEmail" name="GuestEmail" value="<?php echo $my->email; ?>">
	<tr>
		<td class="style3">Arrival Date</td>
	</tr>
	<tr>
		<td class="style3">
<span class="style3">
</span>
<nobr><span class="style1"><span class="style2">
		<select name="ArrivalDateMonth"  onchange id="ArrivalDateMonth" class="style3">
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select><select name="ArrivalDateDay"  onchange id="ArrivalDateDay" class="style3">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select><select name="ArrivalDateYear"  onchange id="ArrivalDateYear" class="style3">
<option value="2008">2008</option>
<option value="2009">2009</option>
</select> </span></span> </nobr>
		</td>
	</tr>
	<tr>
		<td class="style3">Departure Date</td>
	</tr>


	<tr>
		<td class="style3"><span class="style1"><span class="style2">
		</span></span>
<nobr><span class="style1"><span class="style2">
		<select name="DepartureDateMonth"  onchange id="DepartureDateMonth" class="style3">
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select><select name="DepartureDateDay"  onchange id="DepartureDateDay" class="style3">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select><select name="DepartureDateYear"  onchange id="DepartureDateYear" class="style3">
<option value="2008">2008</option>
<option value="2009">2009</option>
</select> </span></span> </nobr>
		</td>
	</tr>


<tr>
   <td class="style3">No. of Adults</td>
</tr>


<tr>
   <td class="style3">
	<select name="NumberOfAdults"  id="NumberOfAdults" class="style3">
<option selected="selected" value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select></td>
</tr>
<tr>
   <td class="style3">No. of Children</td>
</tr>
<tr>
   <td class="style3">
	<select name="NumberOfChildren"  id="NumberOfChildren" class="style3">
<option selected="selected" value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select></td>
</tr>
<tr>
   <td class="style3">No. of Rooms</td>
</tr>
<tr>
   <td class="style3">
	<select name="NumberOfRooms"  id="NumberOfRooms" class="style3">
<option selected="selected" value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select></td>
</tr>
<tr>
	<td class="style3">Rate Category:</td>
</tr>
<tr>
	<td class-"style3"><select name="RateCat"  id="RateCat">
<option value="">All</option>
<option value="COR">Corporate</option>
<option value="CVN">Convention</option>
<option value="FAM">Family</option>
<option value="GOV">Government</option>
<option value="MIL">Military</option>
<option value="PKG">Package</option>
<option value="PRO">Promotion</option>
<option value="RAC">Rack</option>
<option value="SNR">Senior</option>
<option value="TRV">Travel</option>
<option value="TUR">Tour</option>
<option value="WKD">Weekend</option>
</select></td>
</tr>
<tr>
   <td class="style3">Promo/Negotiated Code</td>
</tr>
<tr>
   <td class="style3">
	<input type="text" id="PromoCode" name="PromoCode" size="15" maxlength="20" value="" class="style3"></td>
</tr>
<tr>
   <td class="style3">Group ID:</td>
</tr>
<tr>
   <td class="style3">
	<input type="text" id="GroupCode" name="GroupCode" size="15" maxlength="20" value="" class="style3"></td>
</tr>
<tr>
   <td class="style4">
      <input type="submit" name="submitButton" value="Search" id="submitButton" class="style3" />
   </td>
</tr>

unfortunately with the same result... so I am pretty much at the end of my knowledge...

iaweb Post edited by: iaweb2, at: 2008/03/01 12:05

Gr

GreyHead 01 Mar, 2008

Hi iaweb,

First mambot's don't usually operate on ChronoForms pages - that's why you get the different behaviour. (You can turn them on in the General tab if you need them to work). The Email cloaking mambot is a blunt instrument and has no way of discriminating between email addresses being displayed that need hiding and those in forms that need to be preserved :-(

Second, the form code needs to use php tags to move between php and plain html

 <?php
global $my;
if ( $my->id ) {
?>
  . . . plain html . . .
<?php
  . . . some more php . . .
?>
  . . .  more plain html . . .
<?php
} // back to to php to close the if loop
?>

Sorry, I take this a bit for granted.

Bob

PS You can also use some php to clean up those long option lists, for example

<?php
for ( $i=1, $i <= 31, $i++ ) {
  echo "<option value='$i'>$i</option>";
}
?>

or, perhaps even better here use the Joomla JavaScript date selector - I think it's in the FAQs.

Bob Post edited by: GreyHead, at: 2008/03/01 15:53

ia

iaweb2 01 Mar, 2008

Dear Bob

Thanks for the further help and let me first address your last suggestions, unfortunately I can not use the joomal function for the dates, as I have as well a javascript validation running on the dates (from the third party site we use as booking engine) and the fields need to be separated in to day month year and honestly I am happy that I got at least the validation working with it (will still need to get the automatic change to today's date and the auto-change of the departure date for arrival date+1 working) so I rather leave that alone for the time being...

Regarding the different forms showing, as I have honestly no idea about php I am not sure if I got the right idea now... could you have a look at the following of that makes sense:

<?php
global $my;
if ( $my->id ) {
?>
<input type="hidden" id="FirstName" name="FirstName" value="{firstname}">
<?php
} else {
?>
<input type="hidden" id="FirstName" name="FirstName" value="">
}
?>
<input type="hidden" id="GuestEmail" name="GuestEmail" value="<?php echo $my->email; ?>">

Does that set-up make any sense ??? I am really confused...

Thanks a million

iaweb

Gr

GreyHead 01 Mar, 2008

Hi iaweb,

You are missing a <?php before the last '}'

Otherwise this looks OK - provided that you are using the PlugIn to pick up the values of {firstname}

Bob

ia

iaweb2 02 Mar, 2008

Thanks Bob,

That worked like a charm....

Now all I have to do is get the javascript stuff working (3 scripts into one form), but for that I will first search the forums and if that does not help open another thread.

Thanks again to you and Max for the tremendeous help.

iaweb

Forums

Retrieve DB table values from CB to hidden fields