Archives généalogiques en ligne
echo ("");
$query= "SELECT * FROM departement d, region r where NUMDEPT ='".substr($_GET['insee'],0,2)."' and r.numregion=d.numregion";
$result = mysqli_query($connect,$query);
if (@mysqli_num_rows($result)) {
if ($val = @mysqli_fetch_array($result)) {
$nomdep=utf8_encode($val["NOMDEPT"]);
Echo "".$nomdep.""; Echo "Numéro du département: ".$val["NUMDEPT"];
Echo " Archives numérisées en ligne$query= "SELECT * FROM reference.service where dep='".$val2["NUMDEPT"]."'"; $result2 = mysqli_query($connect,$query); if (@mysqli_num_rows($result2)) { echo " Autres services d'archives dans le département: "; while ($val2 = @mysqli_fetch_array($result2)) { echo utf8_encode($val2["nom"]).""; } } include "defintion.php"; include "annee.php"; ?> echo (" | ");
echo "Les décès:"; include "base.php"; echo "Liste des décès des ".strtoupper($_GET["patronyme"])." de 1970 à 1979"; $query= "select * from insee_deces where nom='".strtoupper($_GET['patronyme'])."' order by prenom"; $result = mysqli_query($mysqlDeces70,$query); if (@mysqli_num_rows($result)) { while ($val = @mysqli_fetch_array($result)) { echo ("".trim(utf8_encode($val["nom"]))." ".trim(utf8_encode($val["prenom"]))." "); } } echo " Liste des décès des ".strtoupper($_GET["patronyme"])." de 1980 à 1989 "; $query= "select * from insee_deces where nom='".strtoupper($_GET['patronyme'])."' order by prenom"; $result = mysqli_query($mysqlDeces80,$query); if (@mysqli_num_rows($result)) { while ($val = @mysqli_fetch_array($result)) { echo ("".trim(utf8_encode($val["nom"]))." ".trim(utf8_encode($val["prenom"]))." "); } } echo " Liste des décès des ".strtoupper($_GET["patronyme"])." de 1990 à 1999 "; $query= "select * from insee_deces where nom='".strtoupper($_GET['patronyme'])."' order by prenom"; $result = mysqli_query($mysqlDeces90,$query); if (@mysqli_num_rows($result)) { while ($val = @mysqli_fetch_array($result)) { echo ("".trim(utf8_encode($val["nom"]))." ".trim(utf8_encode($val["prenom"]))." "); } } echo " Liste des décès des ".strtoupper($_GET["patronyme"])." de 2000 à 2009 "; $query= "select * from insee_deces where nom='".strtoupper($_GET['patronyme'])."' order by prenom"; $result = mysqli_query($mysqlDeces00,$query); if (@mysqli_num_rows($result)) { while ($val = @mysqli_fetch_array($result)) { echo ("".trim(utf8_encode($val["nom"]))." ".trim(utf8_encode($val["prenom"]))." "); } } echo " Liste des décès des ".strtoupper($_GET["patronyme"])." de 2010 à 2019 "; $query= "select * from insee_deces where nom='".strtoupper($_GET['patronyme'])."' order by prenom"; $result = mysqli_query($mysqlDeces10,$query); if (@mysqli_num_rows($result)) { while ($val = @mysqli_fetch_array($result)) { echo ("".trim(utf8_encode($val["nom"]))." ".trim(utf8_encode($val["prenom"]))." "); } } ?> echo (" |