[Sommaire] [Imprimer]

   1  <?php
   2  /*****************************************************
   3  * This file is part of Agora, web based content management system.
   4  *
   5  * Agora is free software; you can redistribute it and/or modify
   6  * it under the terms of the GNU General Public License as published by
   7  * the Free Software Foundation; version 2 of the License.
   8  *
   9  * Agora is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details (file "COPYING").
  13  *
  14  * Copyright © Arnaud Martin, Antoine Pitrou et Philippe Rivière.
  15  * List of authors detailed in "copyright_fr.html" file.
  16  * E-mail : agora@sig.premier-ministre.gouv.fr
  17  * Web site : http://www.agora.gouv.fr
  18  *****************************************************/
  19  // Base class for Petition business persistence abstraction.
  20  //
  21  
  22  if (defined("_BD_PETITIONMYSQL"))
  23      return;
  24  
  25  define("_BD_PETITIONMYSQL", "1");
  26  
  27  require_once dirname(__FILE__). "/../petition.php";
  28  
  29  /**
  30   * BD_petition_mysql is an implementation for MySQL of BD_petition business class.
  31   * @package    BD_mysql
  32   * @author     Erwan Le Bescond <elebescond@clever-age.com>
  33   * @access    public
  34   */
  35  class BD_petition_mysql extends BD_petition {
  36      // {{{ replace($id_article, $email_unique, $site_obli, $site_unique, $message, $texte_petition)
  37  
  38  	function replace ($id_article, $email_unique, $site_obli, $site_unique, $message, $texte_petition) {
  39          $db = &$this->_getDB();
  40  
  41          if (DB::isError($db)) {
  42              return PEAR::raiseError("[" . get_class($this). " DB_petition : replace()] " . $db->getMessage(). "", null, null, null, null, null, false);
  43          }
  44  
  45          $query = "REPLACE " . $GLOBALS['table_prefix']. "_petitions (id_article, email_unique, site_obli, site_unique, message, texte) " . "VALUES ($id_article, '$email_unique', '$site_obli', '$site_unique', '$message', '$texte_petition')";
  46  
  47          //echo $query;
  48          $result = $db->query($query);
  49  
  50          if (DB::isError($result)) {
  51              return PEAR::raiseError("[" . get_class($this). " DB_petition : replace()] " . $result->getMessage(). "", null, null, null, null, null, false);
  52          }
  53      }
  54  
  55  // }}}
  56  }
  57  ?>