Thanks Randy,
now it is correct. I have tried both (Polygon and Polyline)
$ogc=str_replace(",","#",$ogc);
$ogc=str_replace(" ",",",$ogc);
$ogc=str_replace("#"," ",$ogc);
$ogc.=substr($ogc,0,strpos($ogc,","));
$ogc="POLYGON((".$ogc."))";
$ogc="GeomFromText('$ogc')";
$sql="INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES
($ogc,$nutzer,'".$style."')";
$result=mysql_query($sql,$conn);
$newid=mysql_insert_id();
Burkhard
----- Original Message -----
From: Randy George
To: svg-developers@yahoogroups.com
Sent: Wednesday, March 09, 2005 8:41 PM
Subject: RE: [svg-developers] MySQL AText(ogc) -->GeomFromText
Hi Burkhard
Does your code make sure that the first point and last point are
identical? Otherwise you should use linestring instead of polygon.
randy
-----Original Message-----
From: Burkhard Stollenwerk [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 09, 2005 12:28 PM
To: svg-developers@yahoogroups.com
Subject: Re: [svg-developers] MySQL AText(ogc) -->GeomFromText
Hi Randy,
I´ve modify it now with the extras, but It would´t func.
my code:
$ogc=str_replace(",","#",$ogc);
$ogc=str_replace(" ",",",$ogc);
$ogc=str_replace("#"," ",$ogc);
$ogc=substr($ogc,0,-1);
$ogc="POLYGON((".$ogc."))";
$ogc="GeomFromText('$ogc')";
$sql="INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES
($ogc,$nutzer,'".$style."')";
$result=mysql_query($sql,$conn);
$newid=mysql_insert_id();
Burkhard
----- Original Message -----
From: Randy George
To: svg-developers@yahoogroups.com
Sent: Wednesday, March 09, 2005 4:58 PM
Subject: RE: [svg-developers] MySQL AText(ogc) -->GeomFromText
Hi Burkhard,
Try modifying this slightly. First add the extra () for WKT Polygon and
close the Polygon:
INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES
(GeomFromText('POLYGON((2530665 5614074,2530643 614038,2530687
5614030.782426778,2530665 5614067,2530665 5614074 ))'),1,'orange')
Randy
-----Original Message-----
From: Burkhard Stollenwerk [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 09, 2005 7:43 AM
To: svg-developers@yahoogroups.com
Subject: [svg-developers] MySQL AText(ogc) -->GeomFromText
Hello
I have a problem with Mysql and geomdatasaving.
1.) INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES
(GeomFromText('POINT(10 10)'),1,'orange')
2.) INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES
(GeomFromText('POLYGON(2530665 5614074,2530643 614038,2530687
5614030.782426778,2530665 5614067)'),1,'orange')
SELECT id,AsText(ogc_geom) as ogc FROM ownerpolygons
1:) ogc is given as correct text back
2.) ogc is empty?
Is MySQL 4.1.7 not correct or why ist second query empty?
Burkhard Stollenwerk
----- Original Message -----
From: Dale Ellis
To: svg-developers@yahoogroups.com
Sent: Wednesday, March 09, 2005 11:30 AM
Subject: [svg-developers] Re: Quiz in SVG
To anyone interested,
I have improved the SVG quiz, got the question randoming properly so
questions don't come out twice, and there's more questions available.
SVG QUIZ
http://a.1asphost.com/svggames/games/SVGQuiz/index.asp
SVG GAMES
http://a.1asphost.com/svggames/index.asp
--- In svg-developers@yahoogroups.com, "Dale Ellis" <[EMAIL PROTECTED]>
wrote:
>
> Hi all,
>
> Just created a Quiz in SVG on the Simpsons which is on my SVG Games
> site.
>
> Im quite happy with it, it works well in SVG I think, any
> comments/suggestions are very welcome. Links are listed below.
>
> Made a little interface so I can add Questions easily so the number
> of questions increase all the time.
>
> SVG QUIZ
> http://a.1asphost.com/svggames/games/SVGQuiz/index.asp
>
> SVG GAMES
> http://a.1asphost.com/svggames/index.asp
>
> Thanks
> Dale Ellis
-----
To unsubscribe send a message to:
[EMAIL PROTECTED]
-or-
visit http://groups.yahoo.com/group/svg-developers and click "edit my
membership"
----
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/svg-developers/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[Non-text portions of this message have been removed]
-----
To unsubscribe send a message to:
[EMAIL PROTECTED]
-or-
visit http://groups.yahoo.com/group/svg-developers and click "edit my
membership"
----
Yahoo! Groups Links
-----
To unsubscribe send a message to:
[EMAIL PROTECTED]
-or-
visit http://groups.yahoo.com/group/svg-developers and click "edit my
membership"
----
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/svg-developers/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
-----
To unsubscribe send a message to: [EMAIL PROTECTED]
-or-
visit http://groups.yahoo.com/group/svg-developers and click "edit my
membership"
----
Yahoo! Groups Links
-----
To unsubscribe send a message to: [EMAIL PROTECTED]
-or-
visit http://groups.yahoo.com/group/svg-developers and click "edit my
membership"
----
Yahoo! Groups Sponsor
ADVERTISEMENT
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/svg-developers/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
-----
To unsubscribe send a message to: [EMAIL PROTECTED]
-or-
visit http://groups.yahoo.com/group/svg-developers and click "edit my
membership"
----
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/svg-developers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
