Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. map.on('draw:created',function (e) {
  2. var type = e.layerType,
  3. layer = e.layer;
  4.  
  5. var coordinates = layer.getLatLngs();
  6. var sql_coordinates =[];
  7.  
  8. for (var i in coordinates){
  9. sql_coordinates.push(coordinates[i].lng+" "+coordinates[i].lat);
  10. $('#coords').val(sql_coordinates);
  11. alert(sql_coordinates);
  12. };
  13. });
  14.  
  15. <input type="hidden" name="coords" id="coords" />
  16.  
  17. <?php
  18.  
  19. // Parametre de connection
  20. $host = 'localhost';
  21. $database = 'metiers';
  22. $user = 'postgres';
  23. $pass = '';
  24. $port = '5432';
  25.  
  26. $dns = 'pgsql:host='.$host .';port='.$port .';dbname='.$database;
  27.  
  28. // récupération des variables
  29. $coords = $_POST['coords'];
  30.  
  31. try
  32. {
  33. $bdd = new PDO("pgsql:host=$host;dbname=$database",$user,$pass);
  34. $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  35.  
  36. //Requete d'insertion
  37.  
  38. $req = $bdd->prepare('INSERT INTO city.conduites_ep_l93(coords) VALUES(?)');
  39.  
  40. $req->execute(array($coords));
  41.  
  42. }
  43. catch(Exception $e)
  44. {
  45. echo "Connection a la BDD impossible : ", $e->getMessage();
  46. die();
  47. }
  48.  
  49. header('Location:index.html');
  50.  
  51. ?>
  52.  
  53. Update city.conduites_ep_l93 SET geom = ST_GeomFromText('MULTILINESTRING((coords))',2154);
  54.  
  55. ERROR: parse error - invalid geometry
  56. HINT: "MULTILINESTRING((co" <-- parse error at position 19 within geometry
  57. ********** Erreur **********
  58.  
  59. ERROR: parse error - invalid geometry
  60. État SQL :XX000
  61. Astuce : "MULTILINESTRING((co" <-- parse error at position 19 within geometry
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement