OpenLayers AJAX Example: PHP / MySQL / JSON

OpenLayers AJAX Example

The 'Search Market' button activates a JavaScript function which encodes the values for each selected checkbox into a single URL parameter, 'q'. This parameter is then intercepeted by a PHP script, and sliced into an array of individual values. These values, corresponding to company types, are then used to query a MySQL database. The resulting rows which are returned from the SQL query are then parsed into JSON to be displayed onto the map, using the Yahoo Geocoder.

Air Ambulance
Assistance Company
Ground Ambulance
HEMS
Private Clinics
Hospitals
Funeral Directors
Cost Containment Company
Case Management Company
Medical Escort Company
Services/Broker
Insurance Company/Broker
Professional Security
Other Products/Services
Air Ambulance Empty Legs
Pending RFQs