Forum d'entraide PHPFrance

   function editReiki()
   {
      $dbh = mysql::getInstance();
      $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
      $sql = "SELECT *
     		  FROM `view`
      		  WHERE `title` = 'reiki'";
      $requete = $dbh->prepare($sql);
      $requete->execute();
      $arr = $requete->errorInfo();
   	  print_r($arr);
      
      $row = $requete->fetch(PDO::FETCH_ASSOC);
      $text = $row['text'];
      //$textEncoder = addslashes($text);
      $textEncoder =  htmlentities($text);
      
      $dbh2 = mysql::getInstance();
      $dbh2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
      $sql2 = "UPDATE `view`
               SET `text` = ?
               WHERE `title` = 'reiki'";
      $requete2 = $dbh2->prepare($sql2);
      $requete2->execute(array($textEncoder));
               $arr = $requete->errorInfo();
   $arr = $requete->errorInfo();
   print_r($arr);
      echo 'Enregistrement effestué.';
      ?><!-- <SCRIPT LANGUAGE="JavaScript">
		document.location.href="?p=reiki"
		</SCRIPT> -->
		<?php
   }