La liste des registres d’ExpoActes<\/a><\/p>\n\n\n\nLe fichier redir-registre.php est sp\u00e9cifique a notre association et a la visualisation des actes aux Archives D\u00e9partementales de l’Ard\u00e8che. Lien a adapter.<\/p>\n\n\n\n
<?php\n\n\/\/ vos inclusions n\u00e9cessaire\nrequire('....');\n\necho \"<div>\";\n\n\n$reg=(isset($_GET['reg']))?$_GET['reg']:\"\";\n\n\necho '<div class=\"frame2\" style=\"margin-left:260px;vertical-align: top;\">';\n\n$saga=OuvrirBase();\n\n$registre=( isset($_GET['registre'] )) ? htmlentities($_GET['registre']): \"\";\n\n\n$where=($reg)? \" and ( commune like '%\".$reg.\"%' or nom like '%\".$reg.\"%' or pre like '%\".$reg.\"%' or c_nom like '%\".$reg.\"%' \nor c_pre like '%\".$reg.\"%' or libelle like '%\".$reg.\"%' or ladate like '%\".$reg.\"%' ) \" :\"\";\n\n\n\/\/echo \"Registre : $registre<br>\";\n\n\nif ( $registre ) {\n\n$registre=str_replace(\"'\",\"\",$registre);\n\n $rindex_registre=\"select count(*) from act_div3 where cote ='$registre' \".$where;\n\/\/ echo $rindex_registre;\n $result=mysqli_query($saga,$rindex_registre);\n $rt=mysqli_fetch_row($result);\n $total = $rt[0];\n $nb_total=$total;\n\n\nif(isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on')\n {\n $protocol = \"https:\/\/\";\n }else{\n $protocol = \"http:\/\/\"; \n } \n\n\n echo '<table width=\"90%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#cccccc\">\n <tr><td bgcolor=\"#cccccc\" align=\"center\">Index du Registre <b>'.$registre.'<\/b> '.$total.' actes\n <form action=\"'.$protocol.$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF'].'\" method=GET>\n <input type=hidden name=registre value=\"'.$registre.'\"> \n <input type=text name=reg size=10>\n <input type=submit value=\"Ok\">\n <\/form> \n <\/td><\/tr>\n <tr><\/tr><tr><td bgcolor=\"#f0f0f0\" align=\"center\" valign=\"top\">\n <table width=\"100%\">\n <tr>\n <th style=\"text-align: center;width:20%;\">Commune<\/th>\n <th style=\"text-align: center;width:15%;\">Nom<\/th>\n <th style=\"text-align: center;width:15%;\">Pr\u00e9nom<\/th>\n <th style=\"text-align: center;width:15%;\">Nom<\/th>\n <th style=\"text-align: center;width:15%;\">Pr\u00e9nom<\/th>\n <th style=\"text-align: center;width:15%;\">Date<\/th>\n <th style=\"text-align: center;width:15%;\">Acte<\/th>\n <th style=\"text-align: center;width:10%;\">Photo<\/th>\n <\/tr>';\nif ($nb_total == 0) {\n echo 'Aucune r\u00e9ponse trouv\u00e9e !! ';\n exit();\n}\nelse {\n$debut=( isset($_GET['debut'])) ? $_GET['debut']: 0;\n$sdebut= (isset($_GET['sdebut'])) ? $_GET['sdebut'] : 0;\n\n$nb_affichage_par_page = 59;\nif ( $sdebut > 0 ) $debut=($sdebut-1)*$nb_affichage_par_page;\nif ( $debut > ( $nb_total - $nb_affichage_par_page )) $debut=$nb_total - $nb_affichage_par_page;\nif ( $debut < $nb_affichage_par_page ) $debut=0;\n\nif ( $where ) $debut=0;\n\n\n$selectL=\"select commune,nom,pre,c_nom, c_pre,libelle,photos,date_format(ladate,'%e-%m-%Y') as ldate,ladate\n from act_div3 where cote='$registre' \".$where.\"\n order by cast(photos as int),ldate limit \". $debut.\",\".$nb_affichage_par_page.\" \";\n\n$resultsel=mysqli_query($saga,$selectL);\nwhile($l=mysqli_fetch_array($resultsel)){\n echo '<tr class=\"tr\">';\n echo '<td style=\"text-align: center;width:20%;\">'.$l['commune'].'<\/td>';\n echo '<td style=\"text-align: center;width:15%;\">'.$l['nom'].'<\/td>';\n echo '<td style=\"text-align: center;width:15%;\">'.$l['pre'].'<\/td>';\n echo '<td style=\"text-align: center;width:15%;\">'.$l['c_nom'].'<\/td>';\n echo '<td style=\"text-align: center;width:15%;\">'.$l['c_pre'].'<\/td>';\n echo '<td style=\"text-align: center;width:15%;\">'.$l['ldate'].'<\/td>';\n echo '<td style=\"text-align: center;width:15%;\">'.$l['libelle'].'<\/td>';\n echo '<td style=\"text-align: center;width:10%;\">\n <a href=\/actes_saga\/redir-registre.php?args='.urlencode($registre).','.$l['commune'].','.$l['ladate'].','.$l['libelle'].' target=\"_blank\" \n title=\"Acc\u00e9dez directement aux Archives de l\\'Ard\u00e8che\" >'.$l['photos'].'<\/a><\/td>';\n\n}\necho '<tr><td colspan=\"5\" align=\"center\">';\necho '<BR \/>';\necho barre_navigation($nb_total, $nb_affichage_par_page, $debut, 10);\necho \"<br>N\u00b0 page:<form action='http:\/\/\".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF'].\"' method=GET>\n<input type=hidden name=registre value='\".$registre.\"'>\n<input type=texte name=sdebut size=2>\n<input type=submit value='Ok'>\n<\/form>\";\n\necho '<\/td><\/tr>';\n}\nmysqli_free_result($resultsel);\nFermerBase($saga);\necho '<\/table><\/table>';\necho '<\/div>';\n\n}\n\n\n\n?>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Liste l’index d’un registre d’ExpoActes pass\u00e9 en param\u00e8tre, tri\u00e9 par num\u00e9ro de page\/photo. Certaines fonctions sont a adapt\u00e9es en fonction de votre environnement. Faut surement ajouter des fichiers a inclure pour que cela fonctionne. Pour OuvrirBase, FermeBase et barre_navigation voir La liste des registres d’ExpoActes Le fichier redir-registre.php est sp\u00e9cifique a notre association et a … <\/p>\n
Continuer la lecture de « Index d’un registre de ExpoActes »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-491","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/491"}],"collection":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=491"}],"version-history":[{"count":5,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/491\/revisions"}],"predecessor-version":[{"id":496,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/491\/revisions\/496"}],"wp:attachment":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}