{"id":607,"date":"2018-06-14T17:00:49","date_gmt":"2018-06-14T15:00:49","guid":{"rendered":"http:\/\/lacdegrandmaison.fr\/cms\/?page_id=607"},"modified":"2018-06-14T18:32:14","modified_gmt":"2018-06-14T16:32:14","slug":"contact-rgdp","status":"publish","type":"page","link":"http:\/\/lacdegrandmaison.fr\/cms\/confidentialite\/contact-rgdp\/","title":{"rendered":"Contact RGDP"},"content":{"rendered":"<p>Cette page vous permet de nous contacter au sujet de notre politique de confidentialit\u00e9.<\/p>\n<p>[insert_php]<br \/>\n\/**<br \/>\n * \\project\tSimply adaptable form<br \/>\n * \\brief\tThis PHP code can be easily adapt for simple form connected with MySQL BD<br \/>\n * \\version\t1.0.1<br \/>\n * \\author\tVal\u00e9rie Bellynck<br \/>\n * \\author uri\thttp:\/\/tiprof.fr<br \/>\n * \\domain\tadaptablePHPform<br \/>\n *<br \/>\n * Copyright 2017-2018  Val\u00e9rie Bellynck  (email : t.bidon@live.fr)<br \/>\n *<br \/>\n * This file is part of \u00ab\u00a0adaptablePHPform\u00a0\u00bb.<br \/>\n *<br \/>\n * \u00ab\u00a0adaptablePHPform\u00a0\u00bb is free software: you can redistribute it and\/or modify<br \/>\n * it under the terms of the GNU General Public License as published by<br \/>\n * the Free Software Foundation, either version 3 of the License, or<br \/>\n * (at your option) any later version.<br \/>\n *<br \/>\n * \u00ab\u00a0adaptablePHPform\u00a0\u00bb is distributed in the hope that it will be useful,<br \/>\n * but WITHOUT ANY WARRANTY; without even the implied warranty of<br \/>\n * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the<br \/>\n * GNU General Public License for more details.<br \/>\n *<br \/>\n * You should have received a copy of the GNU General Public License<br \/>\n * along with \u00ab\u00a0adaptablePHPform\u00a0\u00bb.  If not, see <http:\/\/www.gnu.org\/licenses\/>.<br \/>\n *<br \/>\n *\/<\/p>\n<p>[\/insert_php] <\/p>\n<style>\n   body {background-color:#EEFFFF;}\n   fieldset {border:1px solid #44AAAA;}\n   legend {background-color:#DDFFFF;border:1px solid #228888;}\n   tt,input[type='text'] {\/*position:fixed;*\/left:80px}\n   .date {font-size:80%;font-style:italic;color:grey}\n  <\/style>\n<p>  <script src=\"bulle.js\" type=\"text\/javascript\" > <\/script>\n  <link rel=\"stylesheet\" href=\"bulle-css3.css\" type=\"text\/css\" media=\"screen\" \/>\n<style>\n.bulle {visibility: hidden; left: 237px; top: 184px;} \n  <\/style>\n<p>[insert_php] <\/p>\n<p>\/**<br \/>\n * \\enum DEBUG<br \/>\n * \\brief Constante d\u00e9finie (ou pas) pour activer des affichages de trace pendant le d\u00e9bogage.<br \/>\n *\/<br \/>\ndefine(&lsquo;DEBUG&rsquo;,\u00a0\u00bb);<br \/>\n\/\/define(&lsquo;DEBUG&rsquo;,&rsquo;test&rsquo;);<br \/>\n\/\/define(&lsquo;DEBUG&rsquo;,&rsquo;mysql&rsquo;);<br \/>\n\/\/define(&lsquo;DEBUG&rsquo;,&rsquo;export&rsquo;);<\/p>\n<p>\/**<br \/>\n * === Adaptation de la configuration du serveur === pour activer ou d\u00e9sactiver l&rsquo;affichage des notice et des alertes (Warning)<br \/>\n *\/<br \/>\n\/\/error_reporting(E_ALL &#038; ~E_DEPRECATED); \/\/ &#038; ~E_NOTICE<br \/>\nerror_reporting(E_ALL );<br \/>\nini_set(\u00ab\u00a0display_errors\u00a0\u00bb, 1);<br \/>\nif(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;test&rsquo;) echo &lsquo;<b>error_reporting = &lsquo;,error_reporting(),&rsquo;<\/b><br \/>&lsquo;;<\/p>\n<p>\/**<br \/>\n * === D\u00e9finition des constantes === Il suffit de modifier le nom de la table \u00e0 ce seul endroit<br \/>\n *\/<\/p>\n<p>\/**<br \/>\n * \\enum TABLE<br \/>\n * \\brief Nom de la table MySQL.<br \/>\n *\/<br \/>\ndefine(&lsquo;TABLE&rsquo;,&rsquo;algm__contacts&rsquo;);<\/p>\n<p>\/**<br \/>\n * \\enum FICSQL<br \/>\n * \\brief Nom de la table MySQL.<br \/>\n *\/<br \/>\ndefine(&lsquo;FICSQL&rsquo;,&rsquo;CreateTable.mysql&rsquo;);<\/p>\n<p>\/**<br \/>\n * === D\u00e9finition des fonctions ===<br \/>\n *\/<\/p>\n<p>\/**<br \/>\n * @fn\tfunction test_exist_table( $table=TABLE )<br \/>\n * @brief\tCette fonction teste si une table existe d\u00e9j\u00e0 dans la BD<br \/>\n *<br \/>\n * @param\t$tab\tNom de la table \u00e0 chercher dans la BD. (facultatif)<br \/>\n * @return\t\\e boolean\t\tvalant TRUE si la table est trouv\u00e9e dans les tables de la BD.<br \/>\n *\/<br \/>\nfunction test_exist_table($pdo, $table=TABLE) {<br \/>\n    \/\/global $pdo;<br \/>\n    \/\/$sql = &lsquo;SHOW CREATE TABLE  &lsquo; .$table &lsquo; &lsquo; ;<br \/>\n    $sql = \u00ab\u00a0SHOW TABLES FROM `\u00a0\u00bb.my_DB_NAME.\u00a0\u00bb` \u00ab\u00a0;<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;mysql&rsquo;) echo \u00ab\u00a0<\/p>\n<pre>$sql<\/pre>\n<p>\u00ab\u00a0;<\/p>\n<p>    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      \/\/if ( $row = $prep->fetchAll(PDO::FETCH_ASSOC) ) ;<br \/>\n      while ($row = $prep->fetch() ) {<br \/>\n        \/\/echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($row); echo \"<\/pre>\n<p>\u00ab\u00a0;<br \/>\n        if($row[&lsquo;Tables_in_&rsquo;.my_DB_NAME] == $table) return TRUE;<br \/>\n      }<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n}<\/p>\n<p>\/**<br \/>\n * @fn\tfunction cree_table( $table=TABLE, $sql_create=\u00a0\u00bb )<br \/>\n * @brief\tCette fonction cr\u00e9e une table MySQL avec la requ\u00eate transmise en param\u00e8tre.<br \/>\n *  \tSi la requ\u00eate de cr\u00e9ation de table n&rsquo;est pas fournie en param\u00e8tre,<br \/>\n *  \talors elle est cherch\u00e9e dans le &lsquo;CreateTable.mysql&rsquo;.<br \/>\n *  \tSi le fichier n&rsquo;existe pas, la requ\u00eate utilis\u00e9e est contenue \u00ab\u00a0en dur\u00a0\u00bb dans le code<br \/>\n *<br \/>\n * @param\t$tab\tNom de la table \u00e0 cr\u00e9er dans la BD. (facultatif)<br \/>\n * @param\t$sql_create\tRequ\u00eate MySQL de la table \u00e0 cr\u00e9er dans la BD. (facultatif)<br \/>\n * @return\t\t\tNe rend pas de valeur.<br \/>\n *\/<br \/>\nfunction cree_table($pdo, $table=TABLE, $sql_create=\u00a0\u00bb) {<br \/>\n    \/\/global $pdo;<br \/>\n    if(!empty($sql_create))<br \/>\n      $sql = $sql_create;<br \/>\n    elseif(is_file(FICSQL))<br \/>\n      $sql = sprintf(file_get_contents(FICSQL, NULL, NULL), $table);<br \/>\n     else {<br \/>\n      $sql_param = \u00a0\u00bb<br \/>\nCREATE TABLE `%s` (<br \/>\n `id` int(11) NOT NULL AUTO_INCREMENT,<br \/>\n `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,<br \/>\n `titre` enum(&lsquo;Mme&rsquo;,&rsquo;Mlle&rsquo;,&rsquo;M.&rsquo;) DEFAULT NULL,<br \/>\n `nom` varchar(30) NOT NULL DEFAULT \u00a0\u00bb,<br \/>\n `pr\u00e9nom` varchar(30) DEFAULT NULL,<br \/>\n `adresse \u00e9lectronique` varchar(60) DEFAULT NULL,<br \/>\n `demande sur` enum(&lsquo;un logement&rsquo;,&rsquo;une offre de location&rsquo;,&rsquo;la salle de restaurant et la salle du bar (ERP)&rsquo;,&rsquo;une option&rsquo;,&rsquo;les moyens de paiement&rsquo;) DEFAULT NULL,<br \/>\n `sujet` varchar(60) DEFAULT NULL,<br \/>\n `votre message` varchar(60) DEFAULT NULL,<br \/>\n PRIMARY KEY (`id`)<br \/>\n) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci<br \/>\n      \u00ab\u00a0;<br \/>\n      $sql = sprintf($sql_param, $table);<br \/>\n    }<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;mysql&rsquo;) echo \u00ab\u00a0<\/p>\n<pre>$sql<\/pre>\n<p>\u00ab\u00a0;<\/p>\n<p>    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      echo \u00ab\u00a0La table MySQL <tt>$table<\/tt> a \u00e9t\u00e9 cr\u00e9\u00e9e.\u00a0\u00bb;<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<\/p>\n<p>}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction my_addslashes( $string )<br \/>\n * \\brief\tCette fonction ajoute des \\a antislashes devant les caract\u00e8res \u00ab\u00a0quote\u00a0\u00bb selon la configuration du serveur<br \/>\n *<br \/>\n * @param\t$string\tTexte \u00e0 traiter.<br \/>\n * @return\t\\e string\t\tTexte trait\u00e9.<br \/>\n *\/<br \/>\nfunction my_addslashes($string) {<br \/>\n    if (get_magic_quotes_gpc()) return $string;<br \/>\n    elseif (function_exists(&lsquo;addslashes&rsquo;)) return addslashes($string);<br \/>\n    else return mysql_real_escape_string($string);<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction insert_data( $data )<br \/>\n * \\brief\tCette fonction ins\u00e8re une ligne de donn\u00e9es dans la table MySQL<br \/>\n *<br \/>\n * @param\t$data\tTableau associatif PHP (\\e array ) contenant les valeurs d&rsquo;un enregistrement \u00e0 r\u00e9aliser dans une ligne de table MySQL.<br \/>\n * @return\t\\e integer\t\tIndentifiant de la ligne cr\u00e9\u00e9e dans la table MySQL.<br \/>\n *\/<br \/>\nfunction insert_data($pdo, $data) {<br \/>\n    \/\/global $pdo;<br \/>\n    \/\/ INSERT INTO `DD__contacts` (`titre` ,`nom` ,`prenom`) VALUES (&lsquo;M.&rsquo;, &lsquo;O&rsquo;\\&rsquo;Hara&rsquo;, &lsquo;Joe&rsquo;);<br \/>\n    \/\/    Remarque : id et date sont instanci\u00e9s avec les valeurs par d\u00e9faut<br \/>\n    $list_fields = get_fields($pdo);<br \/>\n    \/\/ SET `titre` = &lsquo;Mlle&rsquo; AND `nom`=&rsquo;Moi&rsquo; &#8230;<br \/>\n    foreach($list_fields as $df) {<br \/>\n      if($df[&lsquo;Field&rsquo;]!=PRIM &#038;&#038; $df[&lsquo;Field&rsquo;]!=DATE &#038;&#038; isset($_REQUEST[$df[&lsquo;Field&rsquo;]])) {<br \/>\n        $connect = (!isset($connect))?&rsquo; &lsquo;:&rsquo;, &lsquo;;<br \/>\n        $str_keys = @$str_keys . $connect . \u00ab\u00a0`\u00a0\u00bb.$df[&lsquo;Field&rsquo;].\u00a0\u00bb`\u00a0\u00bb;<br \/>\n        $str_vals = @$str_vals . $connect . \u00ab\u00a0&lsquo;\u00a0\u00bb.my_addslashes($_REQUEST[$df[&lsquo;Field&rsquo;]]).\u00a0\u00bb&lsquo;\u00a0\u00bb;<br \/>\n      }<br \/>\n    }<br \/>\n    $sql = &lsquo;INSERT INTO `&rsquo; .my_DB_NAME.&rsquo;`.`&rsquo;.TABLE.  \u00ab\u00a0` ($str_keys)  VALUES ($str_vals) \u00ab\u00a0;<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;mysql&rsquo;) echo \u00ab\u00a0<\/p>\n<pre>$sql<\/pre>\n<p>\u00ab\u00a0;<\/p>\n<p>    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      $no = $pdo->lastInsertId();<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n    return $no;<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction delete_data( $data )<br \/>\n * \\brief\tCette fonction supprime une ligne de donn\u00e9es de la table MySQL<br \/>\n *<br \/>\n * @param\t$id\tIdentifiant de l&rsquo;enregistrement \u00e0 supprimer.<br \/>\n * @return\t\\e boolean\t\tvalant TRUE seulement si la requ\u00eate MySQL n&rsquo;a pas g\u00e9n\u00e9r\u00e9 d&rsquo;erreur.<br \/>\n *\/<br \/>\nfunction delete_data($pdo, $id) {<br \/>\n    \/\/global $pdo;<br \/>\n    \/\/ DELETE FROM `wordpress`.`DD__contacts` WHERE `dd__contacts`.`id` = $id;<br \/>\n    $sql = &lsquo;DELETE FROM `&rsquo; .my_DB_NAME.&rsquo;`.`&rsquo; .TABLE. &lsquo;` WHERE `&rsquo; .PRIM. \u00ab\u00a0` = &lsquo;\u00a0\u00bb .$id. \u00ab\u00a0&lsquo; \u00ab\u00a0;<br \/>\n    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      return TRUE; \/\/ sort en rendant TRUE s&rsquo;il n&rsquo;y a pas eu d&rsquo;erreur MySQL<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction update_data( $data )<br \/>\n * \\brief\tCette fonction met \u00e0 jour une ligne de donn\u00e9es dans la table MySQL<br \/>\n *<br \/>\n * @param\t$id\tIdentifiant de l&rsquo;enregistrement \u00e0 mettre \u00e0 jour ; les informations \u00e0 prendre en compte sont r\u00e9cup\u00e9r\u00e9es par $_REQUEST.<br \/>\n * @return\t\\e boolean\t\tvalant TRUE seulement si la requ\u00eate MySQL n&rsquo;a pas g\u00e9n\u00e9r\u00e9 d&rsquo;erreur.<br \/>\n *\/<br \/>\nfunction update_data($pdo, $id=\u00a0\u00bb) { $id=$_REQUEST[PRIM];<br \/>\n    \/\/global $pdo;<br \/>\n    \/\/ UPDATE `wordpress`.`DD__contacts` SET `titre` = &lsquo;Mlle&rsquo; AND `nom`=&rsquo;Moi&rsquo; WHERE `dd__contacts`.`id` = $id;<br \/>\n    $list_fields = get_fields($pdo);<br \/>\n    \/\/ SET `titre` = &lsquo;Mlle&rsquo; AND `nom`=&rsquo;Moi&rsquo; &#8230;<br \/>\n    foreach($list_fields as $df) {<br \/>\n      if($df[&lsquo;Field&rsquo;]!=PRIM &#038;&#038; $df[&lsquo;Field&rsquo;]!=DATE) {<br \/>\n        $connect = (!isset($connect))?&rsquo;SET &lsquo;:&rsquo;, &lsquo;;<br \/>\n        $str_set = @$str_set . $connect . &lsquo;`&rsquo;.$df[&lsquo;Field&rsquo;].\u00a0\u00bb` = &lsquo;\u00a0\u00bb.$_REQUEST[$df[&lsquo;Field&rsquo;]].\u00a0\u00bb&lsquo; \u00ab\u00a0;<br \/>\n      }<br \/>\n    }<br \/>\n    $sql = &lsquo;UPDATE `&rsquo; .my_DB_NAME.&rsquo;`.`&rsquo; .TABLE. \u00ab\u00a0` $str_set  WHERE `\u00a0\u00bb .PRIM. \u00ab\u00a0` = &lsquo;\u00a0\u00bb .$_REQUEST[PRIM]. \u00ab\u00a0&lsquo; \u00ab\u00a0;<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;mysql&rsquo;) echo \u00ab\u00a0<\/p>\n<pre>$sql<\/pre>\n<p>\u00ab\u00a0;<\/p>\n<p>    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      return TRUE; \/\/ sort en rendant TRUE s&rsquo;il n&rsquo;y a pas eu d&rsquo;erreur MySQL<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n}<\/p>\n<p>function get_lasts($pdo, $nb=\u00a0\u00bb, $field_date=DATE) {<br \/>\n    \/\/global $pdo;<br \/>\n    \/\/ SELECT * FROM `DD__contacts` WHERE 1 ORDER BY date DESC LIMIT 4<br \/>\n    if(empty($nb)) $limit = \u00a0\u00bb;<br \/>\n    else $limit = \u00ab\u00a0LIMIT $nb\u00a0\u00bb;<br \/>\n    $sql = &lsquo;SELECT * FROM `&rsquo; .my_DB_NAME.&rsquo;`.`&rsquo;.TABLE.  \u00ab\u00a0` ORDER BY $field_date DESC $limit\u00a0\u00bb;<br \/>\n    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      while ($row = $prep->fetch(PDO::FETCH_ASSOC)) { $tab[] = $row; }<br \/>\n      return (isset($tab)?$tab:NULL);<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n}<\/p>\n<p>function get_one($pdo, $id) {<br \/>\n    \/\/global $pdo;<br \/>\n    \/\/ SELECT * FROM `DD__contacts` WHERE `id`= $d<br \/>\n    $sql = &lsquo;SELECT * FROM `&rsquo; .my_DB_NAME.&rsquo;`.`&rsquo;.TABLE.  \u00ab\u00a0` WHERE `\u00a0\u00bb.PRIM.\u00a0\u00bb` =  $id\u00a0\u00bb;<br \/>\n    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      while ($row = $prep->fetch(PDO::FETCH_ASSOC)) { $tab[] = $row; }<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n    return $tab;<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction affich_table( $tab, $pri=PRIM )<br \/>\n * \\brief\tCette fonction g\u00e9n\u00e8re le code HTML qui pr\u00e9sentera les donn\u00e9es d&rsquo;une table PHP dans un tableau HTML<br \/>\n * \tSi le texte d&rsquo;une des cl\u00e9s est le nom de la cl\u00e9 primaire,<br \/>\n *   alors on ajoute une case \u00e0 cocher pour s\u00e9lectionner plusieurs items et un bouton radio pour en choisir un<br \/>\n *<br \/>\n * @param\t$tab\tTable associative PHP (chaque cellule est index\u00e9 par une cl\u00e9 pouvant \u00eatre un texte)<br \/>\n * @param\t$pri\tNom d&rsquo;une cl\u00e9 \u00e0 utiliser pour porter les boutons radio et les cases \u00e0 cocher<br \/>\n * @return\t\\e string\t\tTexte HTML d&rsquo;un tableau<br \/>\n *\/<br \/>\nfunction affich_table($tab, $pri=PRIM) {<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;export&rsquo;) echo \u00ab\u00a0<\/p>\n<p>prim= $pri<\/p>\n<p>\u00ab\u00a0;<\/p>\n<p>    $strHTML_bulle = &lsquo;<\/p>\n<div id=\"infobulle\" class=\"bulle\" style=\"\">%s<\/div>\n<p>&lsquo;;<br \/>\n    $strJS_bulle = &lsquo;onmouseout=\u00a0\u00bbcache();\u00a0\u00bb onmouseover=\u00a0\u00bbmontre(\\&rsquo;%s\\&rsquo;);\u00a0\u00bb&lsquo;;<br \/>\n    $textbulle_checkbox = &lsquo;Cocher pour <b>s\u00e9lectionner<\/b>&lsquo;;<br \/>\n    $textbulle_radio = &lsquo;Cocher pour <b>choisir<\/b>&lsquo;;<\/p>\n<p>    $str =  sprintf($strHTML_bulle,\u00a0\u00bbEsp\u00e8ce de chouette mal empaill\u00e9e !\u00a0\u00bb);<\/p>\n<p>    $str .= \u00ab\u00a0<\/p>\n<table>\\n\u00a0\u00bb;<br \/>\n    foreach ($tab as $row) {<br \/>\n      if(empty($keys)) $keys = array_keys($row);<br \/>\n      $str .=  &lsquo; <\/p>\n<tr>&lsquo;;<br \/>\n      foreach ($keys as $k) {<br \/>\n        if($k==$pri) $str .=  &lsquo;<\/p>\n<th class=\"'.$k.'\"><input type=\"checkbox\" name=\"'.$k.'_'.$row[$k].'\" value=\"'.((@$_REQUEST[$k.'_'.$row[$k]])?'TRUE':'FALSE').'\" '.((@$_REQUEST[$k.'_'.$row[$k]])?'checked=\"checked\"':'').' '.sprintf($strJS_bulle,$textbulle_checkbox).' \/> &lsquo;<br \/>\n        \t\t\t\t  .$row[$k].&rsquo; <input type=\"radio\" name=\"'.$k.'\" value=\"'.$row[$k].'\" '.' '.sprintf($strJS_bulle,$textbulle_radio).'\/><\/th>\n<p>&lsquo;;<br \/>\n        else $str .= &lsquo;<\/p>\n<td class=\"'.$k.'\">&lsquo;.$row[$k].&rsquo;<\/td>\n<p>&lsquo;;<br \/>\n      }<br \/>\n      $str .= &lsquo; <\/tr>\n<p>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb ;<br \/>\n    }<br \/>\n    $str .= \u00ab\u00a0<\/table>\n<p>\\n\u00a0\u00bb;<br \/>\n    return $str;<br \/>\n}<\/p>\n<p>function get_table_csv($pdo, $table=TABLE) {<br \/>\n    \/\/global $pdo;<br \/>\n    \/\/ SELECT * FROM `DD__contacts` WHERE `id`= 2 or `id`= 3<br \/>\n    foreach(array_keys($_REQUEST) as $param) { \/\/echo &lsquo;<\/p>\n<pre>'.substr($param, 0, strlen(PRIM)+1).'<\/pre>\n<p>&lsquo;;<br \/>\n      if(substr($param, 0, strlen(PRIM)+1) == PRIM.&rsquo;_&rsquo;) {<br \/>\n        $connect = (!isset($connect))?&rsquo; `&rsquo;.PRIM.&rsquo;`= &lsquo;:&rsquo; OR `&rsquo;.PRIM.&rsquo;`= &lsquo;;<br \/>\n        $str_listOR = @$str_listOR . $connect . substr($param, strlen(PRIM)+1);<br \/>\n      }<br \/>\n    }<br \/>\n  if(!empty($str_listOR)) {<br \/>\n    $sql = \u00ab\u00a0SELECT * FROM `\u00a0\u00bb .my_DB_NAME.\u00a0\u00bb`.`$table` WHERE $str_listOR \u00ab\u00a0;<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;export&rsquo;) echo \u00ab\u00a0<\/p>\n<pre>$sql<\/pre>\n<p>\u00ab\u00a0;<br \/>\n    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      while ($row = $prep->fetch(PDO::FETCH_ASSOC)) { $tab[] = $row; }<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n    return $tab;<br \/>\n  }<br \/>\n}<\/p>\n<p>function affich_csv($table) {<br \/>\n    $str = \u00a0\u00bb;<br \/>\n    foreach ($table as $row) {<br \/>\n      if(empty($keys)) $keys = array_keys($row);<br \/>\n      foreach ($keys as $k) {<br \/>\n        $str .=  $row[$k].\u00a0\u00bb\\t\u00a0\u00bb;<br \/>\n      }<br \/>\n      $str .= \u00ab\u00a0\\n\u00a0\u00bb ;<br \/>\n    }<br \/>\n    return $str;<br \/>\n}<\/p>\n<p>function get_show_create($pdo, $table=TABLE) {<br \/>\n    \/\/global $pdo;<br \/>\n    $sql = &lsquo;SHOW CREATE TABLE  &lsquo; .$table. &lsquo; &lsquo; ;<br \/>\n    \/\/echo \u00ab\u00a0<\/p>\n<pre>$sql<\/pre>\n<p>\u00ab\u00a0;<\/p>\n<p>    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      if ($row = $prep->fetch(PDO::FETCH_ASSOC) ) {<br \/>\n        return $row[&lsquo;Create Table&rsquo;];<br \/>\n      }<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction get_fields_v0( $table=TABLE )<br \/>\n * \\brief\tCette fonction r\u00e9cup\u00e8re les \\e champs (noms des colonnes) de la table MySQL<br \/>\n * \\bug\tGard\u00e9e pour m\u00e9moire ; ne marche pas tout \u00e0 fait<br \/>\n *<br \/>\n * @param\t$table\tNom de la table MySQL .<br \/>\n * @return\t\\e array\t\tTableau PHP r\u00e9sultant de l&rsquo;analyse par expression r\u00e9guli\u00e8re de la requ\u00eate MySQL de cr\u00e9ation de la table<br \/>\n *\/<br \/>\nfunction get_fields_v0($pdo, $table=TABLE) {<br \/>\n\t\/\/ Note : rajout de $pdo dans les param\u00e8tres alors qu&rsquo;il n&rsquo;est pas n\u00e9cessaire quand on peut le d\u00e9clarer en global<br \/>\n\t\/\/  parce qu&rsquo;il est utilis\u00e9 dans une des fonctions utilis\u00e9es par celle-ci<br \/>\n    $sql_create = get_show_create($pdo, $table);<\/p>\n<p>    preg_match_all(\u00ab\u00a0\/`(.+)` (\\w+)\\(? ?(\\d*) ?\\)?\/\u00a0\u00bb, $sql_create, $_matches, PREG_SET_ORDER);<br \/>\n    \/\/{\u00a0echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($_matches); echo \"<\/pre>\n<p>\u00ab\u00a0; }<\/p>\n<p>    return $_matches;<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction get_fields( $table=TABLE )<br \/>\n * \\brief\tCette fonction r\u00e9cup\u00e8re les \\e champs (noms des colonnes) de la table MySQL<br \/>\n *<br \/>\n * @param\t$table\tNom de la table MySQL .<br \/>\n * @return\t\\e array\t\tTableau PHP \u00e0 2 dimensions : pour chaque colonne, 1 tableau associatif avec son nom, son type, si c&rsquo;est une cl\u00e9 primaire, sa valeur par d\u00e9faut&#8230;<br \/>\n *\/<br \/>\nfunction get_fields($pdo, $table=TABLE) {<br \/>\n    \/\/global $pdo;<br \/>\n    $sql = &lsquo;DESC  `&rsquo; .my_DB_NAME.&rsquo;`.`&rsquo;.$table. &lsquo;` &lsquo; ;<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;mysql&rsquo;) echo \u00ab\u00a0<\/p>\n<pre>$sql<\/pre>\n<p>\u00ab\u00a0;<\/p>\n<p>    $prep = $pdo->prepare($sql);<br \/>\n    try {<br \/>\n      $prep->execute();<br \/>\n      while ($row = $prep->fetch(PDO::FETCH_ASSOC) ) $tab_fields[] = $row; {<br \/>\n        if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;mysql&rsquo;) { echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($row); echo \"<\/pre>\n<p>\u00ab\u00a0; }<br \/>\n      }<br \/>\n    } catch( Exception $e ){<br \/>\n      echo &lsquo;Erreur de requ\u00eate : &lsquo;, $e->getMessage();<br \/>\n    }<br \/>\n    return $tab_fields;<br \/>\n}<\/p>\n<p>function affich_fieldset_table($pdo, $table=TABLE) {<br \/>\n\t\/\/ Note : rajout de $pdo dans les param\u00e8tres alors qu&rsquo;il n&rsquo;est pas n\u00e9cessaire quand on peut le d\u00e9clarer en global<br \/>\n\t\/\/  parce qu&rsquo;il est utilis\u00e9 dans une des fonctions utilis\u00e9es par celle-ci<br \/>\n\t$list_fields = get_fields($pdo, $table);<br \/>\n    if(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;mysql&rsquo;) { echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($list_fields); echo \"<\/pre>\n<p>\u00ab\u00a0; }<\/p>\n<p>    $str = \u00ab\u00a0<\/p>\n<fieldset>\\n\u00a0\u00bb;<br \/>\n    $str .= \u00ab\u00a0<\/p>\n<legend>Renseigner le formulaire <code>$table<\/code><\/legend>\n<p>\\n\u00a0\u00bb;<\/p>\n<p>    foreach ($list_fields as $df) {<br \/>\n      if($df[&lsquo;Default&rsquo;]!=&rsquo;CURRENT_TIMESTAMP&rsquo;) {<br \/>\n        \/\/ { echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($df); echo \"<\/pre>\n<p>\u00ab\u00a0; }<br \/>\n        $field = $df[&lsquo;Field&rsquo;];<br \/>\n        if($df[&lsquo;Key&rsquo;]==&rsquo;PRI&rsquo;) {<br \/>\n          if (!empty($_REQUEST[$field])) {<br \/>\n            $str .= &lsquo;<span class=\"PRIM\">&lsquo;.$_REQUEST[$field].&rsquo;<input type=\"hidden\" size=\"30\" name=\"'.$field.'\" value=\"'.$_REQUEST[$field].'\" \/><\/span>&lsquo;. \u00ab\u00a0\\n\u00a0\u00bb ;<br \/>\n          }<br \/>\n        }<br \/>\n        elseif(substr($df[&lsquo;Type&rsquo;], 0,strlen(&lsquo;enum&rsquo;))==&rsquo;enum&rsquo;) {<br \/>\n          $str .= &lsquo;<br \/> &lsquo;.$df[&lsquo;Field&rsquo;].&rsquo; : \u00a0 &lsquo;;<br \/>\n          $liste = explode(\u00ab\u00a0&lsquo;,'\u00a0\u00bb, substr($df[&lsquo;Type&rsquo;], strlen(&lsquo;enum&rsquo;)+2, -2));<br \/>\n          \/\/ { echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($liste); echo \"<\/pre>\n<p>\u00ab\u00a0; }<br \/>\n          \/\/foreach (array(&lsquo;Mme&rsquo;,&rsquo;Mlle&rsquo;,&rsquo;M.&rsquo;,&rsquo;Dr&rsquo;) as $t) {<br \/>\n          foreach ($liste as $t) {<\/p>\n<p>            $str_checked = (@$_REQUEST[$field]==$t)?&rsquo;checked&rsquo;:\u00a0\u00bb;<br \/>\n            $str .=  &lsquo;<input type=\"radio\" size=\"30\" name=\"'.$field.'\" value=\"'.$t.'\" '.$str_checked.' class=\"'.$field.'\" \/>&lsquo;.$t.&rsquo; \u00a0 \u00a0 \u00a0 &lsquo;;<\/p>\n<p>          }<br \/>\n          $str .= \u00ab\u00a0\\n\u00a0\u00bb;<br \/>\n        }<br \/>\n        else {<br \/>\n          $str .= &lsquo; <\/p>\n<caption>&lsquo;.$field<br \/>\n              .&rsquo;   <input type=\"text\" size=\"30\" name=\"'.$field.'\" value=\"'.stripslashes(@$_REQUEST[$field]).'\" class=\"'.$field.'\" \/>&lsquo;<br \/>\n              . \u00ab\u00a0\\n\u00a0\u00bb ;<br \/>\n        }<br \/>\n      }<br \/>\n    }<br \/>\n    $str .= \u00ab\u00a0<\/fieldset>\n<p>\\n\u00a0\u00bb;<br \/>\n    return $str;<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction get_primary_key( $table=TABLE )<br \/>\n * \\brief\tCette fonction r\u00e9cup\u00e8re la cl\u00e9 \\e primaire de la table MySQL<br \/>\n *<br \/>\n * @param\t$table\tNom de la table MySQL .<br \/>\n * @return\t\\e string\t\tNom du champ qui est la cl\u00e9 primaire de la table<br \/>\n *\/<br \/>\nfunction get_primary_key($pdo, $table=TABLE) {<br \/>\n\t\/\/ Note : rajout de $pdo dans les param\u00e8tres alors qu&rsquo;il n&rsquo;est pas n\u00e9cessaire quand on peut le d\u00e9clarer en global<br \/>\n\t\/\/  parce qu&rsquo;il est utilis\u00e9 dans une des fonctions utilis\u00e9es par celle-ci<br \/>\n\t$list_fields = get_fields($pdo, $table);<br \/>\n    \/\/ {\u00a0echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($list_fields); echo \"<\/pre>\n<p>\u00ab\u00a0; }<br \/>\n    foreach ($list_fields as $df) {<br \/>\n        if($df[&lsquo;Key&rsquo;]==&rsquo;PRI&rsquo;) { return $df[&lsquo;Field&rsquo;]; }<br \/>\n    }<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\fn\tfunction get_date_key( $table=TABLE )<br \/>\n * \\brief\tCette fonction r\u00e9cup\u00e8re le nom du champ dont la valeur par d\u00e9faut est la date courante<br \/>\n *<br \/>\n * @param\t$table\tNom de la table MySQL .<br \/>\n * @return\t\\e string\t\tNom du premier champ trouv\u00e9 dans la liste des champs dont la valeur par d\u00e9faut est CURRENT_TIMESTAMP<br \/>\n *\/<br \/>\nfunction get_date_key($pdo, $table=TABLE) {<br \/>\n\t\/\/ Note : rajout de $pdo dans les param\u00e8tres alors qu&rsquo;il n&rsquo;est pas n\u00e9cessaire quand on peut le d\u00e9clarer en global<br \/>\n\t\/\/  parce qu&rsquo;il est utilis\u00e9 dans une des fonctions utilis\u00e9es par celle-ci<br \/>\n\t$list_fields = get_fields($pdo, $table);<br \/>\n    \/\/ { echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($list_fields); echo \"<\/pre>\n<p>\u00ab\u00a0; }<br \/>\n    foreach ($list_fields as $df) {<br \/>\n        if($df[&lsquo;Default&rsquo;]==&rsquo;CURRENT_TIMESTAMP&rsquo;) { return $df[&lsquo;Field&rsquo;]; }<br \/>\n    }<br \/>\n}<\/p>\n<p>\/**<br \/>\n * ===TEST=== Affichage pour v\u00e9rifier que les valeurs du formulaire sont bien re\u00e7ues par le serveur<br \/>\n  *\/<br \/>\nif(defined(&lsquo;DEBUG&rsquo;) &#038;&#038; DEBUG==&rsquo;test&rsquo;) foreach($_GET as $k=>$v) echo \u00ab\u00a0<code>$k<\/code> <tt>$v<\/tt><br \/>\\n\u00a0\u00bb;<\/p>\n<p>[\/insert_php] <\/p>\n<form action=\"\" method=\"get\">\n[insert_php]<br \/>\n\/**<br \/>\n * === Connexion === Inclusion du fichier de connexion<br \/>\n *\/<br \/>\n\/\/include(&lsquo;_connexion-MPO.php&rsquo;);<\/p>\n<p>  define(&lsquo;my_DB_NAME&rsquo;,DB_NAME); \/\/ on prend la m\u00eame DB que WordPress<br \/>\n if(!defined(&lsquo;DB_HOST&rsquo;)) { \/\/ pour ne pas chercher \u00e0 d\u00e9finir les constantes si on est dans WP<br \/>\n  define(&lsquo;DB_HOST&rsquo;,DB_HOST); \/\/&rsquo;localhost:8889&prime;;\/\/pour MAMP&#8230; 127.0.0.1:3307<br \/>\n  define(&lsquo;DB_USER&rsquo;,&rsquo;root&rsquo;);<br \/>\n  define(&lsquo;DB_PASSWORD&rsquo;,&rsquo;root&rsquo;);<\/p>\n<p>  echo &lsquo;<\/p>\n<p> &lsquo;.DB_USER.&rsquo; @ &lsquo;.DB_HOST.&rsquo; > &lsquo;.my_DB_NAME.&rsquo;<\/p>\n<p>&lsquo;;<br \/>\n }<\/p>\n<p>  try {<br \/>\n    $strConnection = &lsquo;mysql:host=&rsquo;.DB_HOST.&rsquo;;dbname=&rsquo;.my_DB_NAME;<br \/>\n    $arrExtraParam= array(PDO::MYSQL_ATTR_INIT_COMMAND => \u00ab\u00a0SET NAMES utf8\u00a0\u00bb);<br \/>\n    $pdo = new PDO($strConnection, DB_USER, DB_PASSWORD, $arrExtraParam);<br \/>\n    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<br \/>\n  }<br \/>\n  catch(PDOException $e) {<br \/>\n    $msg = &lsquo;ERREUR PDO dans &lsquo; . $e->getFile() . &lsquo; L.&rsquo; . $e->getLine() . &lsquo; : &lsquo; . $e->getMessage();<br \/>\n    die($msg);<br \/>\n  }<\/p>\n<p>\/**<br \/>\n * === Initialisation === Cr\u00e9ation de la table si elle n&rsquo;existe pas ; r\u00e9cup\u00e9ration des nom des cl\u00e9s primaires et date<br \/>\n *\/<\/p>\n<p>\/\/$result = test_exist_table(TABLE); echo ($result ?&rsquo;OUI&rsquo;:&rsquo;NON&rsquo;);<br \/>\nif (!test_exist_table($pdo, TABLE)) cree_table($pdo, TABLE);<br \/>\nelse {<br \/>\n\/\/  echo &lsquo;La table <code>'.TABLE. \"<\/code> existe d\u00e9j\u00e0.\u00a0\u00bb;<br \/>\n}<\/p>\n<p>\/**<br \/>\n * \\enum DATE<br \/>\n * \\brief Nom de la colonne m\u00e9morisant la date courante.<br \/>\n *\/<br \/>\ndefine(&lsquo;DATE&rsquo;, get_date_key($pdo));  <\/p>\n<p>\/**<br \/>\n * \\enum PRIM<br \/>\n * \\brief Nom de la colonne portant l&rsquo;index.<br \/>\n *\/<br \/>\ndefine(&lsquo;PRIM&rsquo;, get_primary_key($pdo));  <\/p>\n<p>\/**<br \/>\n * === Programme Principal === Gros \u00ab\u00a0switch\u00a0\u00bb pour associer les bonnes actions aux boutons<br \/>\n *\/<\/p>\n<p>switch(@$_REQUEST[&lsquo;lancer&rsquo;]) {<br \/>\n  case &lsquo;Nouveau&rsquo;:<br \/>\n    echo affich_fieldset_table($pdo,TABLE);<\/p>\n<p>    $nb1 = rand(1,99); $nb2 = rand(1,99);<br \/>\n    echo &lsquo; <input type=\"hidden\" name=\"calcul-demande\" value=\"'.md5($nb1 + $nb2).'\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"text\" name=\"calcul-reponse\" value=\" remplacer par la valeur de '.$nb1.' + '.$nb2.'\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<\/p>\n<p>    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Sauver\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Derniers\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n   break;<\/p>\n<p>  case &lsquo;Sauver&rsquo;:<br \/>\n    unset($_REQUEST[&lsquo;lancer&rsquo;]);<br \/>\n    \/\/if ($_REQUEST[&lsquo;calcul-demande&rsquo;] != $_REQUEST[&lsquo;calcul-reponse&rsquo;]) {<br \/>\n    \/\/if (!hash_equals($_REQUEST[&lsquo;calcul-demande&rsquo;], md5($_REQUEST[&lsquo;calcul-reponse&rsquo;], $_REQUEST[&lsquo;calcul-demande&rsquo;]))) {<br \/>\n    if ($_REQUEST[&lsquo;calcul-demande&rsquo;] != md5($_REQUEST[&lsquo;calcul-reponse&rsquo;])) {<br \/>\n        echo &lsquo;erreur de calcul !&rsquo;;<br \/>\n        echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Nouveau\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    } else {<br \/>\n        unset($_REQUEST[&lsquo;calcul-demande&rsquo;]);<br \/>\n        unset($_REQUEST[&lsquo;calcul-reponse&rsquo;]);<br \/>\n        if($i = insert_data($pdo, $_REQUEST)) echo \u00a0\u00bb La ligne n\u00b0 $i vient d&rsquo;\u00eatre ins\u00e9r\u00e9e.<br \/>\\n\u00a0\u00bb ;<br \/>\n        if($t_insert = get_lasts($pdo, 1,DATE)) {<br \/>\n          echo affich_table($t_insert);<br \/>\n        }<br \/>\n        echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Modifier\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n        echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Nouveau\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n        echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Derniers\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n        echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Tout afficher\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    }<\/p>\n<p>   break;<\/p>\n<p>  case &lsquo;Derniers&rsquo;:<br \/>\n    if($t_derniers = get_lasts($pdo, 4,DATE)) {<br \/>\n      echo affich_table($t_derniers);<br \/>\n    }<br \/>\n    else echo \u00ab\u00a0Aucune ligne trouv\u00e9e, rien \u00e0 afficher.<br \/>\\n\u00a0\u00bb;<\/p>\n<p>    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Nouveau\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Tout afficher\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n   break;<\/p>\n<p>  case &lsquo;Tout afficher&rsquo;:<br \/>\n    if($t_tous = get_lasts($pdo)) {<br \/>\n      echo affich_table($t_tous);<br \/>\n    }<br \/>\n    else echo \u00ab\u00a0Aucune ligne trouv\u00e9e, rien \u00e0 afficher.<br \/>\\n\u00a0\u00bb;<\/p>\n<p>    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Derniers\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Supprimer\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Modifier\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Nouveau\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Filtrer\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n   break;<\/p>\n<p>  case &lsquo;Supprimer&rsquo;:<br \/>\n    if(empty($_REQUEST[PRIM])) {<br \/>\n      echo \u00ab\u00a0Vous devez d&rsquo;abord s\u00e9lectionnez une ligne&#8230; <br \/>\\n\u00a0\u00bb;<br \/>\n    }<br \/>\n    elseif(delete_data($pdo, $_REQUEST[PRIM]))<br \/>\n      echo \u00ab\u00a0La suppression du n\u00b0\u00a0\u00bb.$_REQUEST[PRIM].\u00a0\u00bb a \u00e9t\u00e9 demand\u00e9e.<br \/>\\n\u00a0\u00bb;<\/p>\n<p>    if($t_tous = get_lasts($pdo)) {<br \/>\n      echo affich_table($t_tous);<br \/>\n    }<\/p>\n<p>\techo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Supprimer\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Nouveau\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Tout afficher\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n   break;<\/p>\n<p>  case &lsquo;Modifier&rsquo;:<br \/>\n    if (isset($_REQUEST[PRIM]) &#038;&#038; $ligne=get_one($pdo, $_REQUEST[PRIM])[0]){<br \/>\n     if( $_REQUEST = array_merge($_REQUEST, $ligne)) {<br \/>\n      \/\/ { echo \u00ab\u00a0<\/p>\n<pre>\"; print_r($_REQUEST); echo \"<\/pre>\n<p>\u00ab\u00a0; }<br \/>\n      echo affich_fieldset_table($pdo);<br \/>\n     }<br \/>\n\t}<br \/>\n\telse {<br \/>\n\t\techo \u00ab\u00a0Vous devez d&rsquo;abord s\u00e9lectionner une ligne (bouton radio)\u00a0\u00bb;<br \/>\n\t\tif($t_tous = get_lasts($pdo)) {<br \/>\n          echo affich_table($t_tous);<br \/>\n        }<br \/>\n\t} <\/p>\n<p>    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Mettre \u00e0 jour\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"reset\" name=\"lancer\" value=\"Revenir\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n   break;<\/p>\n<p>  case &lsquo;Mettre \u00e0 jour&rsquo;:<br \/>\n    if(update_data($pdo)) echo \u00a0\u00bb La ligne n\u00b0 \u00ab\u00a0.$_REQUEST[PRIM].\u00a0\u00bb vient d&rsquo;\u00eatre modifi\u00e9e.<br \/>\\n\u00a0\u00bb ;<br \/>\n    if($t_ajour = get_one($pdo, $_REQUEST[PRIM])) {<br \/>\n      echo affich_table($t_ajour);<br \/>\n    }<\/p>\n<p>    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Modifier\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Nouveau\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Derniers\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Tout afficher\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n   break;<\/p>\n<p>  case &lsquo;Filtrer&rsquo;:<br \/>\n    if($t_filtre = get_table_csv($pdo)) {<br \/>\n      echo affich_table($t_filtre);<br \/>\n    }<br \/>\n    else echo \u00ab\u00a0Aucune ligne trouv\u00e9e, rien \u00e0 afficher.<br \/>\\n\u00a0\u00bb;<\/p>\n<p>    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Derniers\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Tout afficher\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Filtrer\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Exporter\" \/>&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n   break;<\/p>\n<p>  case &lsquo;Exporter&rsquo;:<br \/>\n    if($t_export = get_table_csv($pdo)) {<br \/>\n      echo &lsquo;<\/p>\n<pre>'.affich_csv($t_export).'<\/pre>\n<p>&lsquo;;<br \/>\n    }<br \/>\n   break;<\/p>\n<p>  default:<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Nouveau\">&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n    echo &lsquo; <input type=\"submit\" name=\"lancer\" value=\"Derniers\">&lsquo;.\u00a0\u00bb\\n\u00a0\u00bb;<br \/>\n}<\/p>\n<p>[\/insert_php]\n<\/p><\/form>\n","protected":false},"excerpt":{"rendered":"<p>Cette page vous permet de nous contacter au sujet de notre politique de confidentialit\u00e9. [insert_php] \/** * \\project Simply adaptable form * \\brief This PHP code can be easily adapt for simple form connected with MySQL BD * \\version 1.0.1 * \\author Val\u00e9rie Bellynck * \\author uri http:\/\/tiprof.fr * \\domain adaptablePHPform * * Copyright 2017-2018 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/lacdegrandmaison.fr\/cms\/confidentialite\/contact-rgdp\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;Contact RGDP&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":594,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/pages\/607"}],"collection":[{"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":24,"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/pages\/607\/revisions"}],"predecessor-version":[{"id":635,"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/pages\/607\/revisions\/635"}],"up":[{"embeddable":true,"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/pages\/594"}],"wp:attachment":[{"href":"http:\/\/lacdegrandmaison.fr\/cms\/wp-json\/wp\/v2\/media?parent=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}