{"id":948,"date":"1999-01-01T18:10:35","date_gmt":"1999-01-01T18:10:35","guid":{"rendered":"http:\/\/shrule.com\/?page_id=948"},"modified":"2018-10-05T12:35:06","modified_gmt":"2018-10-05T12:35:06","slug":"ancestor-search-national-school-registers","status":"publish","type":"page","link":"http:\/\/www.shrule.com\/?page_id=948","title":{"rendered":"Ancestor Search :: National School Registers"},"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>National School Registers<\/h2>\n<p><?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 == '%'  ){ $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   }\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\t}\nif( $f_pn ==  'ALL' ){ $pn = 'ALL' ; }  \/\/ parish\n\n\nif( $submit == \"Search\")            \/\/----------- search\n  {  \n   $query = $wpdb->prepare(&#8216;select * from _grc_nschools<br \/>\n                             WHERE SOUNDEX(surname) like SOUNDEX(%s)&#8217;,$f_sn ) ;<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 )   \/\/ check if there are any results<br \/>\n          {  printf(&#8220;View the %s entries from the National School Registers<br \/>&#8220;, $norows); }<br \/>\n        printf(&#8220;<\/p>\n<ul>&#8220;);<br \/>\n        \/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n        foreach ( $res as $row )<br \/>\n           { printf(&#8220;<\/p>\n<li>&#8220;);<br \/>\n             if( $row[9] > 1931 )<br \/>\n               {<br \/>\n                printf(&#8220;$row[6] $row[5] from $row[7] was enrolled in $row[1] NS however &#8220;);<br \/>\n                printf(&#8220;records after 1931 are restricted but may be &#8220;);<br \/>\n                printf(&#8220;viewed on appointment with the school .&#8221;);<br \/>\n                }<br \/>\n               else<br \/>\n                {<br \/>\n                 printf(&#8220;<b>$row[6] $row[5]<\/b><br \/>&#8220;);<br \/>\n                 printf(&#8220;$row[6] $row[5] from $row[7] was enrolled in $row[1] NS from $row[9] &#8220;);<br \/>\n                 if($row[10] <> &#8216;0&#8217;){ printf(&#8221; to $row[10] .&#8221;); }<br \/>\n                   else{ printf(&#8221; .&#8221;); }<br \/>\n                 if($row[3] == &#8216;F&#8217;){ printf(&#8220;Her&#8221;); }<br \/>\n                   elseif($row[3] == &#8216;M&#8217;){ printf(&#8220;His&#8221;); }<br \/>\n                     else{ printf(&#8220;Their&#8221;); }<br \/>\n                 printf(&#8221; parent&#8217;s occupation is &#8220;);<br \/>\n                 if( $row[8] <> &#8221; ) { printf(&#8221; given as $row[8] .&#8221;); }<br \/>\n                    else{ printf(&#8221; not stated .&#8221;); }<br \/>\n                 if($row[13] <> &#8221;) { printf(&#8220;<br \/>This comment appears in the roll book :: <i>$row[13]<\/i> .&#8221;);}<br \/>\n                 if( $row[11] <> &#8221;)<br \/>\n                    {<br \/>\n                     if( $row[11] == 0 )<br \/>\n                        { printf(&#8220;<br \/>Their date of birth is not given.&#8221;); }<br \/>\n                        else { printf(&#8220;<br \/>Their date of birth is given as $row[11]&#8221;); }<br \/>\n                     }<br \/>\n                 }<br \/>\n                printf(&#8220;<\/li>\n<hr \/>\n<p>&#8220;);<br \/>\n               }<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nprintf(&#8220;<\/ul>\n<p>&#8220;);<br \/>\n     }<br \/>\n      else<br \/>\n         {<br \/>\n          Printf(&#8220;Sorry no entries match your query in the National School registery records.<br \/>&#8220;);<br \/>\n           }<br \/>\n     }   \/\/&#8212;&#8212;&#8212;&#8211; search end   &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/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;<\/p>\n<p>printf(&#8220;<\/li>\n<p>End of records for this search<br \/>\n<br \/>Search the National School Registers 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 National School Registers<\/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    ELSE{ PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"cn\\\" VALUE=\\\"Any\\\" \/>&#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=\\\"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\t     {  $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 \/>\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>National School Registers<\/h2>\n<p>The children recorded as having attended National School are available for Clydagh NS and for Kilroe NS.<\/p>\n<p><a rel=\"attachment wp-att-1424\" href=\"http:\/\/shrule.com\/?attachment_id=1424\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-1424\" style=\"margin: 5px;\" title=\"Kilroe N.S.\" src=\"http:\/\/shrule.com\/wp-content\/uploads\/1999\/01\/kilroe-150x99.jpg\" alt=\"\" width=\"120\" height=\"79\" srcset=\"http:\/\/www.shrule.com\/wp-content\/uploads\/1999\/01\/kilroe-150x99.jpg 150w, http:\/\/www.shrule.com\/wp-content\/uploads\/1999\/01\/kilroe.jpg 275w\" sizes=\"auto, (max-width: 120px) 100vw, 120px\" \/><\/a>The Kilroe records give an approximate year of enrollment and they do not have the parents occupation listed in the database but the address is given . However if you find an entry you are interested in you may contact Kilroe National School details are available on their website <a href=\"http:\/\/shrule.com\" target=\"_blank\">http:\/\/shrule.com\/kilroens<\/a><br \/>\n.<\/p>\n<p><a rel=\"attachment wp-att-1425\" href=\"http:\/\/shrule.com\/?attachment_id=1425\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-thumbnail wp-image-1425\" style=\"margin: 5px;\" title=\"Clydagh NS\" src=\"http:\/\/shrule.com\/wp-content\/uploads\/1999\/01\/clydagh-120x150.png\" alt=\"\" width=\"120\" height=\"150\" srcset=\"http:\/\/www.shrule.com\/wp-content\/uploads\/1999\/01\/clydagh-120x150.png 120w, http:\/\/www.shrule.com\/wp-content\/uploads\/1999\/01\/clydagh.png 180w\" sizes=\"auto, (max-width: 120px) 100vw, 120px\" \/><\/a>The Clydagh NS records have pupils starting year , ending year and highest class achieved recorded for each pupil. The register also records the parents occupation and address. Comments often indicate a previous school attended .You may contact this school with queries also or visit  their website at <a href=\"http:\/\/www.clydagh.com\" target=\"_blank\">http:\/\/www.clydagh.com<\/a><\/p>\n<p>National School records stored in the database are all pre 1980 for security\/data protection reasons , nobody would want the list of currently attending children listed online . Records from about 1920 to 1980 are stored in the database but will not be displayed other than to indicate whether a record exists or not. If you want details about an entry between 1920 and 1980 you will have to contact the relevant school.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>National School Registers National School Registers The children recorded as having attended National School are available for Clydagh NS and for Kilroe NS. The Kilroe records give an approximate year of enrollment and they do not have the parents occupation listed in the database but the address is given . However if you find an [&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-948","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/948","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=948"}],"version-history":[{"count":0,"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/948\/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=948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}