{"id":4049,"date":"2011-11-14T22:14:25","date_gmt":"2011-11-15T03:14:25","guid":{"rendered":"http:\/\/www.nysgis.com\/?page_id=4049"},"modified":"2018-01-13T21:17:34","modified_gmt":"2018-01-14T02:17:34","slug":"memberlist","status":"publish","type":"page","link":"https:\/\/www.nysgis.net\/joinus\/memberlist","title":{"rendered":"Ever-Been-A-Member List"},"content":{"rendered":"<style type=\"text\/css\">\ninput\n{\nwidth:250px;\nheight:25px; \n}\nselect\n{\nwidth:250px;\nheight:25px; \n}\n.button {\n   border-top: 1px solid #96d1f8;\n   background: #65a9d7;\n   background: -webkit-gradient(linear, left top, left bottom, from(#3e779d), to(#65a9d7));\n   background: -webkit-linear-gradient(top, #3e779d, #65a9d7);\n   background: -moz-linear-gradient(top, #3e779d, #65a9d7);\n   background: -ms-linear-gradient(top, #3e779d, #65a9d7);\n   background: -o-linear-gradient(top, #3e779d, #65a9d7);\n   padding: 5px 10px;\n   -webkit-border-radius: 8px;\n   -moz-border-radius: 8px;\n   border-radius: 8px;\n   -webkit-box-shadow: rgba(0,0,0,1) 0 1px 0;\n   -moz-box-shadow: rgba(0,0,0,1) 0 1px 0;\n   box-shadow: rgba(0,0,0,1) 0 1px 0;\n   text-shadow: rgba(0,0,0,.4) 0 1px 0;\n   color: white;\n   font-size: 14px;\n   font-family: Georgia, serif;\n   text-decoration: none;\n   vertical-align: middle;\n   }\n.button:hover {\n   border-top-color: #28597a;\n   background: #28597a;\n   color: #ccc;\n   }\n.button:active {\n   border-top-color: #1b435e;\n   background: #1b435e;\n   }\n<\/style>\n[insert_php]\n$databaseURL =&#8221;localhost&#8221;;<br \/>\n$databaseUName = &#8220;nysgisne_admin&#8221;;<br \/>\n$databasePWord = &#8220;Admin123&#8221;;<br \/>\n$databaseName = &#8220;nysgisne_nyg1s&#8221;;<br \/>\ntry<br \/>\n{<br \/>\n $connection = mysqli_connect($databaseURL,$databaseUName,$databasePWord, $databaseName) or die (&#8220;Error connecting to localhost&#8221;);<br \/>\n}<br \/>\ncatch(Exception $e)<br \/>\n{<br \/>\n echo &#8216;Error message&#8217; ,$e->getMessage(),&#8221;n&#8221;;<br \/>\n}<\/p>\n<p>echo &#8220;<\/p>\n<div>&#8220;;<br \/>\necho&#8221;<br \/><a class='button' href='http:\/\/www.nysgis.net\/joinus\/join' title='Return to Join Page' >Return to Join Page<\/a>&#8220;;<\/p>\n<p>echo &#8220;<\/p>\n<table style='font-family: Calibri; font-size: 16px;' width = 90%  frame='HSIDES' rules='ROWS' cellspacing='1' cellpadding='3' BORDERCOLOR='#D8D8D8'>&#8220;;<\/p>\n<p>                                echo &#8220;<\/p>\n<tr align='left' >&#8220;;<br \/>\n                                echo &#8220;<\/p>\n<th><strong>Last Name<\/strong><\/th>\n<p>&#8220;;<br \/>\n                                echo &#8220;<\/p>\n<th><strong>First Name<\/strong><\/th>\n<p>&#8220;;<br \/>\n                                echo &#8220;<\/p>\n<th><strong>Organization<\/strong><\/th>\n<p>&#8220;;<br \/>\n                                echo &#8220;<\/tr>\n<p>&#8220;;<\/p>\n<p>                                    $result = mysqli_query($connection, &#8220;Select * from Member Order by LastName&#8221;);<\/p>\n<p>                                     while($row = mysqli_fetch_array($result))<br \/>\n                                      {<br \/>\n                                        if($row[&#8216;GISP&#8217;] == 1)<br \/>\n                                         {<br \/>\n                                         echo &#8220;<\/p>\n<tr>&#8220;;<br \/>\n                                         echo &#8220;<\/p>\n<td><b>&#8220;.$row[&#8216;LastName&#8217;].&#8221;<\/b><\/td>\n<p>&#8220;;<br \/>\n                                         echo &#8220;<\/p>\n<td><b>&#8220;.$row[&#8216;FirstName&#8217;].&#8221;<\/b><\/td>\n<p>&#8220;;<br \/>\n                                         echo &#8220;<\/p>\n<td><b>&#8220;.$row[&#8216;Organization&#8217;].&#8221;<\/b><\/td>\n<p>&#8220;;<br \/>\n                                         echo &#8220;<\/tr>\n<p>&#8220;;<br \/>\n                                        }<br \/>\n                                        else<br \/>\n                                        {<br \/>\n                                         echo &#8220;<\/p>\n<tr>&#8220;;<br \/>\n                                         echo &#8220;<\/p>\n<td>&#8220;.$row[&#8216;LastName&#8217;].&#8221;<\/td>\n<p>&#8220;;<br \/>\n                                         echo &#8220;<\/p>\n<td>&#8220;.$row[&#8216;FirstName&#8217;].&#8221;<\/td>\n<p>&#8220;;<br \/>\n                                         echo &#8220;<\/p>\n<td>&#8220;.$row[&#8216;Organization&#8217;].&#8221;<\/td>\n<p>&#8220;;<br \/>\n                                         echo &#8220;<\/tr>\n<p>&#8220;;<br \/>\n                                        }<br \/>\n                                    }<br \/>\n                                      echo &#8220;<\/table>\n<p>&#8220;;<br \/>\n                                      echo &#8220;<\/p><\/div>\n<p>&#8220;;<br \/>\n                                [\/insert_php]\n","protected":false},"excerpt":{"rendered":"<p>[insert_php] $databaseURL =&#8221;localhost&#8221;; $databaseUName = &#8220;nysgisne_admin&#8221;; $databasePWord = &#8220;Admin123&#8221;; $databaseName = &#8220;nysgisne_nyg1s&#8221;; try { $connection = mysqli_connect($databaseURL,$databaseUName,$databasePWord, $databaseName) or die (&#8220;Error connecting to localhost&#8221;); } catch(Exception $e) { echo &#8216;Error message&#8217; ,$e->getMessage(),&#8221;n&#8221;; } echo &#8220; &#8220;; echo&#8221;Return to Join Page&#8220;; echo &#8220; &#8220;; echo &#8220; &#8220;; echo &#8220; Last Name &#8220;; echo &#8220; First Name [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":4,"comment_status":"closed","ping_status":"open","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-4049","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/pages\/4049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/comments?post=4049"}],"version-history":[{"count":6,"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/pages\/4049\/revisions"}],"predecessor-version":[{"id":6798,"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/pages\/4049\/revisions\/6798"}],"wp:attachment":[{"href":"https:\/\/www.nysgis.net\/joinus\/wp-json\/wp\/v2\/media?parent=4049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}