Guest User

Untitled

a guest
Jul 23rd, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. $x = $_POST['x'];
  2. $y = $_POST['y'];
  3. $geom="ST_GeomFromText('POINT($x $y)',2154)";
  4. $r = $bdd->prepare("INSERT INTO ouvragesp (id, yl93, xl93,annee,geom) VALUES(:identifiant , :y , :x , 2017, :geom)");
  5. $r->execute(array(
  6. 'identifiant' => $id,
  7. 'x' => $x,
  8. 'y' => $y,
  9. 'geom' => $geom));
  10.  
  11. PDOStatement::execute(): SQLSTATE[XX000]: Internal error: 7 ERROR: parse error - invalid geometry HINT: "ST" <-- parse error at position 2 within geometry
  12.  
  13. $r = $bdd->prepare("INSERT INTO ouvragesp (id, yl93, xl93,annee,geom) VALUES(:identifiant , :y , :x , 2017,ST_GeomFromText(:geom,2154))");
  14. $r->execute(array(
  15. 'identifiant' => $id,
  16. 'x' => $x,
  17. 'y' => $y,
  18. 'geom' => "POINT($x $y)"));
Add Comment
Please, Sign In to add comment