Rev 609 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<?php/*vim: set expandtab tabstop=4 shiftwidth=4: */// +------------------------------------------------------------------------------------------------------+// | PHP version 4.1 |// +------------------------------------------------------------------------------------------------------+// | Copyright (C) 2005 Tela Botanica (accueil@tela-botanica.org) |// +------------------------------------------------------------------------------------------------------+// | This file is part of API - Formulaire. |// | |// | Foobar is free software; you can redistribute it and/or modify |// | it under the terms of the GNU General Public License as published by |// | the Free Software Foundation; either version 2 of the License, or |// | (at your option) any later version. |// | |// | Foobar is distributed in the hope that it will be useful, |// | but WITHOUT ANY WARRANTY; without even the implied warranty of |// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |// | GNU General Public License for more details. |// | |// | You should have received a copy of the GNU General Public License |// | along with Foobar; if not, write to the Free Software |// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |// +------------------------------------------------------------------------------------------------------+// CVS : $Id: FORM_formulaire.class.php,v 1.4 2005/04/06 13:22:17 jpm Exp $/*** Classe form** Classe permettant l'édition d'une base donnée MySQL de façon* simplifié.**@package Formulaire//Auteur original :*@author Alexandre GRANIER <alexandre@tela-botanica.org>//Autres auteurs :*@author Jean-Pascal MILCENT <jpm@clapas.org>*@copyright Tela-Botanica 2000-2005*@version $Revision: 1.4 $ $Date: 2005/04/06 13:22:17 $// +------------------------------------------------------------------------------------------------------+*/// +------------------------------------------------------------------------------------------------------+// | ENTETE du PROGRAMME |// +------------------------------------------------------------------------------------------------------+// +------------------------------------------------------------------------------------------------------+// | CORPS du PROGRAMME |// +------------------------------------------------------------------------------------------------------+class form {// propriétésvar $link;var $style_general;var $style_label;var $style_champ;var $style_button;var $style_radiocheckbox;var $style_commentaire;// constructeurfunction form($identifiant_de_connection){$this->link = $identifiant_de_connection;}function select_db($db){mysql_select_db($db, $this->link) or die (BOG_afficherErreurSql(__FILE__, __LINE__, mysql_error(), $db));}function selectFromEnum($table, $champs_enum, $selected = ''){// recup des différentes occurences$query = 'DESCRIBE '.$table;$result = mysql_query($query) or die (BOG_afficherErreurSql(__FILE__, __LINE__, mysql_error(), $query));while ($row = mysql_fetch_object($result)) {if ($row->Field == $champs_enum) {break;}}$tableau_enum = form::_extraction('enum', $row->Type);// construction du select$res = '<select name="'.$champs_enum.'" ';if ($this->style_general != '') {$res .= 'class="'.$this->style_general.'"';}$res .= '>'."\n";for ($i = 0 ; $i < count ($tableau_enum) ; $i++) {$res .= "\t".'<option value="'.$tableau_enum[$i].'"';if ($selected != '') {if ($tableau_enum[$i] == $selected) {$res .= 'selected';}}$res .= '>'.$tableau_enum[$i].'</option>'."\n";}$res .= '</select>'."\n";mysql_free_result($result);return $res;}// Pour une table ne comportant que 2 champs ID et Labelfunction selectFromTable($table, $selected = '',$champs1 = '',$champs2 = '', $autre = ''){// la requete, sur la tableif ($champs1 != '') {$query = 'SELECT '.$table.'.'.$champs1.', '.$table.'.'.$champs2.' '.'FROM '.$table;} else {$query = 'SELECT * '.'FROM '.$table;}if (!($result = mysql_query($query))) {return false ;}$res = '<select name="'.$table.'" ';if ($this->style_general != '') {$res .= 'class="'.$this->style_general.'"';}if ($autre != '') {$res .= ' '.$autre;}$res .= '>'."\n";while ($row = mysql_fetch_row($result)) {$res .= "\t".'<option value="'.$row[0].'"';if ($row[0] == $selected) {$res .= ' selected="selected"';}$res .= '>'.$row[1].'</option>'."\n";}$res .= '</select>'."\n";mysql_free_result($result) ;return $res ;}// Génère un <select> avec les elements d'un tableaufunction selectFromTableau($nom, $tableau, $selected = '', $javascript = array()){$res = '<select name="'.$nom.'" ';if ($this->style_general != '') {$res .= 'class="'.$this->style_general.'" ';}if (! empty($javascript)) {$res .= $javascript['nom_evenement'].'="'.$javascript['valeur_evenement'].'"';}$res .= '>'."\n";for ($i = 0 ; $i < count ($tableau) ; $i++) {$res .= "\t".'<option value="'.$tableau[$i].'" ';if ($tableau[$i] == $selected) {$res .= 'selected="selected"';}$i++;$res .= '>'.$tableau[$i].'</option>'."\n";}$res .= '</select>'."\n";return $res;}function radioFromEnum($table, $champs_enum, $enum_checked = ''){// Récupération des différentes occurences$query = 'DESCRIBE '.$table;$result = mysql_query($query) or die (BOG_afficherErreurSql(__FILE__, __LINE__, mysql_error(), $query));while ($row = mysql_fetch_object($result)) {if ($row->Field == $champs_enum) {break;}}$tableau_enum = form::_extraction('enum', $row->Type);// Construction du select$res = '';for ($i = 0 ; $i < count ($tableau_enum) ; $i++) {$res .= '<input ';if ($this->style_radiocheckbox != '') {$res .= 'class="'.$this->style_radiocheckbox.'" ';}$res .= 'type="radio" name="'.$champs_enum.'" value="'.$tableau_enum[$i].'" ';if ($tableau_enum[$i] == $enum_checked) {$res .= ' checked="checked"';}$res .= ' />'."\n";$res .= "\t\t".$tableau_enum[$i]."\n";$res .= "\t".' '."\n";}mysql_free_result($result);return $res;}// pour une table ne comportant que 2 champs ID et Labelfunction radioFromTable($table, $idChecked = '', $champs1 = '', $champs2 = '', $name = ''){// La requete, sur la table$requete = 'SELECT * '.'FROM '.$table;$resultat = mysql_query($requete) or die(BOG_afficherErreurSql(__FILE__, __LINE__, mysql_error(), $requete));if (!($resultat)) {return false;}$retour = '';while ($ligne = mysql_fetch_row($resultat)) {$retour .= '<input ';if ($this->style_radiocheckbox != '') {$retour .= 'class="'.$this->style_radiocheckbox.'" ';}$retour .= 'type="radio" name="';if ($name != '') {$retour .= $name;} else {$retour .= $table;}$retour .= '" value="'.$ligne[0].'" ';if ($ligne[0]== $idChecked) {$retour .= 'checked="checked" ';}$retour .= ' />'."\n";$retour .= "\t".' '."\t".$ligne[1]."\n";$retour .= "\t".' <br />'."\n";}mysql_free_result($resultat);return $retour;}function checkboxFromTable($table_jointure, $table_label, $idChecked, $presentation = 'LIGNE'){// la requete sur les tablesif (empty($idChecked)) {$idChecked = array();}$query = 'SELECT * '.'FROM '.$table_label;$result = mysql_query($query) or die (BOG_afficherErreurSql(__FILE__, __LINE__, mysql_error(), $query));if (!($result)) {return false;}$res = '';while ($row = mysql_fetch_row($result)) {$res .= "\n".'<input type="checkbox" name="'.$table_label.$row[0].'" value="'.$row[0].'"';if (in_array($row[0], $idChecked)) {$res .= ' checked="checked"';}$res .= ' />'.$row[1];if ($presentation == 'LIGNE') {$res .= '<br />';}}return $res;}function checkboxFromSet($table, $champs, $set_checked = ''){if (empty($set_checked)) {$set_checked = array();}// Récupération des différentes occurences$query = 'DESCRIBE '.$table;$result = mysql_query($query) or die (BOG_afficherErreurSql(__FILE__, __LINE__, mysql_error(), $query));while ($row = mysql_fetch_object($result)) {if ($row->Field == $champs) {break;}}$tableau_enum = form::_extraction('set', $row->Type);for ($i = 0 ; $i < count($tableau_enum) ; $i++) {// Construction du des checkbox$res = '<input type="checkbox" name="'.$champs.'" ';if ($this->style_general != '') {$res .= 'class="'.$this->style_general.'" ';}$res .= 'value="'.$tableau_enum[$i].'" ';if (in_array($tableau_enum[$i], $set_checked)) {$res .= 'selected="selected"';}$res .= ' />'.$tableau_enum[$i].' ';}mysql_free_result($result);return $res;}function submit($value, $name = '', $autre = ''){$res = '<input ';if ($name != '') {$res .= 'name="'.$name.'" ';}$res .= 'type="submit" value="'.$value.'" class="'.$this->style_button.'" ';if ($autre != '') {$res .= $autre;}$res .= ' />'."\n";return $res;}function bouton($label, $style = '', $name = 'bouton', $autre = ''){$res = "\t".'<input type="submit" name="'.$name.'" value="'.$label.'" ';if ($style != '') {$res .= 'class="'.$style.'"';}if ($autre != '') {$res .= ' '.$autre;}$res .= ' />'."\n";return $res;}function _extraction($action, $chaine){$regexp = '^'.$action.'\(';$chaine = ereg_replace($regexp, '', $chaine);$chaine = ereg_replace("\)$", '', $chaine);$chaine = ereg_replace("'", '', $chaine);$tableau_enum = explode(',', $chaine);return $tableau_enum;}}// +------------------------------------------------------------------------------------------------------+// | PIED du PROGRAMME |// +------------------------------------------------------------------------------------------------------+/* +--Fin du code ----------------------------------------------------------------------------------------+** $Log: FORM_formulaire.class.php,v $* Revision 1.4 2005/04/06 13:22:17 jpm* Corrections et ajout d'id aux champs des formulaires.** Revision 1.3 2005/03/30 09:06:26 jpm* Mise en conformité du code.** Revision 1.2 2005/03/08 11:29:51 jpm* Amélioration du code.** Revision 1.1 2005/03/03 17:44:44 jpm* Ajout des fichiers anciennement contenu dans le fichier lib.form.php.*** +-- Fin du code ----------------------------------------------------------------------------------------+*/?>