Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

The JED needs volunteers!

[help] make reservation form + registration form

no
noztox 17 Feb, 2009
Hi all,

i have problem and i no idea for resolve this problem,

I make reservation form + registration form in 1 form, but i have problem if i have account member and i reservation.
in form reservation i don't write again my data detail, and i submit all data. i have messege "you already have account", maybe you can help me..

thanks all... :wink:
Gr
GreyHead 17 Feb, 2009
Hi noztox,

Please post a link to the form or post the form code. We can't help much without more information about what the form is doing.

Bob
no
noztox 17 Feb, 2009
Form HTML:

<?php 
	global $database;

        $notable = mosGetParam($_GET, 'no', '');
        $idtable = mosGetParam($_GET, 'id', '');
        $query1 = 'SELECT * FROM aj_event_table_edit_'.$notable.' where id = '.$idtable.'';
        $database->setQuery( $query1 );
        $rows = $database->loadRow();
        if ($database->getErrorNum()) {
		echo $database->stderr();
		return false;
	};
        $datestart = $rows[3];
        $dateend = $rows[4];
        $price = $rows[5];
        switch ($notable) {
	       case '1':
           case '2':
           case '3':
           case '5':
             $country = 'Indonesia';
             $tripname = 'Sailing Nusa Tenggara';
             break;
           case '4':
             $country = 'Nepal';
             $tripname = 'Everest Base Camp Tour';
             break;
           case '6':
             $country = 'Cambodia, Vietnam and Laos';
             $tripname = 'Magical Indochina';
             break;
           case '7':
             $country = 'China, Mongolia, Russia';
             $tripname = 'Trans Mongolian Express';
             break;
           case '8':
             $country = 'France';
             $tripname = 'Cycling Loire Valley, France';
             break;
           default:
             break;
         };

         switch ($notable) {
	   case '1':
           case '2':
             $localpay = $rows[9];
             $attributes = $rows[6];
             $supplement = $rows[7];
             break;
           default:
             $localpay = $rows[6];
             $attributes = $rows[7];
             $supplement = $rows[8];
             break;
         };
         switch ($notable) {
	   case '1':
             $tripname = 'Discover West Java';
             break;
           case '2':
             $tripname = 'Hiking Papua';
             break;
           case '3':
             $tripname = 'Discover East Java';
             break;
           default:
             break;
         };
?>

<?
  global $my;

  global $mainframe;  
  $mainframe->_session;
?>

<style type="text/css">
@import url(js/SpryTabbedPanels.css);
</style>
<script language="JavaScript">
<!--
var counter = 0;

function moreFields()
{
	counter++;
	var newFields = document.getElementById('readroot').cloneNode(true);
	newFields.id = '';
	newFields.style.display = 'block';
	var newField = newFields.childNodes;
	for (var i=0;i<newField.length;i++)
	{
		var theName = newField[i].name
		if (theName)
		newField[i].name = theName + counter;
	}
	var insertHere = document.getElementById('writeroot');
	insertHere.parentNode.insertBefore(newFields,insertHere);
}
window.onload = moreFields;
-->
</script>

