hi paolo,<div><br></div><div>you've got to have a database with GIS extension. I use mysql. mysql 4.1 and above supports GIS and spatial extension. </div><div><br></div><div>my application is written in php with mysql. I use phpmyadmin to manage my db </div>
<div><br></div><div>inserting can be as simple as this</div><div>-------------------------------------------------</div><div>insert into my_geometries (my_id,geometries) values ('$my_id',GeomFromText('$geometries'))</div>
<div><br></div><div>and retrieving like this</div><div>-------------------------------</div><div>select AsText(geometries) as geom from my_geometries where my_id='$my_id'</div><div><br></div><div>to view geometries from phpmyadmin, please use the latest phpmyadmin version.</div>
<div><br></div><div>hope that helps, </div><div><br></div><div>remi<br><br><div class="gmail_quote">On Wed, Sep 1, 2010 at 7:10 PM, snuffer892 <span dir="ltr"><<a href="mailto:paolo_tome@hotmail.com">paolo_tome@hotmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br>
Hello everyone,<br>
I followed one of the examples provided by openlayer, to allow users to draw<br>
geometries:<br>
<br>
<a href="http://svn.openlayers.org/sandbox/stvn/arcgis-server/examples/wkt.html" target="_blank">http://svn.openlayers.org/sandbox/stvn/arcgis-server/examples/wkt.html</a><br>
<br>
I have, for the geometry designed, an info window containing the<br>
coordinates in WKT format;<br>
Can someone help me understand how to insert geometries in a database?<br>
<br>
thanks a lot!<br>
Paolo<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/WKT-insert-into-database-tp5486415p5486415.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/WKT-insert-into-database-tp5486415p5486415.html</a><br>
Sent from the OpenLayers Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@openlayers.org">Users@openlayers.org</a><br>
<a href="http://openlayers.org/mailman/listinfo/users" target="_blank">http://openlayers.org/mailman/listinfo/users</a><br>
</font></blockquote></div><br></div>