+++ /dev/null
-<?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