Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db = new PDO("pgsql:host=localhost; dbname=gmq717", "postgres", "gmq717");
- echo $_GET['var'] . '<br>';
- $sql = 'SELECT ' . $_GET['var'] . ' as var FROM "montreal_postgis" WHERE ' . $_GET['var'] . ' > ' . $_GET['varMin'] . ' AND ' . $_GET['var'] . ' < ' . $_GET['varMax'] . ';';
- echo $sql . '<br>';
- $query = $db->query($sql);
- echo json_encode($query->fetch());
- echo '<br>';
- echo json_encode($query->fetch());
- ?>
Advertisement
Add Comment
Please, Sign In to add comment