{"id":617,"date":"2020-04-14T15:54:13","date_gmt":"2020-04-14T13:54:13","guid":{"rendered":"http:\/\/bernard-visse.fr\/ev\/?page_id=617"},"modified":"2020-04-14T15:54:13","modified_gmt":"2020-04-14T13:54:13","slug":"auteurs-vosgiens","status":"publish","type":"page","link":"https:\/\/bernard-visse.fr\/ev\/auteurs-vosgiens\/","title":{"rendered":"Auteurs vosgiens"},"content":{"rendered":"\n      <table width=\"100%\" border=\"0\" cellspacing=\"10\" cellpadding=\"0\">\n        <tr> \n          <td><span class=\"titre\">Rechercher un Auteur<\/span><\/td>\n          <td><div align=\"right\"><a href=\"index.php\"><span class=\"petit\">Nouvelle recherche<\/span><\/a><\/div><\/td>\n        <\/tr>\n        <tr> \n          <td colspan=\"2\"> \n            <?php\n\t\t\techo\"$pb\";\n\t\t\t\t?>\n          <\/td>\n        <\/tr>\n        <tr> \n          <td colspan=\"2\"> \n            <?php\n$recherche=$_GET['recherche'];\n$search=$_GET['search'];\n$autre=$_GET['autre'];\n$chrono=$_GET['chrono'];\n$toutechrono=$_GET['toutechrono'];\n$operateur=$_GET['operateur'];\n$oeuvre=$_GET['oeuvre'];\n$lieu=$_GET['lieu'];\nif(!$_GET['Metier']){\n$Metier='a';\n}\nelse{\n$Metier=$_GET['Metier'];\n}\n\/\/\n\/\/cas d'une recherche\n\/\/\nif($search || $chrono || $toutechrono || $autre || $oeuvre || $lieu){\n$limit=20;\nif($_GET['debut']){\n$debut=$_GET['debut'];\n}\nelse{\n$debut=0;\n}\n$operateur=trim($operateur);\n$recherche=trim($recherche);\n$recherche= str_replace( \"'\" , \"&#038;&#038;\",$recherche);\n\n\/\/cas d'une recherche par Nom\n\/\/ cas 1 jf 10\/2005\nif($operateur == \"one\"){\n\t$cas=1;\n\t$cas2=2;\n\t$machin=\"\";\n\t$req = \" SELECT Id FROM Ecri_Individu WHERE Nom like '%$recherche%' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n\t$requete=mysql_query($req);\n\t$h = @mysql_num_rows($requete);\n\t$y=0;\n\tif($h!=1){\n\t\twhile($r = @mysql_fetch_array($requete)){\n\t\t\t$truc[$y]=$r[0];\n\t\t\t$y++;\n\t\t\t}\n\t\t$machin=\"Id='\".$truc[0].\"'\";\n\t\tfor($u=1;$u<$h;$u++){\n\t\t\t$machin.=\" OR Id='\".$truc[$u].\"'\";\n\t\t\t}\n\t\t}\n\telse{\n\t\t$r=mysql_result($requete,\"Ecri_Individu\");\n\t\t$machin=\"Id='$r'\";\n\t\t}\n\t\n\t$req = \" SELECT Ecri_Individu.Id FROM Ecri_Individu,Ecri_Pseudo WHERE Ecri_Individu.Id_Pseudo=Ecri_Pseudo.Id_Pseudo AND Ecri_Pseudo.Pseudo_Nom like '%$recherche%' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n\t$requete=mysql_query($req);\n\t$h = @mysql_num_rows($requete);\n\t$y=0;\n\twhile($r = @mysql_fetch_array($requete)){\n\t$truc[$y]=$r['0'];\n\t$y++;\n\t}\n\tif($machin==\"\"){\n\t\t$machin=\"Id='\".$truc[0].\"'\";\n\t\t}\n\telse{\n\t\t$machin.=\" OR Id='\".$truc[0].\"'\";\n\t\t}\n\tfor($u=1;$u<$h;$u++){\n\t\t$machin.=\" OR Id='\".$truc[$u].\"'\";\n\t\t}\n\t\n\t$req = \" SELECT * FROM Ecri_Individu WHERE $machin ORDER BY Nom, Prenom \";\n}\n\n\/\/cas d'une recherche par Prenom\nif($operateur == \"two\"){\n$cas=2;\n$cas2=1;\n$machin=\"\";\n$req = \" SELECT Id FROM Ecri_Individu WHERE Prenom like '%$recherche%' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n$requete=mysql_query($req);\n$h = @mysql_num_rows($requete);\n$y=0;\nif($h!=1){\nwhile($r = @mysql_fetch_array($requete)){\n$truc[$y]=$r[0];\n$y++;\n}\n$machin=\"Id='\".$truc[0].\"'\";\nfor($u=1;$u<$h;$u++){\n$machin.=\" OR Id='\".$truc[$u].\"'\";\n}\n}\nelse{\n$r=mysql_result($requete,\"Ecri_Individu\");\n$machin=\"Id='$r'\";\n}\n\n$req = \" SELECT Ecri_Individu.Id FROM Ecri_Individu,Ecri_Pseudo WHERE Ecri_Individu.Id_Pseudo=Ecri_Pseudo.Id_Pseudo AND Ecri_Pseudo.Pseudo_Prenom like '%$recherche%' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n$requete=mysql_query($req);\n$h = @mysql_num_rows($requete);\n$y=0;\nwhile($r = @mysql_fetch_array($requete)){\n$truc[$y]=$r['0'];\n$y++;\n}\nif($machin==\"\"){\n$machin=\"Id='\".$truc[0].\"'\";\n}\nelse{\n$machin.=\" OR Id='\".$truc[0].\"'\";\n}\nfor($u=1;$u<$h;$u++){\n$machin.=\" OR Id='\".$truc[$u].\"'\";\n}\n\n$req = \" SELECT * FROM Ecri_Individu WHERE $machin ORDER BY Nom, Prenom \";\n}\n\n\/\/cas d'une recherche par BirthYear\nif($operateur == \"three\"){\n$cas=2;\n$cas2=1;\n$req = \" SELECT * FROM Ecri_Individu WHERE Naiss_Year='$recherche' AND Metier='$Metier' ORDER BY SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom \";\n}\n\/\/cas d'une recherche par DeathYear\nif($operateur == \"four\"){\n$cas=2;\n$cas2=1;\n$req = \" SELECT * FROM Ecri_Individu WHERE Mort_Year='$recherche' AND Metier='$Metier' ORDER BY SUBSTRING(Mort_Date,4,2), SUBSTRING(Mort_Date,1,2), Nom, Prenom \";\n}\n\/\/cas d'une recherche par premiere lettre nom\nif($operateur == \"five\"){\n$cas=1;\n$cas2=2;\n$req = \" SELECT * FROM Ecri_Individu WHERE SUBSTRING(Nom, 1, 1) = '$recherche' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n}\n\n\/\/cas d'une recherche par premiere lettre prenom\nif($operateur == \"six\"){\n$cas=2;\n$cas2=1;\n$req = \" SELECT * FROM Ecri_Individu WHERE SUBSTRING(Prenom, 1, 1) = '$recherche' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n}\n\n\/\/cas d'une recherche par oeuvre\nif($oeuvre){\n$cas=2;\n$cas2=1;\n$req = \" SELECT Id FROM Ecri_Oeuvre WHERE Titre like '%$recherche%'\";\n$requete=mysql_query($req);\n$h = @mysql_num_rows($requete);\n$y=0;\nif($h!=1){\nwhile($r = @mysql_fetch_array($requete)){\n$truc[$y]=$r[0];\n$y++;\n}\n$machin=\"Id='\".$truc[0].\"'\";\nfor($u=1;$u<$h;$u++){\n$machin.=\" OR Id='\".$truc[$u].\"'\";\n}\n}\nelse{\n$r=@mysql_result($requete,\"Ecri_Oeuvre\");\n$machin=\"Id='$r'\";\n}\n$req = \" SELECT * FROM Ecri_Individu WHERE $machin ORDER BY Nom, Prenom \";\n}\n\n\/\/cas d'une recherche par lieu\nif($lieu){\n$cas=2;\n$cas2=1;\nif($operateur=='one'){\n$req = \" SELECT * FROM Ecri_Individu WHERE Lieu_Naiss like '%$recherche%' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n}\nif($operateur=='two'){\n$req = \" SELECT * FROM Ecri_Individu WHERE Lieu_Mort like '%$recherche%' AND Metier='$Metier' ORDER BY Nom, Prenom \";\n}\n}\n\n\/\/cas d'une recherche chronologique\n\tif($toutechrono || $chrono){\n\t$cas=2;\n\t$cas2=1;\n\tif($chrono){\n\t\t$nombre=strlen(\"$operateur\");\n\t\tif($nombre==3){\n\t\t$cond=\"SUBSTRING(Naiss_Year, 1, 3) = '$operateur' AND\";\n\t\t}\n\t\tif($nombre==2){\n\t\tif(substr ( $nombre , 0 , 1 )==1){\n\t\t$cond=\"SUBSTRING(Naiss_Year, 1, 2) = '$operateur' AND Naiss_Year < 200 AND\";\n\t\t}\n\t\telse{\n\t\t$cond=\"SUBSTRING(Naiss_Year, 1, 2) = '$operateur' AND\";\n\t\t}\n\t\t}\n\t\t$name=\"chrono\";\n\t\t}\n\telse{\n\t\t$name=\"toutechrono\";\n\t\t$cond=\"\";\n\t\t}\n\n\t$ress=@mysql_query(\"SELECT * FROM Ecri_Individu WHERE $cond Metier='$Metier' ORDER BY Naiss_Year \");\n\t$how = @mysql_num_rows($ress);\n\t@mysql_free_result($ress);\n\t$how2=$how;\n\t$and = \"\";\n\t$p=0;\n\t\n\tfor($i=0;$i<$how2;$i++){\n\t\t$minan= @mysql_result(@mysql_query(\"SELECT MIN(Naiss_Year) FROM Ecri_Individu WHERE $cond Metier='$Metier' $and\"),\"Ecri_Individu ORDER BY Naiss_Year\");\n\t\t$Ident= @mysql_query(\"SELECT Id FROM Ecri_Individu WHERE $cond Metier='$Metier' AND Naiss_Year='$minan' ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom  \");\n\t\t$comb = @mysql_num_rows($Ident);\n\t\t\n\t\tif($comb==1){\n\t\t\t$ident[$i+$p]=@mysql_result($Ident,\"Ecri_Individu\");\n\t\t\t$and .= \"AND Id !='\".$ident[$i+$p].\"'\";\n\t\t\t}\n\t\telse{\n\t\t\twhile($r = @mysql_fetch_array($Ident)){\n\t\t\t\t$ident[$i+$p]=$r[0];\n\t\t\t\t$and .= \"AND Id !='\".$ident[$i+$p].\"'\";\n\t\t\t\t$p++;\n\t\t\t\t$how2--;\n\t\t\t\t}\n\t\t\t$p--;\n\t\t\t$how2++;\n\t\t\t}\n\t\t@mysql_free_result($Ident);\n\t\t}\n\t\n\tfor($p=0;$p<$how;$p++){\n\t\t$row[1] = @mysql_result(@mysql_query(\"SELECT Nom FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[2] = @mysql_result(@mysql_query(\"SELECT Prenom FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[3] = @mysql_result(@mysql_query(\"SELECT Naiss_Year FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[4] = @mysql_result(@mysql_query(\"SELECT Mort_Year FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[5] = @mysql_result(@mysql_query(\"SELECT Comment FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[6] = @mysql_result(@mysql_query(\"SELECT Lieu_Naiss FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[7] = @mysql_result(@mysql_query(\"SELECT Lieu_Mort FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[11] = @mysql_result(@mysql_query(\"SELECT Id_Bio FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[10] = @mysql_result(@mysql_query(\"SELECT Id_Pseudo FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[12] = @mysql_result(@mysql_query(\"SELECT Ajout_Bibli FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[13] = @mysql_result(@mysql_query(\"SELECT Naiss_Date FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[14] = @mysql_result(@mysql_query(\"SELECT Mort_Date FROM Ecri_Individu WHERE Id='\".$ident[$p].\"'\"),\"Ecri_Individu ORDER BY Naiss_Year, SUBSTRING(Naiss_Date,4,2), SUBSTRING(Naiss_Date,1,2), Nom, Prenom\");\n\t\t$row[1]= str_replace( \"&#038;&#038;\" , \"'\",$row[1]);\n\t\t$row[2]= str_replace( \"&#038;&#038;\" , \"'\",$row[2]);\n\t\t$row[4]= str_replace( \"&#038;&#038;\" , \"'\",$row[4]);\n\t\t$row[5]= str_replace( \"&#038;&#038;\" , \"'\",$row[5]);\n\t\t$row[3]= str_replace( \"&#038;&#038;\" , \"'\",$row[3]);\n\t\t$row[6]= str_replace( \"&#038;&#038;\" , \"'\",$row[6]);\n\t\t$row[7]= str_replace( \"&#038;&#038;\" , \"'\",$row[7]);\n\t$requete=mysql_query(\"SELECT * FROM Ecri_Oeuvre WHERE Id='\".$ident[$p].\"'\");\n\t$n = @mysql_num_rows($requete);\n\t\n\tif($row[11]!=0 || $row[12] || $n!=0){\n\t\t$form=\"<form id=\\\"formname\\\" action=\\\"bio_bibli.php\\\" method=\\\"GET\\\" name=\\\"formname\\\">\n\t\t<input type=\\\"hidden\\\" name=\\\"id\\\" value=\\\"\".$ident[$p].\"\\\" >\n\t\t<input type=\\\"hidden\\\" name=\\\"id_bio\\\" value=\\\"\".$row[11].\"\\\" >\u00ab\u00a0;\n\t\tif($row[11]!=0){\n\t\t\t$form.=\u00a0\u00bb<input type=\\\"submit\\\" name=\\\"bio$name\\\" value=\\\"Bio\\\">\u00ab\u00a0;\n\t\t\t}\n\t\tif($row[12] || $n!=0){\n\t\t\t$form.=\u00a0\u00bb<input type=\\\"submit\\\" name=\\\"bibli$name\\\" value=\\\"Biblio\\\">\u00ab\u00a0;\n\t\t\t}\n\t\t$form.=\u00a0\u00bb<input type=\\\"hidden\\\" name=\\\"operateur\\\" value=\\\"$operateur\\\" ><input type=\\\"hidden\\\" name=\\\"Id_Pseudo\\\" value=\\\"\".$row[10].\"\\\" ><\/form>\u00ab\u00a0;\n\t\t}\n\telse{\n\t\t$form=\u00a0\u00bb<br><br>\u00ab\u00a0;\n\t\t}\n\t\n\tif($row[10]!=0){\n\t\t$nom=mysql_result(mysql_query(\u00ab\u00a0SELECT Pseudo_Nom FROM Ecri_Pseudo WHERE Id_Pseudo='\u00a0\u00bb.$row[10].\u00a0\u00bb&lsquo;\u00a0\u00bb),\u00a0\u00bbEcri_Pseudo\u00a0\u00bb);\n\t\t$prenom=mysql_result(mysql_query(\u00ab\u00a0SELECT Pseudo_Prenom FROM Ecri_Pseudo WHERE Id_Pseudo='\u00a0\u00bb.$row[10].\u00a0\u00bb&lsquo;\u00a0\u00bb),\u00a0\u00bbEcri_Pseudo\u00a0\u00bb);\n\t\t$Nom=explode(&lsquo;@&rsquo;,$nom);\n\t\t$Prenom=explode(&lsquo;@&rsquo;,$prenom);\n\t\t$nb=count($Nom);\n\t\tif($nb==1){\n\t\t\t$pseudo=\u00a0\u00bb<b>\/<\/b> pseudonyme : <b>$prenom $nom<\/b>.\u00a0\u00bb;\n\t\t\t}\n\t\telse{\n\t\t\t$pseudo=\u00a0\u00bb<b>\/<\/b> pseudonymes : <b>\u00ab\u00a0.$Prenom[0].\u00a0\u00bb \u00ab\u00a0.$Nom[0];\n\t\t\n\t\t\tfor($i=1;$i<$nb;$i++){\n\t\t\t\t$pseudo.=\", \".$Prenom[$i].\" \".$Nom[$i];\n\t\t\t\t}\n\t\t\t$pseudo.=\"<\/b>.\u00a0\u00bb;\n\t\t\t}\n\t\t}\n\tif(!$row[6]){\n\t\t$row[6]=\u00a0\u00bb??\u00a0\u00bb;\n\t\t}\n\tif(!$row[7]){\n\t\t$row[7]=\u00a0\u00bb\u00a0\u00bb;\n\t\t}\n\tif($row[3]==0){\n\t\t$row[3]=\u00a0\u00bb??\u00a0\u00bb;\n\t\t}\n\tif($row[4]==0){\n\t\t$row[4]=\u00a0\u00bb\u00a0\u00bb;\n\t\t}\n\tif($row[13]){\n\t\t$row[13].=\u00a0\u00bb\/\u00a0\u00bb;\n\t\t}\n\tif($row[14]){\n\t\t$row[14].=\u00a0\u00bb\/\u00a0\u00bb;\n\t\t}\n\techo \u00ab\u00a0>> <span class=\\\"auteur\\\"> \u00ab\u00a0.$row[2].\u00a0\u00bb \u00ab\u00a0.$row[1].\u00a0\u00bb<\/span><span class=\\\"auteur2\\\"> <b>[<\/b> \u00ab\u00a0.$row[6].\u00a0\u00bb, \u00ab\u00a0.$row[13].\u00a0\u00bb<b>\u00ab\u00a0.$row[3].\u00a0\u00bb<\/b> &#8211; \u00ab\u00a0.$row[7].\u00a0\u00bb, \u00ab\u00a0.$row[14].\u00a0\u00bb\u00a0\u00bb.$row[4].\u00a0\u00bb <b>]<\/b> $pseudo<br>\u00ab\u00a0.$row[5].\u00a0\u00bb<\/span> $form\u00a0\u00bb;\n\t$pseudo=\u00a0\u00bb\u00a0\u00bb;\n\t$form=\u00a0\u00bb\u00a0\u00bb;\n\t}\n}\n\nelse{\n\/\/cas recherche normale\nif($lieu){\n$name=\u00a0\u00bblieu\u00a0\u00bb;\n}\nelseif($oeuvre){\n$name=\u00a0\u00bboeuvre\u00a0\u00bb;\n}\nelse{\n$name=\u00a0\u00bbsearch\u00a0\u00bb;\n}\n\/\/determination de $nbl nb de resultats\n$res = @mysql_query($req);\n$nbl = @mysql_num_rows($res);\n\n\/\/affichage\n$req .= \u00a0\u00bb LIMIT $debut,$limit\u00a0\u00bb;\n$res = @mysql_query($req);\n\nif( $nbl == 0 || !$recherche){\necho \u00ab\u00a0<br><br><br><span class=\\\"petit\\\"><b>Aucun r&eacute;sultat ne correspond &agrave; votre recherche&#8230;<\/b><\/span><br><br><br>\u00ab\u00a0;\n}\nelse{\n$recherche2=$recherche;\n$recherche= str_replace( \u00ab\u00a0&#038;&#038;\u00a0\u00bb , \u00ab\u00a0&lsquo;\u00a0\u00bb,$recherche);\n$recherche=stripslashes($recherche);\necho \u00ab\u00a0<span class=\\\"petit\\\"><b>Les r&eacute;sultats de la recherche pour \\\u00a0\u00bb$recherche\\\u00a0\u00bb sont :<\/b><\/span><br><br>\u00ab\u00a0;\n\/\/gestion du formulaire pour voir les reponses suivantes et precedentes\nif($debut > 0){\n$debut2 =$debut-$limit;\necho\u00a0\u00bb\n<form id=\\\"FormName\\\" action=\\\"auteurs.php\\\" method=\\\"GET\\\" name=\\\"FormName\\\">\n<input type=\\\"hidden\\\" name=\\\"debut\\\" value=\\\"$debut2\\\">\n<input type=\\\"hidden\\\" name=\\\"$name\\\" value=\\\"true\\\">\n<input type=\\\"hidden\\\" name=\\\"recherche\\\" value=\\\"$recherche\\\">\n<input type=\\\"hidden\\\" name=\\\"operateur\\\" value=\\\"$operateur\\\">\n<input type=\\\"submit\\\" name=\\\"autre\\\" value=\\\"Les $limit r&eacute;sultats pr&eacute;c&eacute;dents\\\">\n<\/form>\u00ab\u00a0;\n\t\t\t\t\t}\nif(($nbl-$debut) > $limit){\n$debut2 =$debut+$limit;\necho\u00a0\u00bb\n<form id=\\\"FormName\\\" action=\\\"auteurs.php\\\" method=\\\"GET\\\" name=\\\"FormName\\\">\n<input type=\\\"hidden\\\" name=\\\"debut\\\" value=\\\"$debut2\\\">\n<input type=\\\"hidden\\\" name=\\\"$name\\\" value=\\\"true\\\">\n<input type=\\\"hidden\\\" name=\\\"recherche\\\" value=\\\"$recherche\\\">\n<input type=\\\"hidden\\\" name=\\\"operateur\\\" value=\\\"$operateur\\\">\n<input type=\\\"submit\\\" name=\\\"autre\\\" value=\\\"Les $limit r&eacute;sultats suivants\\\">\n<\/form>\u00ab\u00a0;\n\t\t\t\t\t}\n\/\/fin gestion formulaire\n\n\twhile($row = @mysql_fetch_array($res)){\n\t$row[1]= str_replace( \u00ab\u00a0&#038;&#038;\u00a0\u00bb , \u00ab\u00a0&lsquo;\u00a0\u00bb,$row[1]);\n\t$row[2]= str_replace( \u00ab\u00a0&#038;&#038;\u00a0\u00bb , \u00ab\u00a0&lsquo;\u00a0\u00bb,$row[2]);\n\t$row[4]= str_replace( \u00ab\u00a0&#038;&#038;\u00a0\u00bb , \u00ab\u00a0&lsquo;\u00a0\u00bb,$row[4]);\n\t$row[5]= str_replace( \u00ab\u00a0&#038;&#038;\u00a0\u00bb , \u00ab\u00a0&lsquo;\u00a0\u00bb,$row[5]);\n\t$row[13]= str_replace( \u00ab\u00a0&#038;&#038;\u00a0\u00bb , \u00ab\u00a0&lsquo;\u00a0\u00bb,$row[13]);\n$requete=@mysql_query(\u00ab\u00a0SELECT * FROM Ecri_Oeuvre WHERE Id='\u00a0\u00bb.$row[0].\u00a0\u00bb&lsquo;\u00a0\u00bb);\n$n = @mysql_num_rows($requete);\nif($oeuvre){\n$sql=@mysql_query(\u00ab\u00a0SELECT Titre FROM Ecri_Oeuvre WHERE Titre like &lsquo;%$recherche2%&rsquo; AND Id='\u00a0\u00bb.$row[0].\u00a0\u00bb&lsquo;\u00a0\u00bb);\n$sql_result=@mysql_result($sql,\u00a0\u00bbEcri_Oeuvre\u00a0\u00bb);\n$sql_result= str_replace( \u00ab\u00a0&#038;&#038;\u00a0\u00bb , \u00ab\u00a0&lsquo;\u00a0\u00bb,$sql_result);\n$ajout_oeuvre=\u00a0\u00bb<br><span class=\\\"auteur\\\">a &eacute;crit <b>$sql_result<\/b>.<\/span>\u00ab\u00a0;\n}\n\/\/formulaire bio\nif($row[11]!=0 || $row[12] || $n!=0){\n$form=\u00a0\u00bb<form id=\\\"formname\\\" action=\\\"bio_bibli.php\\\" method=\\\"GET\\\" name=\\\"formname\\\">\u00ab\u00a0;\nif($row[11]!=0){\n$form.=\u00a0\u00bb<input type=\\\"submit\\\" name=\\\"bio$name\\\" value=\\\"Bio\\\">\u00ab\u00a0;\n}\n\/\/formulaire bibli\nif($row[12] || $n!=0){\n$form.=\u00a0\u00bb<input type=\\\"submit\\\" name=\\\"bibli$name\\\" value=\\\"Biblio\\\">\u00ab\u00a0;\n}\n$form.=\u00a0\u00bb<input type=\\\"hidden\\\" name=\\\"id_bio\\\" value=\\\"\".$row[11].\"\\\" ><input type=\\\"hidden\\\" name=\\\"id\\\" value=\\\"\".$row[0].\"\\\" ><input type=\\\"hidden\\\" name=\\\"recherche\\\" value=\\\"$recherche\\\" ><input type=\\\"hidden\\\" name=\\\"operateur\\\" value=\\\"$operateur\\\" ><input type=\\\"hidden\\\" name=\\\"Id_Pseudo\\\" value=\\\"\".$row[10].\"\\\" ><\/form>\u00ab\u00a0;\n$form.=\u00a0\u00bb<br><br>\u00ab\u00a0;\n}\nelse{\n$form=\u00a0\u00bb<br><br>\u00ab\u00a0;\n}\nif($row[10]!=0){\n$nom=mysql_result(mysql_query(\u00ab\u00a0SELECT Pseudo_Nom FROM Ecri_Pseudo WHERE Id_Pseudo='\u00a0\u00bb.$row[10].\u00a0\u00bb&lsquo;\u00a0\u00bb),\u00a0\u00bbEcri_Pseudo\u00a0\u00bb);\n$prenom=mysql_result(mysql_query(\u00ab\u00a0SELECT Pseudo_Prenom FROM Ecri_Pseudo WHERE Id_Pseudo='\u00a0\u00bb.$row[10].\u00a0\u00bb&lsquo;\u00a0\u00bb),\u00a0\u00bbEcri_Pseudo\u00a0\u00bb);\n$Nom=explode(&lsquo;@&rsquo;,$nom);\n$Prenom=explode(&lsquo;@&rsquo;,$prenom);\n$nb=count($Nom);\nif($nb==1){\n$pseudo=\u00a0\u00bb<b>\/<\/b> pseudonyme : <b>$prenom $nom<\/b>.\u00a0\u00bb;\n}\nelse{\n$pseudo=\u00a0\u00bb<b>\/<\/b> pseudonymes : <b>\u00ab\u00a0.$Prenom[0].\u00a0\u00bb \u00ab\u00a0.$Nom[0];\nfor($i=1;$i<$nb;$i++){\n$pseudo.=\", \".$Prenom[$i].\" \".$Nom[$i];\n}\n$pseudo.=\"<\/b>.\u00a0\u00bb;\n}\n}\nif(!$row[4]){\n$row[4]=\u00a0\u00bb??\u00a0\u00bb;\n}\nif(!$row[5]){\n$row[5]=\u00a0\u00bb\u00a0\u00bb;\n}\nif($row[8]==0){\n$row[8]=\u00a0\u00bb??\u00a0\u00bb;\n}\nif($row[9]==0){\n$row[9]=\u00a0\u00bb\u00a0\u00bb;\n}\nif($row[6]){\n$row[6].=\u00a0\u00bb\/\u00a0\u00bb;\n}\nif($row[7]){\n$row[7].=\u00a0\u00bb\/\u00a0\u00bb;\n}\necho \u00ab\u00a0>> <span class=\\\"auteur\\\"> \u00ab\u00a0.$row[$cas].\u00a0\u00bb \u00ab\u00a0.$row[$cas2].\u00a0\u00bb<\/span><span class=\\\"auteur2\\\"> <b>[<\/b> \u00ab\u00a0.$row[4].\u00a0\u00bb, \u00ab\u00a0.$row[6].\u00a0\u00bb\u00a0\u00bb.$row[8].\u00a0\u00bb &#8211; \u00ab\u00a0.$row[5].\u00a0\u00bb, \u00ab\u00a0.$row[7].\u00a0\u00bb\u00a0\u00bb.$row[9]. \u00a0\u00bb <b>]<\/b> $pseudo<br>\u00ab\u00a0.$row[13].\u00a0\u00bb<\/span>\u00ab\u00a0.$ajout_oeuvre.\u00a0\u00bb$form\u00a0\u00bb;\n$pseudo=\u00a0\u00bb\u00a0\u00bb;\n$form=\u00a0\u00bb\u00a0\u00bb;\n}\n}\n@mysql_free_result($res);\n}\n}\n\t\t\t\t?>\n          <\/td>\n        <\/tr>\n      <\/table>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rechercher un Auteur Nouvelle recherche<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/pages\/617"}],"collection":[{"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/comments?post=617"}],"version-history":[{"count":3,"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/pages\/617\/revisions"}],"predecessor-version":[{"id":620,"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/pages\/617\/revisions\/620"}],"wp:attachment":[{"href":"https:\/\/bernard-visse.fr\/ev\/wp-json\/wp\/v2\/media?parent=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}