Global function for querying the database

[misc/kostenrechnung] / lib / menu.php

<?php

function menu()
{
  if (empty($_SESSION['sys']['login'])) return '';

  $ret = '<div class="menu">';

  $ret .= '<ul id="menu" class="dropdown">';

  $ret .= '<li><span>Home</span>';
  $ret .= '<ul>';
  $ret .= '<li><a href="./" title="Zurück zur Hauptseite">Start</a></li>';
  $ret .= '<li><a href="./?logout=true" title="Abmelden">Logout</a></li>';

  $sql = "SELECT mask,menutitle,name FROM sys_mask "
    . "JOIN sys_menu ON sys_mask.menu = sys_menu.id "
    . "ORDER BY sys_menu.priority,sys_menu.name,sys_mask.priority,sys_mask.menutitle";
  $sth = pg_query($sql);

  if ($sth) {
    $menu = 'Start';

    while ($row = pg_fetch_assoc($sth)) {
      if ($menu != $row['name']) {
        $ret .= '</ul></li>';
        $ret .= sprintf('<li><span>%s</span>', $row['name']);
        $ret .= '<ul>';
        $menu = $row['name'];
      }
      $ret .= sprintf('<li><a href="./?mask=%s">%s</a></li>', $row['mask'], $row['menutitle']);
    }
    $ret .= '</ul>';
    $ret .= '</li>';
  }

  $ret .= '</ul>';
  $ret .= '</div>';

  return $ret;
}

?>