Automatique refresh form

[deuxk]

Hi,

 

I try to make refresh my form page when the user chose a country (pays, i'am french). I have program all think for change and load the new states but when i change the country the page don't refresh and i don't have idea for make this work!!! I show you my code and if you have solution for it's really appreciate.

 

thanks

 

<?
include("administration/dbconnect.php");

$sign_up = 'modules/signup_user/';

define( "FILE_COUNTRY", $sign_up . "country.txt" );
define( "FILE_CA_PROVINCES", $sign_up . "provinces.ca.txt" );
define( "FILE_US_STATES", $sign_up . "states.us.txt" );

function	submit( $var ){
global	$HTTP_POST_VARS, $HTTP_GET_VARS ;
return ( strlen(trim($HTTP_POST_VARS[ $var ])) ) ? trim( $HTTP_POST_VARS[ $var ] ) : trim( $HTTP_GET_VARS[ $var ] );
} 


function	displayCountry( $default = "Canada" ){
print "<select name='country' onchange='document.frmUser.submit();'>\n" ;
print "<option value=''>Select</option>\n" ;

$countries = file( FILE_COUNTRY );
foreach( $countries as $c ){
	$value = htmlspecialchars(trim($c)) ;
	$selected = strtoupper($default) == strtoupper(trim($c)) ? " selected " : "" ;
	print "<option value=\"$value\" $selected>$value</option>\n" ;
}
print "</select>\n" ;
}




function generateActivation ($length = 18)
{
  $activation_random = "";
  $possible = "0123456789bcdfghjkmnpqrstvwxyz"; 
  $i = 0; 
  while ($i < $length) { 
    $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
    if (!strstr($activation_random, $char)) { 
      $activation_random .= $char;
      $i++;
    }
  }
  return $activation_random;
}


function VerifierAdresseMail($adresse)
{
$Syntaxe='#^[\w.-]+@[\w.-]+\.[a-zA-Z]{2,5}$#';
if(preg_match($Syntaxe,$adresse))
return true;
else
return false;
} 







$erreur = '';
$inscription = '';


if (isset($_POST['submit'])) {

// verifier si les champs sont rempli au complet
if ($_POST['login'] != null && $_POST['nom']!= null && $_POST['prenom'] != null && $_POST['adresse'] != null && $_POST['region'] != null && $_POST['codepostal'] != null && $_POST['telephone'] != null && $_POST['courriel'] != null && $_POST['courriel_verif'] != null && $_POST['password'] != null && $_POST['password_verif'] != null) {



$login = addslashes($_POST['login']);
$nom = addslashes($_POST['nom']);
$prenom = addslashes($_POST['prenom']);
$adresse = addslashes($_POST['adresse']);
$region = $_POST['region'];
$codepostal = addslashes($_POST['codepostal']);
$telephone = addslashes($_POST['telephone']);
$courriel= htmlentities($_POST['courriel']);
$courriel_verif = htmlentities($_POST['courriel_verif']);
$password = md5($_POST['password']);
$password_verif = md5($_POST['password_verif']);
$activation = generateActivation();
$status = 0;


// verifier si le login est deja pris
$requete = mysql_query("SELECT login FROM users WHERE login = '$login'") or die(mysql_error());
$compte = mysql_num_rows($requete);

if ($compte == 0) {

	// verification si le email est ecrit correct et si il est deja pris!
	if ($courriel == $courriel_verif) 
	{
	$requete = mysql_query("SELECT courriel FROM users WHERE courriel = '$courriel'") or die(mysql_error());
	$compte = mysql_num_rows($requete);

	if ($compte == 0) {

		 // verification si le email est correctement ecris.
		 if(VerifierAdresseMail($courriel)) 
		 	{
				//verification si les 2 password sont pareille
				if ($password == $password_verif) {

					//verification si le password a plus de 4 caractere
					if (strlen($password) >= 4) {



						// enregistrer & link a l'acceuil 
						mysql_query('INSERT INTO users (id, login, prenom, nom, adresse, region, codepostal, telephone, courriel, password, activation, status, timestamp) VALUES ("","'.$login.'", "'.$prenom.'", "'.$nom.'", "'.$adresse.'", "'.$region.'", "'.$codepostal.'", "'.$telephone.'","'.$courriel.'","'.$password.'","'.$activation.'","'.$status.'","'.$time.'")');
						$sujet = 'Votre activation';
						$expediteur = 'Administration';
						$message = 'Cliquer ici pour activer votre compte : https://www.filmoptionsales.com/site.php?login='.$login.'&courriel='.$courriel.'&activation='.$activation;
						mail($courriel, $sujet, $message, $expediteur);

						$inscription = 'ok';


					} else { $erreur = $txt17;  }
				} else { $erreur = $txt18;  }
			} else { $erreur = $txt19;  }
		} else { $erreur = $txt20;  }
	} else { $erreur = $txt21; }
} else { $erreur = $txt22; }
} else { $erreur = $txt23; }
}




if ($inscription == '') {
?>
<center>
<table width="600" CELLPADDING= CELLSPACING=0>
	<tr>
	<td align="center" class="text1"><h3><? echo $txt25; ?></h3></td>
	</tr>
</table>

<form action="site.php?cmd=inscription&type=user" method="post" name="frmUser">
<br />

<? if ($erreur != '') {?>
<table width="600" BORDER=1 CELLPADDING= CELLSPACING=0 align="center">
	<tr>
	<td align="center" style="color:red;"><? echo $txt26; ?><br /><br />
	<? echo $erreur; ?><br /><br /></td>
	</tr>
</table>
<br /><br />
<?
}
?>

<table width="600" BORDER=0 CELLPADDING= CELLSPACING=0 align="center">
<tr>
<td width="100" class="text1"><? echo $txt3; ?></td><td><input type="text" size="30" name="login" onKeyPress="return login(this, event)" value="<? echo $_POST['login']; ?>" /></td>
</tr>
<tr>
<td width="100" class="text1"><? echo $txt4; ?></td><td class="text1"><input type="text" size="30" name="prenom" onKeyPress="return lettersonly(this, event)"  value="<? echo $_POST['prenom']; ?>" /></td>
<tr>
<td width="100" class="text1"><? echo $txt5; ?></td><td class="text1"><input type="text" size="30" name="nom"  onKeyPress="return lettersonly(this, event)" value="<? echo $_POST['nom']; ?>" /></td>
</tr>
<tr>
<td width="100" class="text1"><? echo $txt6; ?></td><td class="text1"><input type="text" size="50" name="nom"  onKeyPress="return lettersonly(this, event)" value="<? echo $_POST['adresse']; ?>" /></td>
</tr>	

	<tr>
		<td class="text1" nowrap width="140">Ville :</td>
		<td><input type="Text" name="city" size="30" value="<?= submit("city") ?>"></td>
	</tr>

	<tr>
		<td class="text1" nowrap>Pays :</td>
		<td>
		<?
			$defaultCountry = strtoupper( submit( "country" ) ? submit( "country" ) : "United States" );
			displayCountry( $defaultCountry ) ;
		?>				
		</td>
	</tr>

	<tr>
		<td class="text1" nowrap>Province/State :</td>
		<td>
		<?
			if( $defaultCountry == "UNITED STATES" || $defaultCountry == "CANADA" ) {
				$provStates = file( $defaultCountry == "UNITED STATES" ?  FILE_US_STATES : FILE_CA_PROVINCES  );
		?>
				<select name="provOrState">
		<?
				foreach( $provStates as $ps ) {
					print "<option value=\"" . htmlspecialchars(trim($ps)) . "\">" . htmlspecialchars(trim($ps)) . "</option>\n" ;
				}
		?>			
				</select>
		<?		
			} else {	
		?>			
					<input type="Text" name="provOrState" size="30" value="">
		<?
			}
		?>				
		</td>
	</tr>

	<tr>
		<td class="text1" nowrap>Postal Code/Zip Code :</td>
		<td><input type="Text" size="30" name="postalCode" value="<?= submit("postalCode") ?>"></td>
	</tr>




<tr>
<td width="100" class="text1"><? echo $txt10; ?></td><td class="text1"><input type="text" size="30" name="courriel" value="<? echo $_POST['courriel']; ?>" /></td>
</tr>
<tr>
<td width="100" class="text1"><? echo $txt11; ?></td><td class="text1"><input type="text" size="30" name="courriel_verif" value="<? echo $_POST['courriel_verif']; ?>" /></td>
</tr>
<tr>
<td class="text1"><? echo $txt12; ?></td><td class="text1"><input type="password" name="password" value="" /></td>
</tr>
<tr>
<td class="text1"><? echo $txt13; ?></td><td class="text1"><input type="password" name="password_verif" value="" /></td>
</tr>
</table><br />

<input type="submit" name="submit" value="<? echo $txt24; ?>" />
</form>
<a href="site.php"><? echo $txt14; ?></a><br /><br />
</center>
<?
}
else { ?>
<br /><br />
<table align="center">
<tr><td class="text1" align="center"><? echo $txt15; ?></td></tr>
<tr><td class="text1" align="center"><a href="site.php"><? echo $txt16; ?></a><br /></td></tr>
</table>
<br /><br />
<? }
mysql_close();
?>

[Orio]

If you want to refresh the page when a dropdown value is being changed, check the onChange event in javascript.

 

Orio.