converting CRLF to LF
[geo.git] / edit_wp5_web_folder / geo / queries / polygon_query_sld_adaptat.php
diff --git a/edit_wp5_web_folder/geo/queries/polygon_query_sld_adaptat.php b/edit_wp5_web_folder/geo/queries/polygon_query_sld_adaptat.php
deleted file mode 100644 (file)
index 668869f..0000000
+++ /dev/null
@@ -1,74 +0,0 @@
-<?php\r
-       $conn = pg_connect('host=localhost port=5432  password=fv30714$A  user=postgres dbname=edit_geo_mirror');\r
-   $conn = pg_connect(POSTGIS_CS);\r
-if (pg_ErrorMessage($conn)) { \r
-        echo "<p><b>Ocurrio un error conectando a la base de datos: .</b></p>"; \r
-        }\r
-       // 'POLYGON((-5.7107 41.43,-5.11 40.84,-5.7 40.8,-5.11 41.433,-5.7107 41.43))'\r
-       //$geom="POLYGON((".$_GET['point_params[0]']."))";\r
-       //\r
-       \r
-       $polygon= $_GET['param'];\r
-               $userid= $_GET['user'];\r
-\r
-       $query="SELECT genus,specie FROM user_points where user_points.userid='$userid' and user_points.the_geom && GeometryFromText('".$polygon."',4326)";\r
-\r
-       // echo $query;\r
-       //      -5.7 41.4,-5.7 40.800000000000004,-5.1000000000000005 40.800000000000004,-5.1000000000000005 41.4,-5.7 41.4\r
-        $query_result=pg_query($query) or die ("algun errorrrr");\r
-        $count=pg_numrows($query_result);\r
-        if ($count==0)\r
-        {\r
-        print "<div id='content'> No info avaible. \r
-                                                          Use this tool only to query the Demo point data";\r
-        }\r
-        if ($count>160)\r
-        {\r
-        print "<div id='content'> Too much info ($count records) to be visualized here";\r
-        }\r
-        else\r
-        {\r
-        \r
-         print "<div id='content'>\r
-            <h2>$count records </h2>\r
-               <table border='0' class='sortable paginated'>\r
-                        \r
-<thead>\r
-            <tr>\r
-              \r
-              <th class='sort-alpha'>Order data by Genus</th>\r
-           \r
-                              </th>\r
-                         <th class='sort-alpha'>Order data by Species</th>\r
-           \r
-                         </th>\r
-               \r
-          </thead>\r
-                 <tbody>\r
-                         ";\r
-     //          <th class='sort-alpha'>Order data by Province</th></th>       \r
-        while ($row = pg_fetch_array($query_result, NULL, PGSQL_ASSOC)) {\r
-\r
-                print "<tr class='even' style='display: table-row;'>";\r
-                /*\r
-        $numero=1;     \r
-               while ($numero<=$count)\r
-                {\r
-                print "<td><a id='repaginate'>".$numero."</a></td>\n"; \r
-               $numero++;               \r
-               }\r
-               */\r
-                print "<td><a id='repaginate'>".$row['genus']."</a></td>\n";\r
-                print "<td><a id='repaginate'>".$row['specie']."</a></td>\n";\r
-       //       print "<td><a id='repaginate'>".$row['provname']."</a></td>\n";\r
-                 print "</tr>";\r
-               \r
-                }\r
-               \r
-        //echo $result;\r
-               //} \r
-       print "</table>\r
-       </div>\r
-          </tbody>";\r
-          }\r
-       ?>\r