{"id":950,"date":"1999-01-01T18:11:24","date_gmt":"1999-01-01T18:11:24","guid":{"rendered":"http:\/\/shrule.com\/?page_id=950"},"modified":"2018-10-05T12:34:18","modified_gmt":"2018-10-05T12:34:18","slug":"ancestor-search-marriage","status":"publish","type":"page","link":"http:\/\/www.shrule.com\/?page_id=950","title":{"rendered":"Ancestor search :: Marriage"},"content":{"rendered":"<p><img decoding=\"async\" src=\"http:\/\/www.shrule.com\/wp-content\/uploads\/2012\/02\/genealogy.png\" alt=\"Genealogy :: the  search for you ancestors\" title=\"Genealogy :: the  search for you ancestors\" width=\"600\" align=\"center\" \/><\/p>\n<p><h2>Marriage records<\/h2>\n<li>\n<?php\nglobal $wpdb;\n\/\/------------------------------------------------------------\n$pid  =  $_REQUEST['page_id'];  \/\/ current page id in wordpress\n\nif(isset($_REQUEST['submit'])) {  $submit   = $_REQUEST['submit'] ; }\nif(isset($_REQUEST['cn'])) {  $cn= $_REQUEST['cn'] ; }\nif(isset($_REQUEST['sn'])) {  $sn= $_REQUEST['sn'] ;  }\nif(isset($_REQUEST['cp'])) {  $cp= $_REQUEST['cp'] ;  }\n\nswitch($cn)\n   {  case ''    :  $f_cn = '%' ;      break;\n      case '*'   :  $f_cn = '%' ;      break;\n      case 'Any' :  $f_cn = '%' ;      break;\n      default    :  $f_cn = $cn ;\n    }\nif( $f_cn == '%' )\n   { $cn = 'Any' ; }  \/\/ firstname\n\nswitch($sn)\n   {  case ''  :  $f_sn = 'xxxxxxxx' ;      break;\n      case '*' :  $f_sn = 'xxxxxxxx' ;       break;\n      case '%' :  $f_sn = 'xxxxxxxx' ;      break;\n      default  :  $f_sn = $sn ;           \n\t}\nif( $f_sn == 'xxxxxxxx' ){ $sn = '' ; }  \/\/ surname\n\nswitch($cp)\n   {  case ''  :  $f_cp = 'ALL' ;   break;\n      case '*' :  $f_cp = 'ALL' ;   break;\n      case '%' :  $f_cp = 'ALL' ;   break;\n      default  :  $f_cp = $cp ;  \n    }\nif( $f_pn ==  'ALL' )\n   { $pn = 'ALL' ; }  \/\/ parish\n\n\nif( $submit == \"Search\")\n  {   \/\/----------- search marriage records ---------------------------\n    if( $f_cn == '%')\n       {  $query = $wpdb->prepare(&#8216; select * from _grc_marriage<br \/>\n                 WHERE Soundex(bride_s) like soundex(%s)<br \/>\n                   OR soundex(groom_s) like soundex(%s)<br \/>\n                   ORDER by townland &#8216; , $f_sn , $f_sn );<br \/>\n\t\t }<br \/>\n       else{<br \/>\n\t        $fcn = &#8216;%$f_cn%&#8217; ;<br \/>\n\t        $query = $wpdb->prepare(&#8216; select * from _grc_marriage<br \/>\n                 WHERE ( Soundex(bride_s) like soundex(%s)<br \/>\n                         AND bride_f like (%s))<br \/>\n                   OR ( Soundex(groom_s) like soundex(%s)<br \/>\n                         AND (groom_f) like (%s))<br \/>\n                 ORDER by townland &#8216;,$f_sn , $fcn , $f_sn , $fcn)  ;<br \/>\n\t\t    }<br \/>\n     $res = $wpdb->get_results($query , ARRAY_N);<\/p>\n<p>     if($res ) \/\/ is there a good result<br \/>\n       {    $norows = $wpdb->num_rows ;<br \/>\n  \t     if( $norows > 0 )<br \/>\n               {<br \/>\n                printf(&#8220;View the %s entries from the Marriage registers<\/p>\n<hr \/>\n<ul>\n<li>&#8220;, $norows);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nforeach ( $res as $row )<br \/>\n                {<br \/>\n                  if( $row[6] == &#8216;Marriage&#8217;)<br \/>\n                    { printf(&#8220;<b>$row[9] and $row[11] marriage<\/b><br \/>&#8220;);<br \/>\n                      printf(&#8220;$row[8] $row[9] married $row[10] $row[11]&#8221;);<br \/>\n                      if( $row[7] <> &#8221; )<br \/>\n                        {printf(&#8221; , $row[7]&#8221;);}<br \/>\n                      printf(&#8221; on $row[3] $row[4] $row[5] . &#8220;);<br \/>\n                      if( $row[12] <> &#8221; )<br \/>\n                         {printf(&#8220;Witnesses were $row[12]&#8221;);}<br \/>\n                     }<br \/>\n                    else<br \/>\n                      { printf(&#8220;<b>$row[9] , $row[6]<\/b><br \/>&#8220;);<br \/>\n                        printf(&#8220;$row[6] to  $row[8] $row[9]&#8221;);<br \/>\n                        if( $row[7] <> &#8221; )<br \/>\n                          {printf(&#8221; , $row[7] &#8220;);}<br \/>\n                        printf(&#8221; on $row[3] $row[4] $row[5] . &#8220;);<br \/>\n                      }<br \/>\n                 printf(&#8220;<\/p>\n<hr \/>\n<p>&#8220;);<br \/>\n                } <\/p>\n<p>\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n                }<br \/>\n           else<br \/>\n              { Printf(&#8220;Sorry no entries match your query in the Marriage records.<\/p>\n<ul>\n<li>&#8220;);   }<br \/>\n     }   \/\/&#8212;&#8212;&#8212;&#8211; search end   &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n   }<\/p>\n<p>\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nprintf(&#8220;<\/li>\n<p>End of Marriage records for this search<br \/>\n<br \/>Search the Marriage records for other people &#8230;.<\/p>\n<hr \/>\n<li>&#8220;);\n<p>PRINTF(&#8220;<\/p>\n<div class=\\\"formshrule\\\">&#8220;);<br \/>\nPRINTF(&#8220;<\/p>\n<form METHOD=\\\"POST\\\" ACTION=\\\"?page_id=$pid\\\">&#8220;);<\/p>\n<p>if(isset($_REQUEST[&#8216;submit&#8217;]))<br \/>\n    {    $submit   = $_REQUEST[&#8216;submit&#8217;] ;   }<\/p>\n<p>PRINTF(&#8220;<\/p>\n<fieldset>\n<legend>Search the Marriage records<\/legend>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nPRINTF(&#8220;<\/p>\n<table>&#8220;);<br \/>\nPRINTF(&#8220;<\/p>\n<tr>\n<td><label for=\\\"firstname\\\">First name ::<\/label><\/td>\n<td>&#8220;);<br \/>\nif(isset($_REQUEST[&#8216;cn&#8217;]))<br \/>\n      {    PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"cn\\\" VALUE=\\\"$cn\\\" \/>&#8220;);<br \/>\n\t    }<br \/>\n  ELSE{    PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"cn\\\" VALUE=\\\"Any\\\" \/>&#8220;);<br \/>\n     \t}<br \/>\nPRINTF(&#8220;<\/td>\n<\/tr>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>PRINTF(&#8220;<\/p>\n<tr>\n<td><label for=\\\"surname\\\">Surname or last name ::<\/label><\/td>\n<td>&#8220;);<br \/>\nif(isset($_REQUEST[&#8216;sn&#8217;]))<br \/>\n      {  $sn=$_REQUEST[&#8216;sn&#8217;] ;<br \/>\n         PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"sn\\\" VALUE=\\\"$sn\\\" \/>&#8220;);    }<br \/>\n   ELSE{ PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"sn\\\" \/>&#8220;);            }<br \/>\nPRINTF(&#8220;<\/td>\n<\/tr>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>printf(&#8220;<\/p>\n<tr>\n<td><label for=\\\"parish\\\">Select the Parish ::<\/label><\/td>\n<td>&#8220;);<\/p>\n<p>$query = $wpdb->prepare(&#8216;select civilparish,cpid FROM _grp_civilparish group by cpid&#8217;,1);<br \/>\n \/\/ count records in each table<br \/>\n$combo = $wpdb->get_results($query , ARRAY_N);<br \/>\nprintf(&#8220;<select NAME=\\\"cp\\\" CLASS=\\\"input_field\\\" \/>&#8220;);<br \/>\nif(isset($_REQUEST[&#8216;cp&#8217;]))<br \/>\n         {    $cp= $_REQUEST[&#8216;cp&#8217;] ;<br \/>\n               if($cp <> &#8216;ALL&#8217;){ printf(&#8220;<option VALUE=\\\"ALL\\\">All parishes<\/option>&#8220;); }<br \/>\n                 else{ printf(&#8220;<option VALUE=\\\"ALL\\\" SELECTED>All parishes<\/option>&#8220;); }          }<br \/>\n    else{printf(&#8220;<option VALUE=\\\"ALL\\\" SELECTED>All parishes<\/option>&#8220;);}<\/p>\n<p>foreach ( $combo as $row )<br \/>\n        {  $cp_code = substr($row[1],0,6) ;<br \/>\n           if($cp == $cp_code)<br \/>\n               {        PRINTF(&#8220;<option VALUE=\\\"$cp_code\\\" SELECTED>$row[0]<\/option>&#8220;);    }<br \/>\n               else{ PRINTF(&#8221;<option VALUE=\\\"$cp_code\\\">$row[0]<\/option>&#8220;);   }<br \/>\n\t\t }<br \/>\nprintf(&#8220;<\/select><\/td>\n<\/tr>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>?><\/p>\n<tr>\n<td><input type=\"reset\" VALUE=\"Clear form\"\/><\/td>\n<td><input TYPE=\"submit\" NAME=\"submit\" VALUE=\"Search\"><\/td>\n<\/tr>\n<\/table>\n<\/fieldset>\n<\/form>\n<\/div>\n<\/li>\n<\/ul>\n<p><\/p>\n<h2>Marriage registers<\/h2>\n<p>St.Joseph&#8217;s R.C. church , Shrule<br \/>\nShrule parish church (St.Joseph&#8217;s) records begin in 1831 and thanks to Fr. Michael Crosby they are now all computerised .The 19th century records are available on this website in a searchable format. The parish records from 1831 to the end of 1864 are recorded in a ledger which is essentially an accounts sysem for the parish as baptisms , marriages and certificates issued were subject to a fee. Some years (1847..1854) have no records at all , most likely due to the famine . People were too destitute to be in a position to pay for church services .<\/p>\n<p>Shrule is incredibly lucky to have parish records of Marriages , Baptisms and other church related miscellania going back to the parish Church&#8217;s foundation in 1831 and doubly blessed to have a Parish Priest who is doing so much to preserve and make the heritage of the place available for future generations.<\/p>\n<p>The church was built in the early 19th century , probably the 1820&#8217;s . There were 300 children confirmed there in September 1830 so it was built before this date ! The church was built due to Mrs Mary Kirwan of Dalgan Park who also furnished it except for the altar . Mary was Edmund Burkes daughter who married Patrick Kirwan Esq a protestant . Their daughter Julia married Thomas Barnwell Martin who owned a carpentry business in Shrule and who donated the altar for Shrule church. Mrs Kirwan died on 31 Dec 1836 and was laid in state in her church (and then buried in Shrule cemetary ).<br \/>\nA mention from Lewis&#8217; Topographical Dictionary in 1837 reads :<br \/>\nIn the R. C. divisions the parish is in the diocese of Galway, and is co-extensive with that of the Established Church : the chapel is a neat edifice in the ancient English style, with a square tower, towards the erection of which \u00a31300. was contributed by Mr. Kirwan, of Dalgan Park, who also gave the ground.: it has a handsome marble altar-piece, presented by T. Martin, Esq.\n <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Marriage records Marriage registers St.Joseph&#8217;s R.C. church , Shrule Shrule parish church (St.Joseph&#8217;s) records begin in 1831 and thanks to Fr. Michael Crosby they are now all computerised .The 19th century records are available on this website in a searchable format. The parish records from 1831 to the end of 1864 are recorded in a [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":0,"parent":338,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-950","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shrule.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=950"}],"version-history":[{"count":0,"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/950\/revisions"}],"up":[{"embeddable":true,"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/338"}],"wp:attachment":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}