<div id="TabbedPanels1" class="TabbedPanels">
  <ul class="TabbedPanelsTabGroup">
    <li class="TabbedPanelsTab" tabindex="1">Step 1</li>
    <li class="TabbedPanelsTab" tabindex="2">Step 2</li>
    <li class="TabbedPanelsTab" tabindex="3">Step 3</li>
    <li class="TabbedPanelsTab" tabindex="4">Step 4</li>
  </ul>
  <div class="TabbedPanelsContentGroup">
    <div class="TabbedPanelsContent">
      <p><span class="style1">Terms and Conditions</span> </p>
        <ul>
          <li class="style1">Bla... bla....</li>
          <li class="style1">Bla... bla</li>
        </ul>
        <p> </p>
        
          <label>
          <input type="checkbox" name="pos" id="pos" />
            I acknowledge that I have read and understood the  Terms and Conditions. </label>
          <p align="right">
            <label>
            <input type="button" name="next" id="next" value="Next" onclick="TabbedPanels1.showPanel(1); return false;"/>
            </label>
      </p>
	</div>
    <div class="TabbedPanelsContent">
   	  <p align="center" class="style2">Check you want resevertion
   	  <hr />
   	  <table border="0" align="center">
            <tr>
              <td>Name Trip</td>
              <td>:</td>
              <td><? echo $tripname; ?></td>
            </tr>
            <tr>
              <td>Start Date</td>
              <td>:</td>
              <td><? echo $datestart; ?></td>
            </tr>
            <tr>
              <td>End Date</td>
              <td>:</td>
              <td><? echo $dateend; ?></td>
            </tr>
              <tr>
                <td>Days</td>
                <td>:</td>
                <td> </td>
              </tr>
              <tr>
                <td>Price</td>
                <td>:</td>
                <td><? echo $price; ?></td>
              </tr>
              <tr>
                <td>Local Payment</td>
                <td>:</td>
                <td><? echo $localpay; ?></td>
              </tr>
              <tr>
                <td>Style</td>
                <td>:</td>
                <td> </td>

              </tr>
              <tr>
                <td>Physical Grading</td>
                <td>:</td>
                <td> </td>
              </tr>
              <tr>
                <td>Country Visited</td>
                <td>:</td>
                <td><? echo $country ?></td>
              </tr>
              <tr>
                <td>Start Places</td>
                <td>:</td>
                <td> </td>
              </tr>
              <tr>
                <td>End Place</td>
                <td>:</td>
                <td> </td>
              </tr>
              <tr>
                <td>Single Supplement</td>
                <td>:</td>
                <td><? echo $supplement; ?></td>
              </tr>
              <tr>
                <td>Itinerary</td>
                <td>:</td>
                <td> </td>
              </tr>
              <tr>
                <td colspan="3"> </td>
              </tr>
              <tr>
                <td colspan="3"><div align="right">
                  <input type="button" name="back" id="back" value="Back" onclick="TabbedPanels1.showPanel(0); return false;"/>		
                
                  <input type="button" name="button" id="button" value="Next" onclick="TabbedPanels1.showPanel(2); return false;" />
                </div></td>
              </tr>
      </table>
         </p>
    </div>
    <div class="TabbedPanelsContent">
    	<p align="center">Your Reservertion </p>
        <hr style="width: 100%; height: 2px;">
        <table border="0" align="center">
          <tr>
            <td width="31%"><div align="right">Code & Name trip </div></td>
            <td width="2%"><div align="center">:</div></td>

        <td width="67%"><? echo $tripname; ?></td>
          </tr>
          <tr>
            <td><div align="right">Starting date </div></td>
            <td><div align="center">:</div></td>
            <td><? echo $datestart; ?></td>
          </tr>
          <tr>
            <td><div align="right">End date </div></td>
            <td><div align="center">:</div></td>
            <td><? echo $dateend; ?></td>
          </tr>
        </table>
        <p align="center">Your Detail</p>
        <hr style="width: 100%; height: 2px;">
        <? 
		if ( $my->id ) {

			global $database;

			$id = $my->name;
			$query2 = 'SELECT * FROM aj_chronoforms_3 WHERE firstname = "'.$id.'"';
			$database->setQuery( $query2 );
			$rows1 = $database->loadRow();
			if ($database->getErrorNum()) {
				echo $database->stderr();
				return false;
			}
			?>
      <table border="0" align="center">
              <tr>
                <td width="31%"><div align="right">First Name </div></td>
                <td width="2%"><div align="center">:</div></td>
                <td width="67%"><? echo $rows1[4]; ?><div align="left">
                  <label></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Last Name </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[5]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Gender </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[6]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Date of birth </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[7]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">No. passport</div></td>
                <td><div align="center">:</div></td>
                <td><label><? echo $rows1[8]; ?></label></td>
              </tr>
              <tr>
                <td><div align="right">E-mail</div></td>
                <td><div align="center">:</div></td>
                <td><label><? echo $rows1[9]; ?></label></td>
              </tr>
              <tr>
                <td><div align="right">Address </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[10]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right"></div></td>
                <td><div align="center"></div></td>
                <td><div align="left"><? echo $rows1[11]; ?></div></td>
              </tr>
              
              <tr>
                <td><div align="right">City </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[12]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Zip Code</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[13]; ?></label>



                </div></td>
              </tr>
              <tr>
                <td><div align="right">Country</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[14]; ?></select>
                  </label>
                </div></td>
              </tr>
              <tr>




                <td><div align="right">Residents Address</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[15]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Country</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"><label></select>
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Citizenship</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[16]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right"></div></td>
                <td><div align="center"></div></td>
                <td><div align="left"></div></td>
              </tr>
              <tr>
                <td><div align="right">Preferred payment</div></td>
                <td><div align="center">:</div></td>

                <td><div align="left">
                  <label>
                  <input type="radio" name="radio" id="payment" value="payment" />
                  </label>
                Transfers bank   
                <label>
                <input type="radio" name="radio" id="Cash" value="Cash" />
                </label>
                Cash</div></td>
              </tr>
              <tr>
                <td><div align="right">Method</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="radio" name="radio" id="Today payment" value="Today payment" />
                  Today payment            </label>
                  <label>
                  <input type="radio" name="radio" id="Hold in 24 Hours" value="Hold in 24 Hours" />Hold in 24 Hours</label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Emergency</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"></div></td>
              </tr>
              <tr>
                <td><div align="right">Contact Name</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"><label><? echo $rows1[20]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Passport number</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"><label><? echo $rows1[21]; ?></label>                  
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Preferences for food</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[22]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Medical conditions</div></td>

                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label><? echo $rows1[23]; ?></label>
                </div></td>
              </tr>
              <tr>
                <td colspan="3"> </td>
              </tr>
              <tr>
                <td colspan="3"><div align="right">
                  <label>
                  <input type="button" name="back" id="back" value="Back" onclick="TabbedPanels1.showPanel(1); return false;"/>		
                
                  <input type="button" name="Button" id="Submit" value="Next" onclick="TabbedPanels1.showPanel(3); return false;" />
                  </label>
                </div></td>
              </tr>
      </table>
      <?php

		} else {
		
		// Login output
		
		// ie HTML when not logged in and trying to login
		
			// used for spoof hardening
		
			$validate = josSpoofValue(1);
		
			?>
          <table border="0" align="center">
              <tr>
                <td width="31%"><div align="right">First Name </div></td>
                <td width="2%"><div align="center">:</div></td>
                <td width="67%"><div align="left">
                  <label>
                  <input type="text" name="firstname" id="firstname">
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Last Name </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="lastname" id="lastname">
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Gender </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <select name="gender" id="gender">
                      <option value="male" selected="selected">Male</option>
                      <option value="female">Female</option>
                  </select>
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Date of birth </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="Dateofbirth" id="Dateofbirth">
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">No. passport</div></td>
                <td><div align="center">:</div></td>
                <td><label>
                  <input type="text" name="passport" id="passport" />
                </label></td>
              </tr>
              <tr>
                <td><div align="right">E-mail</div></td>
                <td><div align="center">:</div></td>
                <td><label>
                  <input type="text" name="e-mail" id="e-mail" />
                </label></td>
              </tr>
              <tr>
                <td><div align="right">Address </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="address1" id="address1">
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right"></div></td>
                <td><div align="center"></div></td>
                <td><div align="left">
                  <input type="text" name="address2" id="address2">
                </div></td>
              </tr>
              
              <tr>
                <td><div align="right">City </div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="city" id="city">
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Zip Code</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="zip" id="zip">
                  </label>



                </div></td>
              </tr>
              <tr>
                <td><div align="right">Country</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="country1" id="country1">
                  </select>
                  </label>
                </div></td>
              </tr>
              <tr>




                <td><div align="right">Residents Address</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="residents address" id="residents address">
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Country</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"><label>
                  <input type="text" name="country2" id="country2">
                  </select>
                  </label></div></td>
              </tr>
              <tr>
                <td><div align="right">Citizenship</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="text" name="Citizen" id="Citizen">
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right"></div></td>
                <td><div align="center"></div></td>
                <td><div align="left"></div></td>
              </tr>
              <tr>
                <td><div align="right">Preferred payment</div></td>
                <td><div align="center">:</div></td>

                <td><div align="left">
                  <label>
                  <input type="radio" name="radio" id="payment" value="payment" />
                  </label>
                Transfers bank   
                <label>
                <input type="radio" name="radio" id="Cash" value="Cash" />
                </label>
                Cash</div></td>
              </tr>
              <tr>
                <td><div align="right">Method</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <input type="radio" name="radio" id="Today payment" value="Today payment" />
                  Today payment            </label>
                  <label>
                  <input type="radio" name="radio" id="Hold in 24 Hours" value="Hold in 24 Hours" />Hold in 24 Hours</label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Emergency</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"></div></td>
              </tr>
              <tr>
                <td><div align="right">Contact Name</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"><label>
                  <input type="text" name="name_emergency" id="name_emergency" />
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Passport number</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left"><label>
                  <input type="text" name="passporthelp" id="passporthelp" />

                  </label>                  
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Preferences for food</div></td>
                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <textarea name="food" id="food" cols="45" rows="5"></textarea>
                  </label>
                </div></td>
              </tr>
              <tr>
                <td><div align="right">Medical conditions</div></td>

                <td><div align="center">:</div></td>
                <td><div align="left">
                  <label>
                  <textarea name="medical" id="medical" cols="45" rows="5"></textarea>
                  </label>
                </div></td>
              </tr>
              <tr>
                <td colspan="3"> </td>
              </tr>
              <tr>
                <td colspan="3"><div align="right">
                  <label>
                  <input type="button" name="back" id="back" value="Back" onclick="TabbedPanels1.showPanel(1); return false;"/>		
                
                  <input type="button" name="Button" id="Submit" value="Next" onclick="TabbedPanels1.showPanel(3); return false;" />
                  </label>
                </div></td>
              </tr>
      </table>
     <? } ?>
    </div>
    <div class="TabbedPanelsContent">



   	  <p align="center">Your Reservertion </p>
        <hr style="width: 100%; height: 2px;">
      <table border="0" align="center">
          <tr>
            <td width="31%"><div align="right">Code & Name trip </div></td>
            <td width="2%"><div align="center">:</div></td>
            <td width="67%"><? echo $tripname; ?></td>
          </tr>
          <tr>
            <td><div align="right">Starting date </div></td>
            <td><div align="center">:</div></td>
            <td><? echo $datestart; ?></td>
          </tr>
          <tr>
            <td><div align="right">End date </div></td>
            <td><div align="center">:</div></td>
            <td><? echo $dateend; ?></td>
          </tr>
      </table>
        <p align="center">Co-travelers Detail</p>
        <hr style="width: 100%; height: 2px;">
   	  <table border="0" align="center">
