[Sommaire] [Imprimer]

   1  <?php 
   2    /**************************************************************************\
   3    * eGroupWare - Bookmarks                                                   *
   4    * http://www.egroupware.org                                                *
   5    * Based on Bookmarker Copyright (C) 1998  Padraic Renaghan                 *
   6    *                     http://www.renaghan.com/bookmarker                   *
   7    * --------------------------------------------                             *
   8    *  This program is free software; you can redistribute it and/or modify it *
   9    *  under the terms of the GNU General Public License as published by the   *
  10    *  Free Software Foundation; either version 2 of the License, or (at your  *
  11    *  option) any later version.                                              *
  12    \**************************************************************************/
  13  
  14    /* $Id: glist.wml 20295 2006-02-15 12:31:25Z  $ */
  15    
  16      include("../header.inc.php");
  17      header("Content-Type: text/vnd.wap.wml");
  18      print("<?xml version=\"1.0\"?>");
  19  ?>
  20  <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
  21    "http://www.wapforum.org/DTD/wml_1.1.xml">
  22  <wml>
  23    <card>
  24  <?php
  25      $query = "select subcategory.name as subcategory_name "
  26          . ", bookmark.name as bookmark_name, url "
  27          . "from bookmark, subcategory "
  28          . "where public_f = 'Y' "
  29          . "and category_id = 12 "
  30          . "and subcategory_id = subcategory.id "
  31          . "order by subcategory_name, bookmark_name ";
  32      $GLOBALS['egw']->db->query($query,__LINE__,__FILE__);
  33      if ($GLOBALS['egw']->db->Errno != 0)
  34      {
  35          print("<p>ERROR</p>");
  36      }
  37  
  38      while ($GLOBALS['egw']->db->next_record())
  39      {
  40          $subcategory = $GLOBALS['egw']->db->f("subcategory_name");
  41          $name        = $GLOBALS['egw']->db->f("bookmark_name");
  42          $url         = $GLOBALS['egw']->db->f("url");
  43          printf("<p><a href=\"%s\" title=\"%s\">%s</a></p>", $url, $url, $name);
  44      }
  45  ?>
  46    </card>
  47  </wml>
  48  <?php $GLOBALS['egw']->common->phpgw_footer(); ?>