Using PHP and MySQL to Create KML - Tutorial
    by Mano Marks  http://code.google.com/support/bin/answer.py?answer=69906 

15 Minutes or less to SetUp - Create Database ,  Create Table ,   Populate Table
 

• Open phpMyAdmin
  • 1) WampServer Tray Icon > phpMyAdmin
  • 2) if you get an error page , Select Open new phpMyAdmin window link at bottom of page
     
• 1) Create New Database 
  • 1) type in TEST_DB and Click Create Button
    
    
    
    
     
• 2) Create Table "markers"  in TEST_DB
  • 1) Select SQL
  • 2) Open phpsqlajax_createtable.sql Copy and Paste  into Run SQL query on database TEST_DB Box and Click Go Button
    
    
    
    
     
• 3) Populate Table & Review Records
  • 1) Select SQL
  • 2) open phpsqlajax_data.sql , Copy and Paste into Run SQL query on database TEST_DB  Box and click GO Button
  • 3) To Review records in database
    • Select markers under test_db(1)  then select Browse

    
    
     

Copy PHP Scripts to c:\wamp\www\test 

• 1) Right Click phpsqlajax_dbinfo.php Save As to c:\wamp\www\test

  • Open with notepad and Edit as shown below

    • <?php
      $username="root";
      $password="";
      $database="TEST_DB";
      ?>

    Note: you are able to use the above username and password settings because 
    the MySQL server is not secure. This is mentioned at the bottom of
    the opening page of phpMyAdmin. Configure "Privileges" to secure the
    server and then change username & password after testing.

• 2) Right Click phpsql_genkml.php  & phpsql_genkml3.php  Save As to c:\wamp\www\test

  • Navigate to c:\wamp\www\test and make sure the files have .php and not .txt extensions

• 3) View In Google Earth

  • Open GEarth > Select Add Pulldown Menu > Select Add NetLink 

  • For Link Box Use

    • http://localhost/test/phpsql_genkml3.php 

      • set Apache 2.2.8 or 2.0.63 /  set PHP 4.4.7 or PHP5 5.2.5

    • http://localhost/test/phpsql_genkml.php 

      • set Apache 2.0.63 / set PHP5 5.2.5

For In-depth information Read: "Using PHP and MySQL to create KML" by Mano Marks
http://code.google.com/support/bin/answer.py?answer=69906  

An introduction to setting up a Apache WebServer, using phpMyAdmin, connecting to a MS_Access or MySql database
  to display attributes in GEarth and Gmaps, GEarth API,  etc

SetUp a Home WebServer

Using PHP and MySQL to Create KML

Set your Apache Server for ArcMap Geodatabase

Zip File Contents and  Explination of Scripts (includes GEarth API)

Create MySQL DB from Exported Data of the ArcMap GeoDatabase

Add Polygons From ArcMap to MySQL DB

Put Your Server On-Line, Tool Tips, Other

Index Page    |    Home Page