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
|
<?
require("protect/conf.php");
$db_link = @mysql_connect($sql_serveur,$sql_user,$sql_passwd);
if(!$db_link) {echo "Connexion impossible à la base de données <b>$sql_bdd</b> sur le serveur <b>$sql_server</b><br>Vérifiez les paramètres du fichier conf.php"; exit;}
//Recupere les paramètres
$requete=mysql_db_query($sql_bdd,"SELECT * FROM recherche WHERE regionr LIKE '$regionr_recherche' || ville LIKE '$viller_recherche' ORDER BY id_recherche DESC",$db_link) or die(mysql_error());
$requete_limit = sprintf("%s LIMIT %d, %d", $requete, $startRow, $maxRows);
$row = mysql_fetch_assoc($requete);
if (isset($_GET['totalRows'])) {
$totalRows = $_GET['totalRows'];
} else {
$all = mysql_query($requete);
$totalRows = mysql_num_rows($all);
}
$totalPages = ceil($totalRows/$maxRows)-1;
$requete2=mysql_db_query($sql_bdd,"SELECT * FROM membre,civilite,recherche WHERE id_recherche=id_membre and id_civilite=id_recherche",$db_link) or die(mysql_error());
$requete_limit = sprintf("%s LIMIT %d, %d", $requete2, $startRow, $maxRows);
$row_requete2 = mysql_fetch_array($requete2);
if (isset($_GET['totalRows'])) {
$totalRows = $_GET['totalRows'];
} else {
$all = mysql_query($requete2);
$totalRows = mysql_num_rows($all);
}
$totalPages = ceil($totalRows/$maxRows)-1;
$pseudo_membre = $row_requete2["pseudo"];
$passe_membre = $row_requete2["passe"];
$email_membre = $row_requete2["email"];
$villec_civilite = $row_requete2["villec"];
$regionc_civilite = $row_requete2["regionc"];
$regionr_recherche = $row["regionr"];
$viller_recherche = $row["viller"];
mysql_close($db_link);
?> |
Partager