<tr>


<td>
<div id="readroot" style="display: none" align="center">
<p class="hr"> </p>
<table>
<tr>
<td>

<input type="button" value="[-] Co-Traveler" style="font-size: 10px" onClick="this.parentNode.parentNode.removeChild(this.parentNode);" align="left"><br><br>
  <table width="100%" border="0">
    <tr>
      <td width="39%"><div align="right">Firstname</div></td>
      <td width="2%"><div align="center"></div></td>
      <td width="59%">
        <label>
          <input type="text" name="Name1_co" id="Name1_co">
        </label>
      </td>
    </tr>
     <tr>
      <td width="39%"><div align="right">Lastname</div></td>
      <td width="2%"><div align="center"></div></td>
      <td width="59%">
        <label>
          <input type="text" name="Name2_co" id="Name2_co">
        </label>
      </td>
    </tr>
    <tr>
      <td><div align="right">Date of birth</div></td>
      <td><div align="center">:</div></td>
      <td><input type="text" name="Dateofbirth_co" id="Dateofbirth_co" /></td>
    </tr>
    <tr>
      <td><div align="right">Gender</div></td>
      <td><div align="center">:</div></td>
      <td>
      <label>
          <select name="gender_co" id="gender_co">
              <option value="male" selected="selected">Male</option>
              <option value="female">Female</option>
          </select>
      </label>
	  </td>
    </tr>
    <tr>
      <td><div align="right">Size of T-Shirt</div></td>
      <td><div align="center">:</div></td>

      <td>
      <label>
          <select name="size-shirt_co" id="size-shirt_co">
              <option value="s" selected="selected">S</option>
              <option value="m">M</option>
              <option value="l">L</option>
              <option value="XL">XL</option>
              <option value="XXL">XXL</option>
              <option value="XXXL">XXXL</option>
          </select>
      </label>
      </td>
    </tr>
    </table>
  </table>
  <input name="ref" type="hidden" value="" />
