/vente.php

<?php

include("includes/function.php");

include("includes/secure.php");



// Paramčtres de connexion

define('MYSQL_HOTE', 'localhost');

define('MYSQL_UTIL', 'root');

define('MYSQL_MDP', '');

define('MYSQL_BDD', 'immopaca');



// Paramčtres de la pagination

// Nombre d'éléments ŕ afficher sur une page

define('NB_PAR_PAGE', 10);



// Le modčle de la requęte : ne modifiez que les champs ŕ sélectionner et le nom

// de la table, gardez impérativement la clause LIMIT et la fonction SQL_CALC_FOUND_ROWS

if(!isset($_SESSION['requete']))

{

	define('MODELE_REQUETE', 'SELECT SQL_CALC_FOUND_ROWS ANNONCE.NUMANNONCE, TITREANNONCE, DESCRIPTIONANNONCE, PRIX, RUEANNONCE, CPVILLE, VILLELIBELLE 

											  FROM ANNONCE,VENTE,VILLE 

											  WHERE ANNONCE.NUMANNONCE=VENTE.NUMANNONCE

											  AND ANNONCE.NUMVILLE = VILLE.NUMVILLE

											  AND VALIDE=1

											  LIMIT %d,%d');

}

else {

	define('MODELE_REQUETE', $_SESSION['requete']);

}

// Connexion ŕ la base

mysql_connect(MYSQL_HOTE, MYSQL_UTIL, MYSQL_MDP) or  die(mysql_error());

mysql_select_db(MYSQL_BDD) or  die(mysql_error());





// Variables liées ŕ la pagination

$page = isset($_GET['p']) ? max(intval($_GET['p']), 1) : 1;



$debut = NB_PAR_PAGE * ($page - 1);





$res_r = mysql_query(sprintf(MODELE_REQUETE, $debut, NB_PAR_PAGE)) or die(mysql_error());



$res_n = mysql_query('SELECT FOUND_ROWS()') or die(mysql_error());

$NumRows = mysql_result($res_n, 0, 0);



$derniere_page = ceil($NumRows / NB_PAR_PAGE);

?>



<div id="page">

		<div id="content">

			<div class="post">

				<h2 class="title"><a href="#">Vente</a></h2>

				<div class="entry">

                	<div class="afficheAnnonce">

						<?php

                            

                        // Parcours/affichage des résultats

                            while($row = mysql_fetch_array($res_r)) { 

							    extract($row);

							?>

								<hr>

								<div id="annonce">

                                <?php

									//Récupération de la photo principale

								$req=executer_requete("SELECT URLPHOTO FROM PHOTO WHERE NUMANNONCE=$NUMANNONCE AND PHOTOPRINCI=1");

								if (mysql_num_rows($req)>0) {

									extract(mysql_fetch_assoc($req));

								}

								?>

                                <span id="prix">

									<?php  //prix

										

										echo "Prix : ".number_format($PRIX,2,',',' ')."€"; ?></span>

                                <a href="view.php?annonce=<?php echo Crypte($NUMANNONCE,"IMMOPACA"); ?>" target="_blank" class="more">

                                    <span id="photo"><img width="100px" src="<?php if(isset($URLPHOTO)) {  

                                                                                        echo $URLPHOTO; 

                                                                                    } 

                                                                                    else { echo 'img/no-image.png'; 

                                                                                    } 

                                                                              ?>"/>

                                    </span>

                                </a>

                                <span id="titre"><?php echo htmlentities($TITREANNONCE); ?></span><br /><br />

                                <span id="description"><?php echo htmlentities($DESCRIPTIONANNONCE); ?></span><br />

                                <span id="adresse"><?php echo htmlentities($RUEANNONCE)."<br>".$CPVILLE." ".htmlentities($VILLELIBELLE); ?></span>

                                

                                <br />

								<a href="view.php?annonce=<?php echo Crypte($NUMANNONCE,"IMMOPACA"); ?>" target="_blank" class="more">

                                Plus d'infos

                                </a>

								</div>

                                <?php

								unset($URLPHOTO);

                            }

                            // L'affichage de la barre de navigation

                            if ($NumRows > NB_PAR_PAGE) {

                                

                                 echo '<ul class="pagination">';

                                if ($page > 1) {

                                    echo '<li><a href="'.'?page='.$_GET['page'].'&p='. ($page - 1) . '">Page précédente</a></li>';

                                }

                                for ($i = 1; $i <= $derniere_page; $i++) {

                                    if ($i == $page) {

                                        echo '<li class="page-courante">' . $i . '</li>';

                                    } else {

                                        echo '<li><a href="'.'?page='.$_GET['page'].'&p='. $i . '">' . $i . '</a></li>';

                                    }

                                }

                                if ($page < $derniere_page) {

                                    echo '<li><a href="'.'?page='.$_GET['page'].'&p='. ($page + 1) . '">Page suivante</a></li>';

                                }

                                echo '</ul>';

                            }

                            ?>

                	</div>

				</div>

			</div>

			<div style="clear: both;">&nbsp;</div>

		</div>

		<!-- end #content -->

		<div id="sidebar">

			<ul>

			<li>

				<div class="recherche">

					<h2>Recherche</h2>

					<form method="post" action="./script/scriptRecherche.php">

						<fieldset>

							<p>

     							Type de logement :<br \>

     							<input type="checkbox" name="typeVilla" id="villa"/><label for="typeVilla">Villa</label>

     							<input type="checkbox" name="typeAppartement" id="appart"/><label for="typeAppartement">Appartement</label>

     						</p>

							<p>

								<label for="ville">Ville :</label><br />

     							<select name="ville" id="ville">

     								<option value="0">---</option>

     								<?php

     									$sqlReqVille='select * from VILLE ORDER BY VILLELIBELLE';

     									$sqlReqVille=executer_requete($sqlReqVille) or die ('Erreur requete ville');

     									while($donnee=mysql_fetch_array($sqlReqVille))

     										echo '<option value='.$donnee['NUMVILLE'].'>'.$donnee['CPVILLE'].' - '.$donnee['VILLELIBELLE'].'</option>';

     								?>

       							</select>

       						</p>

     						<?php

     							include('recherche/vente.php');

     						?>

     						<table>

     							<tr>

     								<td><label for="superficie">Superficie minimum </label></td>

     								<td><input type="text" name="superficie" /> m2</td>

     							</tr>

     							<tr>

     								<td><label for="nbPiece">Nb pi&egrave;ce min </label></td>

     								<td><input type="text" name="nbPiece" /></td>

     							</tr>

     							<tr>

     								<td><label for="nbPlaceParking">Place Parking min </label></td>

     								<td><input type="text" name="nbPlaceParking" /></td>

     							</tr>	

     						</table>

     						<p>

								Autre :<br />

     							<input type="checkbox" name="balcon" id="balcon"/><label for="balcon">Balcon</label>

     							<input type="checkbox" name="garage" id="garage"/><label for="garage">Garage</label>

     							<input type="checkbox" name="jardin" id="jardin"/><label for="jardin">Jardin</label>

     						</p>

						</fieldset>

  						<p>

    						<input type="submit" />

    						<input type="reset" />

						</p>

					</form>

				</div>

			</li>

		</ul>

	</div>

		<!-- end #sidebar -->

		<div style="clear: both;">&nbsp;</div>

		</div>

	<!-- end #page -->

</div>



<?php

	unset($_SESSION['requete']);

?>