Become a member

Online Access to 1000+ Courses!

Mashups (Web 2.0 Web Apps) Course

Author : Jesse Feiler

7hrs (103 Lessons) 2006-12-22

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
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.

Transcription not available

Course: Mashups (Web 2.0 Web Apps)
Author: Jesse Feiler
SKU: 33730
ISBN: 1-933736-58-5
Work Files: Yes
Captions: No
Subject: Programming
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

Introduction

Introducing Mashups (03:36)

Mashups for Information, Connections, & Maps (03:22)

The Campaign Contribution Mashup: Overview (05:43)

About This Course (03:09)

Business Models & Legal Issues for Mashups

Overview (04:28)

Using Mashups for Advertising & Promotion (01:30)

Mashups for Advocacy (02:27)

Mashups for Intermediaries (01:23)

Mashups for Hollywood (00:56)

Mashup Architecture & Technology

Housekeeping (03:14)

Mashups: The What (03:53)

Mashups: The Why (05:31)

Mashups: The How (05:50)

Mashups: Technology Pt.1 (05:51)

Mashups: Technology Pt.2 (01:49)

The Campaign Contribution Mashup Data

Introducing the Data & the Mashup (06:12)

Campaign Data (03:09)

Looking at the Candidate Data Files (04:11)

Converting Candidate Data with Excel Pt.1 (03:58)

Converting Candidate Data with Excel Pt.2 (06:47)

Converting Candidate Data with Excel Pt.3 (05:25)

The Campaign Contribution Data Model (04:04)

Writing the Mashup with JavaScript

Starting the Mashup (04:35)

Getting Access to Google Mapping (06:03)

The Most Basic Mapping Mashup (04:40)

Testing the Basic Mapping Code (01:55)

Structuring at the JavaScript Code (03:31)

Modifying the Basic Mapping Code (02:59)

Making the Map a Global Variable (06:10)

Adding a Marker with a Function (04:53)

Adding Information to a Marker (06:19)

Customizing Markers (03:18)

Adding Map Controls (02:43)

Introducing Geocoding (03:02)

Restructuring the Code (04:32)

The showAddress Function (03:55)

Running the Geocoder (02:05)

Generalizing showAddress (07:00)

Adding PHP

Introducing PHP (03:08)

Mixing HTML & JavaScript with PHP (02:36)

Generating HTML from PHP (05:10)

PHP Basics: Comments (03:04)

PHP Basics: Strings & Concatenation (04:34)

PHP Basics: Variables & Defines (02:43)

Using PHP with Forms (02:20)

Adding MySQL

Running MySQL on Windows (02:57)

Running MySQL on Mac OS X (04:38)

Configuring MySQL on Windows (01:43)

Roadmap for the Rest of the Chapter (05:39)

Overview of SELECT (02:08)

Describing the Table & Selecting Data (04:54)

Using WHERE (03:07)

Using Help (01:44)

More on WHERE: Joining Tables (02:55)

Selecting from the Joined Tables (06:50)

Grouping Data (04:15)

HAVING, ORDER BY, & FORMAT (03:54)

Creating & Altering Tables (05:19)

Altering Table Columns (03:22)

More on Altering Tables (04:36)

Using Indexes (06:12)

Unique & Partial Indexes (04:55)

Forcing non-Null Values (02:09)

Using Primary Keys (01:32)

Loading Data: Introduction (04:36)

Loading CSV Data (Candidates) (06:19)

Loading Tab-delimited Data (Committees) (04:10)

Loading Fixed-Width Data (Individuals) (06:11)

Checking the Data Load (03:45)

Correcting the Fixed-Width Data Load (03:26)

Showing the Warnings (01:03)

Altering Tables with New Fields & Types (04:07)

Updating the Table Data (06:54)

Adding Security (04:50)

Adding MySQL to PHP

Overview (03:05)

Structuring the PHP File: Include Files (06:36)

How PHP Catches MySQL Errors (01:50)

The MySQL/PHP Syntax (04:08)

Constructing a MySQL Query in PHP (05:10)

Executing the Query/Beginning HTML Table (04:00)

Filling the HTML Table with MySQL Results (06:01)

Using the Mapping API with MySQL Data (01:56)

Revising the Includes (05:37)

Getting ZIP Code Data from MySQL (04:55)

Implementing the WHILE Loop (03:29)

Cleaning Up a Bad ZIP Code (03:53)

Changing the Info Window Text Pt.1 (03:23)

Changing the Info Window Text Pt.2 (05:06)

Using Alternate Markers (06:12)

Building Mashups from External Data

Overview (05:03)

Registering for Amazon Web Services (05:28)

Registering for eBay (02:50)

Retrieving Data from Amazon (05:19)

Adding the Keywords (03:16)

Testing the URL & Looking at XML (05:03)

Sending the URL & Retrieving the XML (05:49)

Parsing the XML (06:12)

Generalizing the Parsing in a PHP Function (03:49)

Creating an Amazon Link Pt.1 (04:54)

Creating an Amazon Link Pt.2 (03:53)

Finish the Formatting of Multiple Authors (04:45)

Course Summary

Course Summary (03:45)

About the Author

About the Author (03:46)