by Jesse Feiler | Publisher: Virtual Training Company, Inc. | Release Date: December 2002 | ISBN: 01220110072SI

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.

1. Introduction
   • Introducing Mashups 00:03:36
   • Mashups for Information, Connections, & Maps 00:03:22
   • The Campaign Contribution Mashup: Overview 00:05:43
   • About This Course 00:03:09
2. Business Models & Legal Issues for Mashups
   • Overview 00:04:28
   • Using Mashups for Advertising & Promotion 00:01:30
   • Mashups for Advocacy 00:02:26
   • Mashups for Intermediaries 00:01:23
   • Mashups for Hollywood 00:00:56
3. Mashup Architecture & Technology
   • Housekeeping 00:03:14
   • Mashups: The What 00:03:53
   • Mashups: The Why 00:05:31
   • Mashups: The How 00:05:50
   • Mashups: Technology Pt.1 00:05:51
   • Mashups: Technology Pt.2 00:01:48
4. The Campaign Contribution Mashup Data
   • Introducing the Data & the Mashup 00:06:12
   • Campaign Data 00:03:09
   • Looking at the Candidate Data Files 00:04:11
   • Converting Candidate Data with Excel Pt.1 00:03:58
   • Converting Candidate Data with Excel Pt.2 00:06:47
   • Converting Candidate Data with Excel Pt.3 00:05:25
   • The Campaign Contribution Data Model 00:04:04
5. Writing the Mashup with JavaScript
   • Starting the Mashup 00:04:35
   • Getting Access to Google Mapping 00:06:03
   • The Most Basic Mapping Mashup 00:04:40
   • Testing the Basic Mapping Code 00:01:55
   • Structuring at the JavaScript Code 00:03:31
   • Modifying the Basic Mapping Code 00:02:59
   • Making the Map a Global Variable 00:06:10
   • Adding a Marker with a Function 00:04:53
   • Adding Information to a Marker 00:06:19
   • Customizing Markers 00:03:18
   • Adding Map Controls 00:02:43
   • Introducing Geocoding 00:03:02
   • Restructuring the Code 00:04:31
   • The showAddress Function 00:03:55
   • Running the Geocoder 00:02:05
   • Generalizing showAddress 00:07:00
6. Adding PHP
   • Introducing PHP 00:03:08
   • Mixing HTML & JavaScript with PHP 00:02:36
   • Generating HTML from PHP 00:05:10
   • PHP Basics: Comments 00:03:04
   • PHP Basics: Strings & Concatenation 00:04:34
   • PHP Basics: Variables & Defines 00:02:43
   • Using PHP with Forms 00:02:20
7. Adding MySQL
   • Running MySQL on Windows 00:02:57
   • Running MySQL on Mac OS X 00:04:38
   • Configuring MySQL on Windows 00:01:43
   • Roadmap for the Rest of the Chapter 00:05:39
   • Overview of SELECT 00:02:08
   • Describing the Table & Selecting Data 00:04:54
   • Using WHERE 00:03:06
   • Using Help 00:01:44
   • More on WHERE: Joining Tables 00:02:55
   • Selecting from the Joined Tables 00:06:50
   • Grouping Data 00:04:15
   • HAVING, ORDER BY, & FORMAT 00:03:54
   • Creating & Altering Tables 00:05:18
   • Altering Table Columns 00:03:22
   • More on Altering Tables 00:04:36
   • Using Indexes 00:06:12
   • Unique & Partial Indexes 00:04:55
   • Forcing non-Null Values 00:02:09
   • Using Primary Keys 00:01:32
   • Loading Data: Introduction 00:04:35
   • Loading CSV Data (Candidates) 00:06:19
   • Loading Tab-delimited Data (Committees) 00:04:10
   • Loading Fixed-Width Data (Individuals) 00:06:11
   • Checking the Data Load 00:03:45
   • Correcting the Fixed-Width Data Load 00:03:26
   • Showing the Warnings 00:01:03
   • Altering Tables with New Fields & Types 00:04:07
   • Updating the Table Data 00:06:54
   • Adding Security 00:04:50
8. Adding MySQL to PHP
   • Overview 00:03:05
   • Structuring the PHP File: Include Files 00:06:36
   • How PHP Catches MySQL Errors 00:01:50
   • The MySQL/PHP Syntax 00:04:08
   • Constructing a MySQL Query in PHP 00:05:10
   • Executing the Query/Beginning HTML Table 00:03:59
   • Filling the HTML Table with MySQL Results 00:06:01
   • Using the Mapping API with MySQL Data 00:01:56
   • Revising the Includes 00:05:37
   • Getting ZIP Code Data from MySQL 00:04:55
   • Implementing the WHILE Loop 00:03:28
   • Cleaning Up a Bad ZIP Code 00:03:53
   • Changing the Info Window Text Pt.1 00:03:23
   • Changing the Info Window Text Pt.2 00:05:06
   • Using Alternate Markers 00:06:12
9. Building Mashups from External Data
   • Overview 00:05:03
   • Registering for Amazon Web Services 00:05:28
   • Registering for eBay 00:02:50
   • Retrieving Data from Amazon 00:05:19
   • Adding the Keywords 00:03:15
   • Testing the URL & Looking at XML 00:05:03
   • Sending the URL & Retrieving the XML 00:05:49
   • Parsing the XML 00:06:11
   • Generalizing the Parsing in a PHP Function 00:03:49
   • Creating an Amazon Link Pt.1 00:04:54
   • Creating an Amazon Link Pt.2 00:03:53
   • Finish the Formatting of Multiple Authors 00:04:45
10. Course Summary
    • Course Summary 00:03:45
11. About the Author
    • About the Author 00:03:46