<?php require_once('Connections/southall.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "Registration")) {
  $insertSQL = sprintf("INSERT INTO register (family_name, first_name, title, date_birth, nationality, passport_no, home_address, telephone, fax, email, course, level_english, proposed_study, proposed_arrival, family_name2, first_name2, title2, date_birth2, nationality2, passport2, studing2, course2, name3, sex, date_birth3, name3_2, sex3_2, date_birth3_2, comments) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['Family_Name'], "text"),
                       GetSQLValueString($_POST['First_Name'], "text"),
                       GetSQLValueString($_POST['Title'], "text"),
                       GetSQLValueString($_POST['Date_of_Birth'], "text"),
                       GetSQLValueString($_POST['Nationality'], "text"),
                       GetSQLValueString($_POST['PassportN1'], "text"),
                       GetSQLValueString($_POST['Home_Address'], "text"),
                       GetSQLValueString($_POST['Telephone'], "text"),
                       GetSQLValueString($_POST['FAX'], "text"),
                       GetSQLValueString($_POST['Email'], "text"),
                       GetSQLValueString($_POST['Course'], "text"),
                       GetSQLValueString($_POST['Level_of_English'], "text"),
                       GetSQLValueString($_POST['Proposed_Length_of_Study'], "text"),
                       GetSQLValueString($_POST['Proposed_Arrival_Date'], "text"),
                       GetSQLValueString($_POST['Spouses_Family_Name'], "text"),
                       GetSQLValueString($_POST['Spouses_First_Name'], "text"),
                       GetSQLValueString($_POST['Spouses_Title '], "text"),
                       GetSQLValueString($_POST['Spouses_DateofBirth'], "text"),
                       GetSQLValueString($_POST['Spouses_Nationality'], "text"),
                       GetSQLValueString($_POST['Spouses_Passport_N'], "text"),
                       GetSQLValueString($_POST['Will_spouse_bestudying'], "text"),
                       GetSQLValueString($_POST['Spouses_Course '], "text"),
                       GetSQLValueString($_POST['Child1Name'], "text"),
                       GetSQLValueString($_POST['Child1Sex '], "text"),
                       GetSQLValueString($_POST['Child1 Date_ofBirth'], "text"),
                       GetSQLValueString($_POST['Child2Name'], "text"),
                       GetSQLValueString($_POST['Child2Sex '], "text"),
                       GetSQLValueString($_POST['Child2DateofBirth'], "text"),
                       GetSQLValueString($_POST['OtherComments'], "text"));

  mysql_select_db($database_southall, $southall);
  $Result1 = mysql_query($insertSQL, $southall) or die(mysql_error());

/*  $insertGoTo = "";//http://www.sslmo.co.uk/thankyou.html
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));*/
   $cadena.="Family Name:". $_POST['Family_Name']."  <br> 
";
   $cadena.="First Name:". $_POST['First_Name']."  <br> 
";
   $cadena.="Title:". $_POST['Title']."  <br> 
";
   $cadena.="Date of Birth:". $_POST['Date_of_Birth']."  <br> 
";
   $cadena.="Nationality:". $_POST['Nationality']."  <br> 
";
   $cadena.="Passport No:". $_POST['PassportN1']."  <br> 
";
   $cadena.="Home_Address:". $_POST['Home_Address']."  <br> 
";
   $cadena.="Telephone:". $_POST['Telephone']."  <br> 
";
   $cadena.="FAX:". $_POST['FAX']."  <br> 
";
   $cadena.="Email:". $_POST['Email']."  <br> 
";
   $cadena.="Course:". $_POST['Course']."  <br> 
";
   $cadena.="Level of English:". $_POST['Level_of_English']."  <br> 
";
   $cadena.="Proposed Length of Study:". $_POST['Proposed_Length_of_Study']."  <br> 
";
   $cadena.="Proposed Arrival Date:". $_POST['Proposed_Arrival_Date']."  <br> 
";
   $cadena.="Spouses Family Name:". $_POST['Spouses_Family_Name']."  <br> 
";
   $cadena.="Spouses First Name:". $_POST['Spouses_First_Name']."  <br> 
";
   $cadena.="Spouses Title:". $_POST['Spouses_Title ']."  <br> 
";
   $cadena.="Spouses Date of Birth:". $_POST['Spouses_DateofBirth']."  <br> 
";
   $cadena.="Spouses Nationality:". $_POST['Spouses_Nationality']."  <br> 
";
   $cadena.="Spouses Passport N:". $_POST['Spouses_Passport_N']."  <br> 
";
   $cadena.="Will spouse be studying:". $_POST['Will_spouse_bestudying']."  <br> 
";
   $cadena.="Spouses Course:". $_POST['Spouses_Course ']."  <br> 
";
   $cadena.="Child 1 Name:". $_POST['Child1Name']."  <br> 
";

   $cadena.="Child 1 Sex:". $_POST['Child1Sex ']."  <br> ";
   $cadena.="Child 1 Date of Birth:". $_POST['Child1 Date_ofBirth']."  <br> 
";
   $cadena.="Child 2 Name:". $_POST['Child2Name']."  <br> 
";
   $cadena.="Child 2 Sex:". $_POST['Child2Sex ']."  <br> 
";
   $cadena.="Child 2 Date of Birth:". $_POST['Child2DateofBirth']."  <br> 
";
   $cadena.="Other Comments". $_POST['OtherComments']."  <br> 
";
   
   $email_from=$_POST['Email'];
   $email_address="info@sslmo.co.uk";
   $subject="New Online Registration";
   $msg=$cadena;
   mail($email_address,$subject,$msg,"Content-type: text/html\nFROM: <".$email_from.">\nX-Priority: 1");
   
   //user copy
   $msg="This is one copy of you registration form, in www.sslmo.co.uk  \n".$msg;
   mail($email_from,"RE: ".$subject,$msg,"Content-type: text/html\nFROM: <".$email_address.">\nX-Priority: 1");

mail("sistemas@multinternet.net",$subject,$msg,"Content-type: text/html\nFROM: <".$email_from.">\nX-Priority: 1");
  
  
}
?>
<!-- saved from url=(0014)about:internet -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/interna_p.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>SSMLO::::</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">td img {display: block;}body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
</style>
<!--Fireworks 8 Dreamweaver 8 target.  Created Wed Nov 21 14:07:58 GMT-0500 2007-->
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {font-family: Geneva, Arial, Helvetica, sans-serif}
.style2 {font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
}
.style3 {
	font-size: 14px;
	font-weight: bold;
}
.style5 {color: #FFFFFF}
.Estilo1 {
	color: #FF6600;
	font-weight: bold;
}
.style1 {font-size: 11px}
.style21 {font-size: 12px}
-->
</style>
<script type="text/javascript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_validateForm() { //v4.0
  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
    if (val) { nm=val.name; if ((val=val.value)!="") {
      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
        if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
      } else if (test!='R') { num = parseFloat(val);
        if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
          min=test.substring(8,p); max=test.substring(p+1);
          if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
    } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
  } if (errors) alert('The following error(s) occurred:\n'+errors);
  document.MM_returnValue = (errors == '');
}
//-->
</script>
<!-- InstanceEndEditable -->
</head>
<body bgcolor="#ffffff">
<table border="0" cellpadding="0" cellspacing="0" width="994">
<!-- fwtable fwsrc="interna_p.png" fwbase="interna_p.jpg" fwstyle="Dreamweaver" fwdocid = "389970601" fwnested="0" -->
  <tr>
   <td><img src="images/spacer.gif" width="216" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="751" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="27" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
  </tr>

  <tr>
   <td colspan="3"><img name="interna_p_r1_c1" src="images/interna_p_r1_c1.jpg" width="994" height="177" border="0" id="interna_p_r1_c1" usemap="#m_interna_p_r1_c1" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="177" border="0" alt="" /></td>
  </tr>
  <tr>
   <td valign="top" background="images/interna_p_r3_c1.jpg"><img src="images/interna_p_r2_c1.jpg" alt="" name="interna_p_r2_c1" width="216" height="438" border="0" usemap="#interna_p_r2_c1Map" id="interna_p_r2_c1" /></td>
   <td rowspan="3" valign="top"><table width="100%" border="0">
     <tr>
       <td><!-- InstanceBeginEditable name="contenif" -->
         <table width="90%"  border="0" align="center" cellpadding="0" cellspacing="0">
           <tr>
             <td>&nbsp;</td>
           </tr>
           <tr>
             <td><form action="www.multimedia.com.co/formularios/formulariosmym.php" method="post" enctype="application/x-www-form-urlencoded" name="form1" id="form1">
                 <div align="center" class="txt">
                   <div align="center" class="txt style1">
                     <div align="center" class="txt style2">
                       <p>Para nós será um prazer, por favor, deixa seu detalhes  e comentários,  um funcionário entrará em contato  com você.</p>
                     </div>
                     <table width="73%" border="1" align="center" cellpadding="2" cellspacing="2" bordercolor="#CCCCCC" class="txt2">
                       <tr bordercolor="#FFFFFF">
                         <td width="19%" class="style2"><div align="right" class="txt">Nome completo:</div></td>
                         <td width="33%" class="txt"><div align="center"><font color="#FFFFFF"><b>
                             <input name="nome" class="campos" id="nome" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" 
                  maxlength="300" />
                         </b></font></div></td>
                         <td width="48%" rowspan="9" valign="top" class="texto"><table width="30%"  border="0" align="center" cellpadding="0" cellspacing="0">
                             <tr>
                               <td><div align="center" class="style2">Observação</div></td>
                             </tr>
                             <tr>
                               <td><div align="center"><b>
                                   <textarea name="observaciones" cols="25" rows="8" class="campos" style="BACKGROUND-COLOR: #AFC7ED"></textarea>
                               </b></div></td>
                             </tr>
                         </table></td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td valign="top" class="style2"><div align="right">
                             <p class="txt">Telephone:</p>
                         </div></td>
                         <td class="txt"><div align="center"><font color="#FFFFFF"><b>
                             <input name="Telephone" class="campos" id="Telephone" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" 
                  maxlength="300" />
                         </b></font></div></td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td valign="top" class="style2"><div align="right">Fax:</div></td>
                         <td class="txt"><div align="center"><font color="#FFFFFF"><b>
                             <input name="fax" class="campos" id="fax" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" 
                  maxlength="300" />
                         </b></font></div></td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td valign="top" class="style2"><div align="right">
                             <p class="txt">Email:</p>
                         </div></td>
                         <td class="txt"><div align="center"><font color="#FFFFFF"><b><font color="#FFFFFF"><b>
                             <input name="mail" class="campos" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" 
                  maxlength="300" />
                         </b></font></b></font></div></td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td valign="top" class="style2"><div align="right">
                             <p class="txt">Trabalho:</p>
                         </div></td>
                         <td class="txt"><div align="center"><font color="#FFFFFF"><b>
                             <input name="trabalho" class="campos" id="trabalho" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" 
                  maxlength="300" />
                         </b></font></div></td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td valign="top" class="style2"><div align="right">
                             <p class="txt">Endereço:</p>
                         </div></td>
                         <td valign="top" class="txt"><div align="center"><font color="#FFFFFF"><b>
                             <input name="endereço" class="campos" id="endereço" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" 
                  maxlength="300" />
                         </b></font></div></td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td align="right" valign="top" class="style2">Cidade:</td>
                         <td align="right" valign="top" class="style2"><div align="center"><font color="#FFFFFF"><b>
                           <input name="cidade" class="campos" id="cidade" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" />
                         </b></font></div></td>
                       </tr>
                       
                       <tr bordercolor="#FFFFFF">
                         <td height="2" align="right" valign="top" class="style2">País:</td>
                         <td align="center" valign="top" class="texto"><font color="#FFFFFF"><b>
                           <input name="pais" class="campos" id="pais" 
                  style="BACKGROUND-COLOR: #AFC7ED" size="20" />
                         </b></font></td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td height="6" align="right" valign="top" class="style4">&nbsp;</td>
                         <td align="center" valign="top" class="texto">&nbsp;</td>
                       </tr>
                       <tr bordercolor="#FFFFFF">
                         <td height="57" colspan="3" align="right" valign="top" class="texto"><div align="center">
                             <p class="txt"><font color="#FFFFFF"><b>
                               <input name="Submit" type="submit" class="campos" value="Send" />
                               </b></font><font color="#000000"><b> <font color="#000000"><b>
                               <input name="url" type="hidden" id="url" value="http://www.multimedia.com.co.com/gracias.html" />
                               </b></font> <font color="#000000"><b>
                               <input name="contacto" type="hidden" id="contacto" value="info@sslmo.co.uk" />
                               </b></font>
                               <input name="asunto" type="hidden" id="asunto" value="Contact southall" />
                             </b></font> </p>
                         </div></td>
                       </tr>
                     </table>
                   </div>
                   <div align="center" class="texto">&nbsp;</div>
                   <div align="center"></div>
                 </div>
               <div align="center"></div>
             </form></td>
           </tr>
         </table>
       <!-- InstanceEndEditable --></td>
     </tr>
   </table>     <p>&nbsp;</p>
    </td>
   <td rowspan="3"><img name="interna_p_r2_c3" src="images/interna_p_r2_c3.jpg" width="27" height="455" border="0" id="interna_p_r2_c3" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="438" border="0" alt="" /></td>
  </tr>
  <tr>
   <td valign="top" background="images/interna_p_r3_c1.jpg"><img name="interna_p_r3_c1" src="images/interna_p_r3_c1.jpg" width="216" height="10" border="0" id="interna_p_r3_c1" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="10" border="0" alt="" /></td>
  </tr>
  <tr>
   <td height="7" valign="top" background="images/interna_p_r4_c1.jpg"><img name="interna_p_r4_c1" src="images/interna_p_r4_c1.jpg" width="216" height="7" border="0" id="interna_p_r4_c1" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="7" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="3" valign="baseline"><img src="images/interna_p_r5_c1.jpg" alt="" name="interna_p_r5_c1" width="994" height="118" border="0" usemap="#interna_p_r5_c1Map" id="interna_p_r5_c1" /></td>
   <td><img src="images/spacer.gif" width="1" height="118" border="0" alt="" /></td>
  </tr>
