je sais que mon script n'est pas optimal et comporte surement des erreurs, je veux savoir es que je suis sur la bonne voie, si c'est pas le cas je veux apprendre et m'améliorer.
mon but est de charger un select dynamiquement, est un autre par rapport au choix du premier.
//******************** mon script
<? require_once('Connections/conect.php');
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
if (isset($HTTP_GET_VARS['wil']))
{
$wil=$HTTP_GET_VARS['wil'];
mysql_select_db($database_conect, $conect);
$query_Rec_com = "SELECT * FROM communes WHERE wilaya='$wil' ORDER BY COMMUNE ASC";
$Rec_com = mysql_query($query_Rec_com, $conect) or die(mysql_error());
$row_Rec_com = mysql_fetch_assoc($Rec_com);
$totalRows_Rec_com = mysql_num_rows($Rec_com);
}
mysql_select_db($database_conect, $conect);
$query_Rec_wil = "SELECT wilaya FROM wilayas ORDER BY wilaya ASC";
$Rec_wil = mysql_query($query_Rec_wil, $conect) or die(mysql_error());
$row_Rec_wil = mysql_fetch_assoc($Rec_wil);
$totalRows_Rec_wil = mysql_num_rows($Rec_wil);
?>
<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="">
<p> </p>
<table width="27%">
<tr>
<td><select name="wil" id="wil" onChange="javascript:document.location.href=(this.value);" STYLE="font-size : 9pt">
<?php
do {
$wilaya=$row_Rec_wil['wilaya'];
?>
<option value="<?php printf("%s?wil=$wilaya", $currentPage); ?>" <?php if (!(strcmp($wilaya, $wilaya))) {echo "SELECTED";} ?>><font size="2"><?php echo $wilaya; ?></font></option>
<?php
} while ($row_Rec_wil = mysql_fetch_assoc($Rec_wil));
$rows = mysql_num_rows($Rec_wil);
if($rows > 0) {
mysql_data_seek($Rec_wil, 0);
$Rec_wil = mysql_fetch_assoc($Rec_wil);
}
if (isset($HTTP_GET_VARS['wil']))
{
?>
<option value="<?php echo $wil; ?>" selected><?Php echo $wil; ?></option>
<?Php } ?>
</select>
</td>
</tr>
<tr>
<td><select name="select" id="select" STYLE="font-size : 9pt">
<?php
do {
$commune=$row_Rec_com['commune'];
?>
<option value="<?php echo $commune; ?>" <?php if (!(strcmp($commune, $commune))) {echo "SELECTED";} ?>><font size="2"><?php echo $commune; ?></font></option>
<?php
} while ($row_Rec_com = mysql_fetch_assoc($Rec_com));
$rows = mysql_num_rows($Rec_com);
if($rows > 0) {
mysql_data_seek($Rec_com, 0);
$Rec_com = mysql_fetch_assoc($Rec_com);
}
?>
</select></td>
</tr>
</table>
<p> </p>
</form>
</body>
</html>
//*******************
//********************* table commune
CREATE TABLE `communes` (
`wilaya` varchar(25) NOT NULL default 'Blida',
`commune` varchar(35) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `communes`
--
INSERT INTO `communes` VALUES ('Alger', 'Ain Beniane');
INSERT INTO `communes` VALUES ('Alger', 'Ain Taya');
INSERT INTO `communes` VALUES ('Alger', 'Alger Centre');
INSERT INTO `communes` VALUES ('Alger', 'Bab El Oued');
INSERT INTO `communes` VALUES ('Alger', 'Bab Ezzouar');
INSERT INTO `communes` VALUES ('Alger', 'Baba Hassen');
INSERT INTO `communes` VALUES ('Alger', 'Bachdjarah');
INSERT INTO `communes` VALUES ('Alger', 'Baraki');
INSERT INTO `communes` VALUES ('Alger', 'Beni Messous');
INSERT INTO `communes` VALUES ('Alger', 'Bir Mourad Rais');
INSERT INTO `communes` VALUES ('Alger', 'Birkhadem');
INSERT INTO `communes` VALUES ('Alger', 'Bologhine');
INSERT INTO `communes` VALUES ('Alger', 'Bordj El Bahri');
INSERT INTO `communes` VALUES ('Alger', 'Bordj El Kiffane');
INSERT INTO `communes` VALUES ('Alger', 'Boudouaou');
INSERT INTO `communes` VALUES ('Alger', 'Bourouba');
INSERT INTO `communes` VALUES ('Alger', 'Bouzareah');
INSERT INTO `communes` VALUES ('Alger', 'Casbah');
INSERT INTO `communes` VALUES ('Alger', 'Cheraga');
INSERT INTO `communes` VALUES ('Alger', 'Dar El Beida');
INSERT INTO `communes` VALUES ('Alger', 'Dely Ibrahim');
INSERT INTO `communes` VALUES ('Alger', 'Douera');
INSERT INTO `communes` VALUES ('Alger', 'Draria');
INSERT INTO `communes` VALUES ('Alger', 'El Achour');
INSERT INTO `communes` VALUES ('Alger', 'El Biar');
INSERT INTO `communes` VALUES ('Alger', 'El Hamma');
INSERT INTO `communes` VALUES ('Alger', 'El Harrach');
INSERT INTO `communes` VALUES ('Alger', 'El Madania');
INSERT INTO `communes` VALUES ('Alger', 'Al Magharia');
INSERT INTO `communes` VALUES ('Alger', 'El Mouradia');
INSERT INTO `communes` VALUES ('Alger', 'Gué de Constantine');
INSERT INTO `communes` VALUES ('Alger', 'Hammamet');
INSERT INTO `communes` VALUES ('Alger', 'Haraoua');
INSERT INTO `communes` VALUES ('Alger', 'Hussein Dey');
INSERT INTO `communes` VALUES ('Alger', 'Hydra');
INSERT INTO `communes` VALUES ('Alger', 'Kheraicia');
INSERT INTO `communes` VALUES ('Alger', 'Kouba');
INSERT INTO `communes` VALUES ('Alger', 'Les Eucalyptus');
INSERT INTO `communes` VALUES ('Alger', 'Mehalma');
INSERT INTO `communes` VALUES ('Alger', 'Marsa');
INSERT INTO `communes` VALUES ('Alger', 'Mohammadia');
INSERT INTO `communes` VALUES ('Alger', 'Oued Koriche');
INSERT INTO `communes` VALUES ('Alger', 'Ouled Chebel');
INSERT INTO `communes` VALUES ('Alger', 'Ouled Fayet');
INSERT INTO `communes` VALUES ('Alger', 'Rahmania');
INSERT INTO `communes` VALUES ('Alger', 'Rais Hamidou');
INSERT INTO `communes` VALUES ('Alger', 'Reghaia');
INSERT INTO `communes` VALUES ('Alger', 'Rouiba');
INSERT INTO `communes` VALUES ('Alger', 'Sidi Mhamed');
INSERT INTO `communes` VALUES ('Alger', 'Sidi Moussa');
INSERT INTO `communes` VALUES ('Alger', 'Souidania');
INSERT INTO `communes` VALUES ('Alger', 'Staouali');
INSERT INTO `communes` VALUES ('Alger', 'Saoula');
INSERT INTO `communes` VALUES ('Alger', 'Tessala El Mardja');
INSERT INTO `communes` VALUES ('Alger', 'Zeralda');
INSERT INTO `communes` VALUES ('Alger', 'Ben Aknoune');
INSERT INTO `communes` VALUES ('Alger', 'Belouizded');
INSERT INTO `communes` VALUES ('Alger', 'Oued Smar');
INSERT INTO `communes` VALUES ('Alger', 'Oued Romane');
INSERT INTO `communes` VALUES ('Alger', 'Birtouta');
//*******************************
//*********************** table wilayas
CREATE TABLE `wilayas` (
`wilaya` varchar(15) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `wilayas`
--
INSERT INTO `wilayas` VALUES ('Alger');
INSERT INTO `wilayas` VALUES ('Blida');
INSERT INTO `wilayas` VALUES ('Tipasa');
INSERT INTO `wilayas` VALUES ('Boumerdes');
//******************