Mashups let you combine data and data presentations (such as maps) from a variety of sources. It may be your own data, or what you bring to the mashup may be a unique way of combining or presenting data. Mashups require a little technical knowledge about a lot of different Web technologies. VTC author Jesse Feiler walks you through every step of the development of two mashups guiding you through the use of some of the most common technologies: MySQL, PHP, REST, JavaScript, and XML. You'll see how to retrieve and parse data from an SQL database and from Amazon.com's product listings; you'll also see how to produce Google maps from your own data. The techniques here are common to many mashups and will help you get started with other sites including eBay and Flickrs. To begin learning simply click the links.
Mashups for Information, Connections, & Maps
The Campaign Contribution Mashup: Overview
Introducing the Data & the Mashup
Looking at the Candidate Data Files
Converting Candidate Data with Excel Pt.1
Converting Candidate Data with Excel Pt.2
Converting Candidate Data with Excel Pt.3
The Campaign Contribution Data Model
Getting Access to Google Mapping
Testing the Basic Mapping Code
Structuring at the JavaScript Code
Modifying the Basic Mapping Code
Making the Map a Global Variable
Adding a Marker with a Function
Adding Information to a Marker
Mixing HTML & JavaScript with PHP
PHP Basics: Strings & Concatenation
PHP Basics: Variables & Defines
Roadmap for the Rest of the Chapter
Describing the Table & Selecting Data
Selecting from the Joined Tables
Loading Tab-delimited Data (Committees)
Loading Fixed-Width Data (Individuals)
Correcting the Fixed-Width Data Load
Altering Tables with New Fields & Types
Structuring the PHP File: Include Files
Constructing a MySQL Query in PHP
Executing the Query/Beginning HTML Table
Filling the HTML Table with MySQL Results
Using the Mapping API with MySQL Data
Getting ZIP Code Data from MySQL
Changing the Info Window Text Pt.1
Changing the Info Window Text Pt.2
Registering for Amazon Web Services
Testing the URL & Looking at XML
Sending the URL & Retrieving the XML
Generalizing the Parsing in a PHP Function
Finish the Formatting of Multiple Authors
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.