Advertisement
rodolpheg

Untitled

Feb 23rd, 2020
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. <?php
  2. $db = new PDO("pgsql:host=localhost; dbname=gmq717", "postgres", "gmq717");
  3. $variable = '*';
  4. $sql = 'SELECT ' . $_GET['var'] . '::INTEGER as var, da_number, ST_AsGeoJSON(geom, 5) as geom FROM "montreal_postgis" WHERE ' . $_GET['var'] . ' > ' . $_GET['varMin'] . ' AND ' . $_GET['var'] . ' < ' . $_GET['varMax'] . ';';
  5. $query = $db->query($sql);
  6. echo json_encode($query->fetch());
  7. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement