Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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.

Subscriber Reviews

Average Rating: 0 out of 5 rating Based on 0 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

Introduction

Introducing Mashups

Preview

00:03:36

Mashups for Information, Connections, & Maps

Preview

00:03:22

The Campaign Contribution Mashup: Overview

Preview

00:05:43

About This Course

Preview

00:03:09

Business Models & Legal Issues for Mashups

Overview

Preview

00:04:28

Using Mashups for Advertising & Promotion

Preview

00:01:30

Mashups for Advocacy

Preview

00:02:26

Mashups for Intermediaries

Preview

00:01:23

Mashups for Hollywood

Preview

00:00:56

Mashup Architecture & Technology

Housekeeping

Preview

00:03:14

Mashups: The What

Preview

00:03:53

Mashups: The Why

Preview

00:05:31

Mashups: The How

Preview

00:05:50

Mashups: Technology Pt.1

Preview

00:05:51

Mashups: Technology Pt.2

Preview

00:01:48

The Campaign Contribution Mashup Data

Introducing the Data & the Mashup

Preview

00:06:12

Campaign Data

Preview

00:03:09

Looking at the Candidate Data Files

Preview

00:04:11

Converting Candidate Data with Excel Pt.1

Preview

00:03:58

Converting Candidate Data with Excel Pt.2

Preview

00:06:47

Converting Candidate Data with Excel Pt.3

Preview

00:05:25

The Campaign Contribution Data Model

Preview

00:04:04

Writing the Mashup with JavaScript

Starting the Mashup

Preview

00:04:35

Getting Access to Google Mapping

Preview

00:06:03

The Most Basic Mapping Mashup

Preview

00:04:40

Testing the Basic Mapping Code

Preview

00:01:55

Structuring at the JavaScript Code

Preview

00:03:31

Modifying the Basic Mapping Code

Preview

00:02:59

Making the Map a Global Variable

Preview

00:06:10

Adding a Marker with a Function

Preview

00:04:53

Adding Information to a Marker

Preview

00:06:19

Customizing Markers

Preview

00:03:18

Adding Map Controls

Preview

00:02:43

Introducing Geocoding

Preview

00:03:02

Restructuring the Code

Preview

00:04:31

The showAddress Function

Preview

00:03:55

Running the Geocoder

Preview

00:02:05

Generalizing showAddress

Preview

00:07:00

Adding PHP

Introducing PHP

Preview

00:03:08

Mixing HTML & JavaScript with PHP

Preview

00:02:36

Generating HTML from PHP

Preview

00:05:10

PHP Basics: Comments

Preview

00:03:04

PHP Basics: Strings & Concatenation

Preview

00:04:34

PHP Basics: Variables & Defines

Preview

00:02:43

Using PHP with Forms

Preview

00:02:20

Adding MySQL

Running MySQL on Windows

Preview

00:02:57

Running MySQL on Mac OS X

Preview

00:04:38

Configuring MySQL on Windows

Preview

00:01:43

Roadmap for the Rest of the Chapter

Preview

00:05:39

Overview of SELECT

Preview

00:02:08

Describing the Table & Selecting Data

Preview

00:04:54

Using WHERE

Preview

00:03:06

Using Help

Preview

00:01:44

More on WHERE: Joining Tables

Preview

00:02:55

Selecting from the Joined Tables

Preview

00:06:50

Grouping Data

Preview

00:04:15

HAVING, ORDER BY, & FORMAT

Preview

00:03:54

Creating & Altering Tables

Preview

00:05:18

Altering Table Columns

Preview

00:03:22

More on Altering Tables

Preview

00:04:36

Using Indexes

Preview

00:06:12

Unique & Partial Indexes

Preview

00:04:55

Forcing non-Null Values

Preview

00:02:09

Using Primary Keys

Preview

00:01:32

Loading Data: Introduction

Preview

00:04:35

Loading CSV Data (Candidates)

Preview

00:06:19

Loading Tab-delimited Data (Committees)

Preview

00:04:10

Loading Fixed-Width Data (Individuals)

Preview

00:06:11

Checking the Data Load

Preview

00:03:45

Correcting the Fixed-Width Data Load

Preview

00:03:26

Showing the Warnings

Preview

00:01:03

Altering Tables with New Fields & Types

Preview

00:04:07

Updating the Table Data

Preview

00:06:54

Adding Security

Preview

00:04:50

Adding MySQL to PHP

Overview

Preview

00:03:05

Structuring the PHP File: Include Files

Preview

00:06:36

How PHP Catches MySQL Errors

Preview

00:01:50

The MySQL/PHP Syntax

Preview

00:04:08

Constructing a MySQL Query in PHP

Preview

00:05:10

Executing the Query/Beginning HTML Table

Preview

00:03:59

Filling the HTML Table with MySQL Results

Preview

00:06:01

Using the Mapping API with MySQL Data

Preview

00:01:56

Revising the Includes

Preview

00:05:37

Getting ZIP Code Data from MySQL

Preview

00:04:55

Implementing the WHILE Loop

Preview

00:03:28

Cleaning Up a Bad ZIP Code

Preview

00:03:53

Changing the Info Window Text Pt.1

Preview

00:03:23

Changing the Info Window Text Pt.2

Preview

00:05:06

Using Alternate Markers

Preview

00:06:12

Building Mashups from External Data

Overview

Preview

00:05:03

Registering for Amazon Web Services

Preview

00:05:28

Registering for eBay

Preview

00:02:50

Retrieving Data from Amazon

Preview

00:05:19

Adding the Keywords

Preview

00:03:15

Testing the URL & Looking at XML

Preview

00:05:03

Sending the URL & Retrieving the XML

Preview

00:05:49

Parsing the XML

Preview

00:06:11

Generalizing the Parsing in a PHP Function

Preview

00:03:49

Creating an Amazon Link Pt.1

Preview

00:04:54

Creating an Amazon Link Pt.2

Preview

00:03:53

Finish the Formatting of Multiple Authors

Preview

00:04:45

Course Summary

Course Summary

Preview

00:03:45

About the Author

About the Author

Preview

00:03:46