Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    Mashups (Web 2.0 Web Apps)

    Subscriber Reviews • Browse Similar Topics

    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