Codice PHP:
function tutto_caratteristiche($tipo_ghiacciaio, $forma_ghiacciaio,$frontal_char, $longi_profile,$alimentazione, $attivita, $orientazione, $ordine, $modo){
$qry = "SELECT q.glacier_name AS nome_ghiacciaio, q.glacier_sub_name AS sub_name , q.glacier_code AS codice_ghiacciaio, q.glacier_sub_code AS sub_code, h.name_it AS tipo, i.name_it AS forma, l.name_it AS frontal, m.name_it AS longi, n.name_it AS alimentazione, o.name_it AS attivita, p.name AS orientazione, a.char_year AS anno
FROM type_glacier a, form_glacier b, frontal_glacier c, profile_glacier d, source_nourish_glacier e, activity_glacier f, glacier_orientation g, glacier_type h, glacier_form i, frontal_char l, longi_profile m, source_nourish n, tongue_activity o, orientation p, glaciers q
WHERE a.id_glacier_type=$tipo_ghiacciaio AND b.id_glacier_form=$forma_ghiacciaio AND c.id_frontal_char= $frontal_char AND d.id_longi_profile=$longi_profile AND e.id_source_nourish = $alimentazione AND f.id_tongue_activity = $attivita AND g.id_orientation= $orientazione AND a.id_glacier = b.id_glacier AND b.id_glacier=c.id_glacier AND c.id_glacier=d.id_glacier AND d.id_glacier=e.id_glacier AND e.id_glacier=f.id_glacier AND f.id_glacier=g.id_glacier AND a.char_year = b.char_year AND a.char_year = c.char_year AND a.char_year = d.char_year AND a.char_year = e.char_year AND a.char_year = f.char_year AND a.char_year = g.char_year AND h.id_glacier_type= a.id_glacier_type AND i.id_glacier_form = b.id_glacier_form AND l.id_frontal_char = c.id_frontal_char AND m.id_longi_profile = d.id_longi_profile AND n.id_source_nourish = e.id_source_nourish AND o.id_tongue_activity= f.id_tongue_activity AND p.id_orientation= g.id_orientation AND q.id_glacier = a.id_glacier ORDER BY $ordine $modo";
$result = pg_query($qry) or die ("Errore nella query". $qry . "\n" . pg_result_error());
while ($valori = pg_fetch_assoc ($result)){
$totale[] = $valori;
}
return $totale;
}
questa è la mia queri quando tutti i campi sono settati..
come faccio a farla dinamica ??