//$dbconn = pg_connect(CONFIG_DB) or die('Connexion impossible : ' . pg_last_error());
// MENU PRINCIPAL
$req = 'SELECT id, subid, title, link, pics FROM web_menu WHERE auth <= ' . $_SESSION['auth'] . ' AND id <> 4 ORDER BY id, subid, priority;';
$result = sypel_query2("sitemap", $req);
// or die('Échec de la requête : ' . pg_last_error());
$menu = array();
$i = 0;
while ($ligne = pg_fetch_array($result, NULL, PGSQL_NUM)) {
$menu[$i] = $ligne;
$i = $i + 1;
}
$compt = $i - 1;
//echo $compt;
// MENU SECONDAIRE
$req = 'SELECT id, subid, title, link, pics FROM web_menu WHERE auth <= ' . $_SESSION['auth'] . ' AND id >= 4 ORDER BY id, subid, priority;';
$result = sypel_query2("menu", $req);
// or die('Échec de la requête : ' . pg_last_error());
$menu2 = array();
$i = 0;
while ($ligne = pg_fetch_array($result, NULL, PGSQL_NUM)) {
$menu2[$i] = $ligne;
$i = $i + 1;
}
$compt2 = $i - 1;
//echo $compt2;
?>
<!-- WELCOME TO SYPEL -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head>
<title>SYPEL - Prévisions température et nébulosité J+4</title>
function sypel_query2fulljson($reqname, $req)
{
$tabmenu = sypel_query2($reqname, $req);
$gbData = array();
$item = array();
$rubrique = "";
while ($item = sypel_fetch_row($tabmenu)) {
$gbData[] = $item;
}
return json_encode($gbData);
}
