Advertisement
Guest User

Untitled

a guest
Mar 30th, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.48 KB | None | 0 0
  1. <div class="popup">
  2. <tr><select id="a1_title"></select></div></tr>
  3. <tr><select id="a2_title"></select></div></tr>
  4. <!-- Button (Double) -->
  5. <div class="form-group">
  6. <label class="col-md-4 control-label" for="cancel"></label>
  7. <button type="button" id="cancel" class="btn btn-default cancel">Cancel</button>
  8. <button type="submit" id="save" class="btn btn-success submit">OK</button>
  9. </div>
  10. </div>
  11. <div id="map" class="map"><div>
  12.  
  13. // JavaScript Document
  14. $(document).ready(function(){
  15. $.getJSON("php/drpdwn.php", success = function(data){
  16. var items="";
  17. for(var i = 0; i< data.length; i++){
  18. // RETAIN JSON KEY AS OPTION VALUE, JSON VALUE AS OPTION TEXT items +="<option value='"+data[i].id+"'>" + data[i].name+"</option>";
  19. }
  20. $("#a1_title").append(items);
  21. $("#a1_title").change();
  22. });
  23. $("#a1_title").change(function(){
  24.  
  25. // OBTAIN SELECTED VALUE
  26. var selectedValue = $(this).find(":selected").text();
  27.  
  28. if( selectedValue == "Landuse/landcover") {
  29.  
  30. $.getJSON("php/lulc_db.php",success = function(data){
  31. var items="";
  32. for(var i = 0; i< data.length; i++){
  33.  
  34. items+="<option value='"+data[i]+"'>" + data[i] +"</option>";
  35. }
  36. // REMOVE PREVIOUS ITEMS
  37. var myNode = document.getElementById("a2_title");
  38. while (myNode.firstChild) {
  39. myNode.removeChild(myNode.firstChild);
  40. }
  41. // ADD NEW ITEMS
  42. $("#a2_title").append(items);
  43. });
  44. $("#a2_title").change(function(){
  45. //the main problem start from here
  46. //this the only one which is not working
  47. var selectedtext = $(this).find(":selected").text();
  48. if( selectedValue == "Built Up") {
  49. alert("k");
  50. $('input[type="submit"]').on('click',function(){
  51. $.getJSON("php/geojson.php?layer="+ $(this).text(),success = function(data){
  52. console.log(data);
  53. });
  54. }); }
  55. });
  56.  
  57. }
  58. else if( selectedValue == "Soil") {
  59.  
  60. $.getJSON("php/soil_db.php",success = function(data){
  61. var items="";
  62. for(var i = 0; i< data.length; i++){
  63.  
  64. items+="<option value='"+data[i]+"'>"+data[i]+"</option>";
  65.  
  66. }
  67. // REMOVE PREVIOUS ITEMS
  68. var myNode = document.getElementById("a2_title");
  69. while (myNode.firstChild) {
  70. myNode.removeChild(myNode.firstChild);
  71. }
  72. // ADD NEW ITEMS
  73. $("#a2_title").append(items);
  74. });
  75. }
  76.  
  77. });
  78.  
  79. });
  80.  
  81. <?php
  82. if(isset($_GET["layer"]))
  83. {
  84. $host = "localhost";
  85. $user = "postgres";
  86. $pass = "admin";
  87. $db = "Querybuilderdb";
  88. $con = pg_connect("host=$host dbname=$db user=$user password=$pass")
  89. or die ("Could not connect to servern");
  90. $sql = "SELECT gid, level_1 , st_asgeojson(geom) AS geojson FROM pachgaon_lulc where level_1='{$layer}' ";
  91. $rs = pg_query($con, $sql);
  92. if (!$rs) {
  93. echo "An SQL error occured.n";
  94. exit;
  95. }
  96. # Build GeoJSON feature collection array
  97. $geojson = array(
  98. 'type' => 'FeatureCollection',
  99. 'features' => array()
  100. );
  101.  
  102. # Loop through rows to build feature arrays
  103. while ($row = pg_fetch_array($rs)) {
  104.  
  105. $properties = $row;
  106. # Remove geojson and geometry fields from properties
  107. unset($properties['geojson']);
  108. $feature = array(
  109. 'type' => 'Feature',
  110. 'id' => $row['gid'],
  111. 'properties' => array(
  112. 'name' => $row['level_1']
  113. ),
  114.  
  115. 'geometry' => json_decode($row['geojson']),
  116. );
  117. array_push($geojson['features'], $feature);
  118. }
  119. header('Content-type: application/json');
  120. echo json_encode($geojson);
  121. }
  122. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement