Dynamic balloons...

[brazilbear]

Hello again,

Now that I have got PHP with MySQL working to create KML, I was
wondering if someone knows away to make information inside a balloon
dynamic also. For instance, If I inside a balloon I were to have
information about a point.

Ex.
_________________________________
l Location Name: l
l Date of Purchase: l
l Area: l
l Crop: l
l Perimeter: l
l l
l Etc...: l
l l
l l
l l
_________________________________

Is it possible to put variables inside of cdata? I basically want the
description of each point to query the MySQL database and display
information inside the balloon specifically for the point?


Also, What would be the best way to store polygon coordinates inside
the MySQL database so polygons are also created dynamically in GE? I
also have access to ArcGIS if that helps...

Thanks for all your help. I truly appreciate having a resource like
this developer group to help expand my knowledge of GE for use in
Argriculture applications.

- Brazilbear

[jpwade_bsu]

Hello brazilbear,

try http://www.czmartin.com/jpw/asp_arcmap/index.asp for sniplet
exmaples

jpwade
www.czmartin.com/jpw

[barryhunter [KML Guru]]

Sounds like you want the Schema tags to define your data, and
BalloonStyle to setup your Balloons to display it, theres a nice
introduction with worked examples here:
http://code.google.com/apis/kml/documentation/extendeddata.html


If you have MySQL 4.11 or above (probably), I would recommend using
hte 'Geometry' datatype. There are mysql functions to convert between
the internal binary format, and a 'well-known-text' format, which is
then easily changable to a KML linestring with a bit of PHP.

http://groups.google.com/group/kml-support/web/getting-started-with-spatial-mysql

[brazilbear]

Hey thanks a lot for your help guys...I'm still working on the project
and I will let you know how it turns out

Muito Obrigado,

brazilbear

On May 10, 8:37 am, barryhunter [KML Guru] wrote:
> Sounds like you want the Schema tags to define your data, and
> BalloonStyle to setup your Balloons to display it, theres a nice
> introduction with worked examples here:http://code.google.com/apis/kml/documentation/extendeddata.html
>
> If you have MySQL 4.11 or above (probably), I would recommend using
> hte 'Geometry' datatype. There are mysql functions to convert between
> the internal binary format, and a 'well-known-text' format, which is
> then easily changable to a KML linestring with a bit of PHP.
>

> http://groups.google.com/group/kml-support/web/getting-started-with-s...