Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db = new PDO("pgsql:host=localhost; dbname=gmq717", "postgres", "gmq717");
- $variable = '*';
- $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'] . ';';
- $query = $db->query($sql);
- echo json_encode($query->fetch());
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement