plugins/function.select_db_table.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2004 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22
  23 function select_options($table,$valeur,$champ="text",$pad=false,$where="") {
  24     global $globals;
  25     $sql = "SELECT id,$champ FROM $table $where ORDER BY $champ";
  26     $res = $globals->xdb->iterRow($sql);
  27     $sel = ' selected="selected"';
  28
  29     // on ajoute une entree vide si $pad est vrai
  30     $html = "";
  31     if ($pad) {
  32         $html.= '<option value="0"'.($valeur==0?$sel:"")."></option>\n";
  33     }
  34     while (list($my_id,$my_text) = $res->next()) {
  35         $html .= sprintf("<option value=\"%s\" %s>%s</option>\n",$my_id,($valeur==$my_id?$sel:""),$my_text);
  36     }
  37     return $html;
  38 }
  39
  40 function smarty_function_select_db_table($params, &$smarty) {
  41     if(empty($params['table']))
  42         return;
  43     if(empty($params['champ']))
  44         $params['champ'] = 'text';
  45     if(empty($params['pad']) || !($params['pad']))
  46         $pad = false;
  47     else
  48         $pad = true;
  49     if(empty($params['where']))
  50         $params['where'] = '';
  51     return select_options($params['table'], $params['valeur'], $params['champ'], $pad, $params['where']);
  52 }
  53
  54 ?>