Le portail francophone de la géomatique

$espece = $_GET['Page'];
$annee = $_GET['annee'];


$sql = "CREATE VIEW 'v1' as SELECT *  FROM benmed.\"Communes\",benmed.\"R_CerealesHiver\" WHERE benmed.\"Communes\".code_commune = benmed.\"R_CerealesHiver\".code_commune and benmed.\"R_CerealesHiver\".espece='$espece' and benmed.\"R_CerealesHiver\".annee=$annee and benmed.\"R_CerealesHiver\".production > 0";
    

//send the query
if (!$response = pg_query($conn, $sql)) {
    echo "A query error occured.\n";
    exit;
}
$trv = true;
//echo the data back to the DOM
while ($row = pg_fetch_row($response)) {
    
    
    foreach ($row as $i => $attr){
        if ( $trv ){echo $attr.", ";}
        $trv = true;
    }
    
    echo ";";
}

function DisplayStat(){
   //var fields = flds;
   var data = {
        table: str,
        fields: fields,
        
    };
     $.ajax({ url:"get_map_prod.php",
            data: data,
            success: function(data){
            alert("a");
            //if (data) {
            //var production=data.production;
           var dataArray = data.split(", ;");
    
    dataArray.pop();    
    dataArray.forEach(function(d){
        d = d.split(", "); 
            var feature = {
                "type": "Feature",
                "properties": {}, //properties object container
                "geometry": JSON.parse(d[fields.length])            //parse geometry
            };
            alert ("c");
        for (var i=0; i<fields.length; i++){
            feature.properties[fields[i]] = d[i];
        };
        geojson.features.push(feature);
    }    
    );
    
    alert("b");
    hangry2();
    }
    });
              
}
function hangry2(){
        console.log(geojson);
        var statistique = new ol.style.Style({
        fill: new ol.style.Fill({
          color: [0,0,0,1]
        }),
        stroke: new ol.style.Stroke({
          color: [240,215,255,1],
          width: 1
        })
      });
vector1 = new ol.layer.Vector({
    title: 'Mes statistiques',
    source: new ol.source.Vector({
    features: (new ol.format.GeoJSON()).readFeatures(geojson),
    //url: 'ilot.geojson',
    format: new ol.format.GeoJSON(),
    
    
  }),style: statistique
  
});
map.addLayer(vector1);
}

l'année est de type smalint, et j'ai mis : $annee = $_GET['annee'];

$annee = $_POST['annee'];

<?php
session_start();
include "config.php";
?>
{
"type": "FeatureCollection",
"features": [
<?php
// Connexion, sélection de la base de données
$dbconn = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$password") or die('Connexion impossible : ' . pg_last_error());  

// Exécution de la requête SQL
    $query = "SELECT ST_Area(the_geom) AS surface, ST_AsGeoJSON(the_geom,3) AS coord, gid, nom_zac, insee, commune_1, type FROM zac WHERE insee='$_SESSION[Selection_Commune]' ";  
    $result = pg_query($query) or die('Échec requête : ' . pg_last_error());  

// Affichage des résultats en HTML
$Boucle="0";
   while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
if($Boucle!="0"){echo ",\n";}
echo "{ \"type\": \"Feature\", \"properties\": { \"GID\": \"".$line[gid]."\", \"NUM_INSEE\": \"".$line[insee]."\", \"NOM_COM\": \"".$line[commune_1]."\", \"SURFACE\": \"".$line[surface]."\", \"NOM_ZAC\": \"".$line[nom_zac]."\", \"TYPE\": \"".$line[type]."\" }, \"geometry\": ".$line[coord]." }\n";
$Boucle=$Boucle+1;
   }  

// Libère le resultset
   pg_free_result($result);

// Ferme la connexion
   pg_close($dbconn);  
?>
]
}

"SELECT * FROM benmed.Communes,benmed.R_CerealesHiver 
WHERE benmed.Communes.code_commune = benmed.R_CerealesHiver.code_commune 
AND 
benmed.R_CerealesHiver.espece=$_GET['Page'] 
AND 
benmed.R_CerealesHiver.annee=$_GET['annee'] 
AND 
benmed.R_CerealesHiver.production > 0 ";

remarque : la sélection du nom de la table, type de céréale et l'année se fait sur le site ("formulaire html")