Revert "converting CRLF to LF"

[geo.git] / edit_wp5_web_folder / geo / selects / select-chain_3_fourth.php

diff --git a/edit_wp5_web_folder/geo/selects/select-chain_3_fourth.php b/edit_wp5_web_folder/geo/selects/select-chain_3_fourth.php
new file mode 100644 (file)
index 0000000..ee928cb
--- /dev/null
+++ b/edit_wp5_web_folder/geo/selects/select-chain_3_fourth.php
@@ -0,0 +1,39 @@
+<?php\r
+\r
+require 'jsonwrapper.php';\r
+//this require is needed for PHP versions < 5.2\r
+function isAjax() {\r
+return (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && \r
+    ($_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest'));\r
+}\r
+if(!isAjax()) {echo "no ajax call";} \r
+else\r
+{\r
+//@session_start();\r
+//$sessionid=session_id();\r
+ //  $conn = pg_connect(POSTGIS_CS);\r
+$conn = pg_connect('host=localhost port=5432  password=fv30714$A  user=postgres dbname=edit_geo_mirror');\r
+if (pg_ErrorMessage($conn)) { \r
+        echo "<p><b>Ocurrio un error conectando a la base de datos: .</b></p>"; \r
+        }\r
+        \r
+        else \r
+       { \r
+       \r
+\r
+               $userid=$_GET['userid'];\r
+                               $postgis_result=pg_query("select distinct(specie) from user_points where userid='$userid' order by specie");\r
+\r
+        $json= array();\r
+               //$numFilas =pg_NumRows($postgis_result);\r
+               while ($row = pg_fetch_array($postgis_result, NULL, PGSQL_ASSOC)) {\r
+       $json[] = $row['specie'];\r
+                               }\r
+               echo json_encode($json);\r
+\r
+                       die(); // filthy exit...        \r
+       }\r
+\r
+       }\r
+\r
+?>\r