".$Nb_Region."
");
fait_Type();
//echo($Nom_Type."
".$Nb_Type."
");
fait_Pays();
//echo($Nom_Pays."
".$Nb_Pays."
");
fait_Dept();
//echo($Nom_Dept."
".$Nb_Dept."
");
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']);
}
}
?>