rodolpheg

Untitled

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