File "frame_fait_recensement.php"
Full path: /home/meharicl/www/graphe/frame_fait_recensement.php
File
size: 6.26 B
MIME-type: text/html
Charset: utf-8
Download Open Edit Advanced Editor Back
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Sans Titre</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="generator" content="HAPedit 3.1">
</head>
<body bgcolor="#FFFFFF">
<?
$Nom_Pays=""; $Nb_Pays=""; $Nom_Type=""; $Nb_Type="";$Nom_Dept="";$Nb_Dept="";$Nom_Region="";$Nb_Region="";
fait_Region();
///echo($Nom_Region."<br>".$Nb_Region."<br>");
fait_Type();
//echo($Nom_Type."<br>".$Nb_Type."<br>");
fait_Pays();
//echo($Nom_Pays."<br>".$Nb_Pays."<br>");
fait_Dept();
//echo($Nom_Dept."<br>".$Nb_Dept."<br>");
compile_fichiers($Nom_Region,$Nb_Region,$Nom_Dept,$Nb_Dept,$Nom_Pays,$Nb_Pays,$Nom_Type,$Nb_Type);
header('Location:http://www.mehariclubdefrance.com/phpBB3/posting.php?mode=reply&f=3&t=39607');
//************************************
function fait_Region()
{
global $Nom_Region,$Nb_Region;
$Nom_Region="categories: [";
$Nb_Region="data: [";
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = 'SELECT rec_regions.region_nom, Count( rec_mehari.mehari_id ) AS CompteDemehari_id FROM rec_mehari INNER JOIN ( ( rec_regions INNER JOIN rec_pays ON rec_regions.pays_id = rec_pays.pays_id ) INNER JOIN rec_departements ON rec_regions.region_id = rec_departements.region_id ) ON rec_mehari.departement_id = rec_departements.departement_id WHERE(rec_pays.pays_id=1) GROUP BY rec_regions.region_nom ORDER BY `CompteDemehari_id` DESC LIMIT 0, 300';
$result=$link->query($sql);
while($region=$result->fetch_assoc())
{
$nom=$region['region_nom'];
$nom=str_replace("'","\'",$nom);
$Nom_Region=$Nom_Region."'".$nom."',";
$Nb_Region=$Nb_Region.$region['CompteDemehari_id'].",";
}
$Nom_Region=$Nom_Region."],";
$Nb_Region=$Nb_Region."]";
$Nom_Region=str_replace(",]","]",$Nom_Region);
$Nb_Region=str_replace(",]","]",$Nb_Region);
}
//****
function fait_Dept()
{
global $Nom_Dept,$Nb_Dept;
$Nom_Dept="categories: [";
$Nb_Dept="data: [";
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = 'SELECT departement_id, COUNT(*) FROM `rec_mehari` GROUP BY `departement_id` ORDER BY `COUNT(*)` DESC';
$result=$link->query($sql);
while($dept=$result->fetch_assoc())
{
//en France ?
if(france($dept['departement_id'])==1)
{
$nom=nom_dept($dept['departement_id']);
$nom=str_replace("'","\'",$nom);
$Nom_Dept=$Nom_Dept."'".$nom."',";
$Nb_Dept=$Nb_Dept.$dept['COUNT(*)'].",";
}
}
$Nom_Dept=$Nom_Dept."],";
$Nb_Dept=$Nb_Dept."]";
$Nom_Dept=str_replace(",]","]",$Nom_Dept);
$Nb_Dept=str_replace(",]","]",$Nb_Dept);
}
//****
function fait_Pays()
{
global $Nom_Pays,$Nb_Pays;
$Nom_Pays="categories: [";
$Nb_Pays="data: [";
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = 'SELECT rec_pays.pays_nom, Count( rec_mehari.mehari_id ) AS CompteDemehari_id FROM rec_mehari INNER JOIN ( ( rec_regions INNER JOIN rec_pays ON rec_regions.pays_id = rec_pays.pays_id ) INNER JOIN rec_departements ON rec_regions.region_id = rec_departements.region_id ) ON rec_mehari.departement_id = rec_departements.departement_id GROUP BY rec_pays.pays_nom ORDER BY `CompteDemehari_id` DESC LIMIT 0, 30';
$result=$link->query($sql);
while($pays=$result->fetch_assoc())
{
$Nom_Pays=$Nom_Pays."'".$pays['pays_nom']."',";
$Nb_Pays=$Nb_Pays.$pays['CompteDemehari_id'].",";
}
$Nom_Pays=$Nom_Pays."],";
$Nb_Pays=$Nb_Pays."]";
$Nom_Pays=str_replace(",]","]",$Nom_Pays);
$Nb_Pays=str_replace(",]","]",$Nb_Pays);
}
//*****
function fait_Type()
{
global $Nom_Type,$Nb_Type;
$Nom_Type="categories: [";
$Nb_Type="data: [";
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = 'SELECT rec_modele.modele_desc, Count( rec_mehari.mehari_id ) AS CompteDemehari_id FROM rec_mehari INNER JOIN rec_modele ON rec_mehari.modele_id = rec_modele.modele_id GROUP BY rec_modele.modele_id, rec_modele.modele_desc ORDER BY `CompteDemehari_id` DESC';
$result=$link->query($sql);
while($type=$result->fetch_assoc())
{
$Nom_Type=$Nom_Type."'".$type['modele_desc']."',";
$Nb_Type=$Nb_Type.$type['CompteDemehari_id'].",";
};
$Nom_Type=$Nom_Type."],";
$Nb_Type=$Nb_Type."]";
$Nom_Type=str_replace(",]","]",$Nom_Type);
$Nb_Type=str_replace(",]","]",$Nb_Type);
}
//*****
function compile_fichiers($Nom_Region,$Nb_Region,$Nom_Dept,$Nb_Dept,$Nom_Pays,$Nb_Pays,$Nom_Type,$Nb_Type)
{
$fic="resultat_save.html";
$save=fopen($fic,"r");
$brut=fread($save,filesize($fic));
//echo("***************".filesize($fic));
fclose($save);
//$Nom_Regions
$brut=str_replace('###Nom_Region###',$Nom_Region,$brut);
//$Nb_Regions
$brut=str_replace('###Nb_Region###',$Nb_Region,$brut);
//Nom_Dept
$brut=str_replace('###Nom_Dept###',$Nom_Dept,$brut);
//Nb_Dept
$brut=str_replace('###Nb_Dept###',$Nb_Dept,$brut);
//Nom_Pays
$brut=str_replace('###Nom_Pays###',$Nom_Pays,$brut);
//Nb_Pays
$brut=str_replace('###Nb_Pays###',$Nb_Pays,$brut);
//Nom_Type
$brut=str_replace('###Nom_Type###',$Nom_Type,$brut);
//Nb_Pays
$brut=str_replace('###Nb_Type###',$Nb_Type,$brut);
//fabrication recensement_tr.html
$fic="../rec/index.html";
$live=fopen($fic,"w");
fwrite($live,$brut);
fclose($live);
}
function france($dept)
{
if(!($dept>1)){return(3);}
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = "SELECT * FROM `rec_departements` WHERE `departement_id` = ".$dept;
$result=$link->query($sql);
while($region=$result->fetch_assoc())
{
$region_id=$region['region_id'];
}
$sql = 'SELECT * FROM `rec_regions` WHERE `region_id` ='.$region_id ;
$result=$link->query($sql);
while($pays=$result->fetch_assoc())
{
return($pays['pays_id']);
}
}
function nom_dept($dept)
{
if(!($dept>1)){return('inc');}
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = "SELECT * FROM `rec_departements` WHERE `departement_id` =". $dept;
$result=$link->query($sql);
while($n_depr=$result->fetch_assoc())
{
return($n_depr['departement_nom']);
}
}
?>
</body>
</html>