1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130
| //variable pour ne pas afficher d'erreur
if (isset($_GET['t'])){ $t = ($_GET['t']); }
if (isset($_GET['a'])){ $a = ($_GET['a']); }
if (isset($_GET['c'])){ $c = ($_GET['c']); }
if (isset($_GET['cp'])){ $cp = ($_GET['cp']); }
if (isset($_GET['area'])){ $id = ($_GET['area']); }
if (isset($_GET['dep'])){ $dep = ($_GET['dep']); }
if (isset($_GET['offres'])){ $type = ($_GET['offres']); }
//Liste des regions
$sql_region="SELECT * FROM region";
$req_region=mysql_query($sql_region,$cnx);
$result_region=mysql_fetch_assoc($req_region);
//Pour savoir nous sommes dans quelle region
$sql_dept = " SELECT departement.nom_departement, departement.id_region, departement.code, region.nom_region,departement.url_departement
FROM departement
LEFT JOIN region ON departement.id_region = region.id_region
WHERE region.url_region = '".$id."' ";
$req_dept=mysql_query($sql_dept,$cnx);
$result_dept=mysql_fetch_assoc($req_dept);
//Liste des departements de la region selectionnée
$sql_dept1 = " SELECT departement.nom_departement, departement.id_region, departement.code, region.nom_region,departement.url_departement
FROM departement
LEFT JOIN region ON departement.id_region = region.id_region
WHERE departement.url_departement = '".$dep."' ";
$req_dept1=mysql_query($sql_dept1,$cnx);
$result_dept1=mysql_fetch_assoc($req_dept1);
//Pour afficher le nom de la region
$sql_nom_region = " SELECT departement.nom_departement, departement.id_region, departement.code, region.nom_region,departement.url_departement
FROM departement
LEFT JOIN region ON departement.id_region = region.id_region
WHERE
region.url_region = '".$id."'";
$req_nom_region=mysql_query($sql_nom_region,$cnx);
$result_nom_region=mysql_fetch_assoc($req_nom_region);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<link rel='StyleSheet' href="/Service/CSS/style.css" type="text/css">
<script type="text/javascript" src="js/jquery.js"></script>
<script langage="javascript">
function change_col_height_max_selected_to(val){
document.forms["form"].elements["col_height_max"].options[val].selected = true;
}
</script>
</head>
<body>
<div id='cadre_moteur_recherche'>
<?php
if(isset($_GET['offres']) or isset($_GET['demandes'])){
echo" <form action='index.php' method='get' enctype='multipart/form-data'>
<input type='hidden' name='p' value='annonces'>
";
if ($_GET['offres']=="offres"){
echo"<input type='hidden' name='offres' value='offres'>";
}
if ($_GET['offres']=="demandes"){
echo"<input type='hidden' name='offres' value='demandes'>";
}
?>
<input type="hidden" name="<?php if(isset($_GET['a'])) echo 'a' ?>" value="<?php if(isset($a)) echo $a ?>" />
<div class='recherce_titre input '>
<label>Rechercher dans le titre</label>
<input type="text" name="<?php echo 't' ?>" value="<?php if(isset($t)) echo $t ?>" />
</div>
<?php
echo"
<div class='select_ville'>
<label>Votre ville</label>
<input type='hidden' id='area' name='area' value=".$id.">
<input type='hidden' id='dep' name='dep' value=".$dep." >
<select onchange='tab=this.value.split(\"|\");document.getElementById(\"area\").value=tab[0];document.getElementById(\"dep\").value=tab[1];'>";
if(!empty($_GET['area'])){
echo" <option value='".$id."|' >".$result_dept['nom_region']."</option> ";
}
echo"<option value='|' style='background-color:#c9e750;' "; echo (empty($_GET["area"]) && empty($_GET["dep"]))?'selected="selected"':''; echo">Toute la France</option> ";
if(!empty($_GET['area'])){
echo" <optgroup style='background-color:#dcdcc3;' label='-- Departement --'></optgroup> ";
}
//Liste des departement de la région
while($result_dept){
echo" <option value='".$id."|".$result_dept['url_departement']."' "; echo ($_GET["dep"] == $result_dept['url_departement'])?'selected="selected"':''; echo">".$result_dept['nom_departement']."</option> ";
$result_dept=mysql_fetch_assoc($req_dept);
}
echo" <optgroup style='background-color:#dcdcc3;' label='-- Region --'></optgroup> ";
//Liste des regions
while($result_region) {
echo" <option value='".$result_region['url_region']."|' >".$result_region['nom_region']."</option> ";
$result_region=mysql_fetch_assoc($req_region);
}
echo"
</select>
</div>
";
?>
<div class='code_postal input '>
<label>Code postal</label>
<input type="text" name="cp" value="<?php if(isset($cp)) echo $cp ?>" />
</div>
<div class='select_categorie'>
<label>Séléctionner une catégorie</label>
<select name='c' id='c' value="<?php if(isset($c)) echo $c ?>" />
<option name='' value="" />Toute les catégories</option>
<option value="1" <?php echo ($_GET["c"] == "1")?'selected="selected"':''; ?> >auto</option>
<option value="2" <?php echo ($_GET["c"] == "2")?'selected="selected"':''; ?> >vetement</option>
<option value="3" <?php echo ($_GET["c"] == "3")?'selected="selected"':''; ?> >audio</option>
<option value="4" <?php echo ($_GET["c"] == "4")?'selected="selected"':''; ?> >informatique</option>
</select>
</div>
<input type='hidden' name='q' value='1'>
<input type="submit" value="Rechercher">
</form>
<?php
}
?>
</div> |
Partager