</div>
<form >
  <div align="right"><span id="writeroot"></span>
    <input type="button" value="[+] Co-Traveler" onClick="moreFields()">
                                                                                                                           
    <input type="submit" value="Send form">
  </div>
  </form>

  </td>
  </tr>
</table><br /><input name="tripname" type="hidden" value="'<? echo $tripname; ?>'">

<input name="datestart" type="hidden" value="'<? echo $datestart; ?>'">
<input name="dateend" type="hidden" value="'<? echo $dateend; ?>'">
<input name="price" type="hidden" value="'<? echo $price; ?>'">
<input name="country" type="hidden" value="'<? echo $country; ?>'">
<input name="attributes" type="hidden" value="'<? echo $attributes; ?>'">
<input name="supplement" type="hidden" value="'<? echo $supplement; ?>'">
<br />  <input type="button" name="back" id="back" value="Back" onclick="TabbedPanels1.showPanel(2); return false;"/>
    </div>
  </div>
</div>
<script type="text/javascript">
<!--
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
//-->
</script>


On Submit code - after sending email

<?php
global $mainframe;


$database->setQuery( "SELECT * FROM aj_chronoforms_3" );
 if (!$database->query()) {
   echo $database->stderr();
   return false;
 }

$idra = $database->getNumRows();
$idplus = '1';
$idr = $idra + $idplus;

$custom_tag = '<meta http-equiv="refresh" content="5; url=index.php?option=com_chronocontact&chronoformname=Confirm&no=$idr" >';
$mainframe->addCustomHeadTag($custom_tag);
?>
<p>Thank You.</p>
<p>Please wait...!</p>
This topic is locked and no more replies can be posted.