</table>
<map name="m_interna_p_r1_c1" id="m_interna_p_r1_c1">
<area shape="rect" coords="835,123,973,155" href="../church.html" alt="" />
</map>

<map name="interna_p_r5_c1Map" id="interna_p_r5_c1Map"><area shape="rect" coords="479,23,714,83" href="http://www.multinternet.net" target="_blank" />
<area shape="rect" coords="48,11,96,39" href="../index.htm" />
</map>
<map name="interna_p_r2_c1Map" id="interna_p_r2_c1Map">
<area shape="rect" coords="28,405,106,429" href="contact_p.htm" />
<area shape="rect" coords="21,382,107,399" href="video_p.htm" />
<area shape="rect" coords="20,360,134,378" href="online_p.php" />
<area shape="rect" coords="29,336,165,357" href="staff_p.htm" />
<area shape="rect" coords="19,311,154,331" href="bro_p.php" /><area shape="rect" coords="22,289,160,309" href="rec_p.php" /><area shape="rect" coords="24,265,167,286" href="exp_p.php" /><area shape="rect" coords="20,245,175,263" href="gal_p.php" /><area shape="rect" coords="22,221,176,244" href="onde_p.htm" />
<area shape="rect" coords="21,202,176,219" href="novi_p.htp" /><area shape="rect" coords="20,182,175,199" href="matri_p.php" /><area shape="rect" coords="21,155,175,179" href="fees_p.htm" />
<area shape="rect" coords="23,137,174,153" href="social_p.htm" /><area shape="rect" coords="22,7,161,26" href="index_p.htm" />
<area shape="rect" coords="23,28,173,47" href="quien_p.htm" />
<area shape="rect" coords="23,49,172,68" href="curso_p.htm" />
<area shape="rect" coords="23,71,172,90" href="dep_p.htm" />
<area shape="rect" coords="24,94,172,113" href="gen_p.htm" />
<area shape="rect" coords="27,115,173,134" href="aco_p.htm" />
</map></body>
<!-- InstanceEnd --></html>