Mashups Web Apps 2 Tutorial Video - Try for FREE

Introduction

• Introducing Mashups Demo
• Mashups for Information, Connections, & Maps Demo
• The Campaign Contribution Mashup: Overview Demo
• About This Course Demo

Business Models & Legal Issues for Mashups

• Overview Demo
• Using Mashups for Advertising & Promotion Demo
• Mashups for Advocacy Demo
• Mashups for Intermediaries Demo
• Mashups for Hollywood Demo

Mashup Architecture & Technology

• Housekeeping Demo
• Mashups: The What Demo
• Mashups: The Why Demo
• Mashups: The How Demo
• Mashups: Technology Pt.1 Demo
• Mashups: Technology Pt.2 Demo

The Campaign Contribution Mashup Data

• Introducing the Data & the Mashup
• Campaign Data
• 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

Writing the Mashup with JavaScript

• Starting the Mashup
• Getting Access to Google Mapping
• The Most Basic Mapping Mashup
• 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
• Customizing Markers
• Adding Map Controls
• Introducing Geocoding
• Restructuring the Code
• The showAddress Function
• Running the Geocoder
• Generalizing showAddress

Adding PHP

• Introducing PHP
• Mixing HTML & JavaScript with PHP
• Generating HTML from PHP
• PHP Basics: Comments
• PHP Basics: Strings & Concatenation
• PHP Basics: Variables & Defines
• Using PHP with Forms

Adding MySQL

• Running MySQL on Windows
• Running MySQL on Mac OS X
• Configuring MySQL on Windows
• Roadmap for the Rest of the Chapter
• Overview of SELECT
• Describing the Table & Selecting Data
• Using WHERE
• Using Help
• More on WHERE: Joining Tables
• Selecting from the Joined Tables
• Grouping Data
• HAVING, ORDER BY, & FORMAT
• Creating & Altering Tables
• Altering Table Columns
• More on Altering Tables
• Using Indexes
• Unique & Partial Indexes
• Forcing non-Null Values
• Using Primary Keys
• Loading Data: Introduction
• Loading CSV Data (Candidates)
• Loading Tab-delimited Data (Committees)
• Loading Fixed-Width Data (Individuals)
• Checking the Data Load
• Correcting the Fixed-Width Data Load
• Showing the Warnings
• Altering Tables with New Fields & Types
• Updating the Table Data
• Adding Security

Adding MySQL to PHP

• Overview
• Structuring the PHP File: Include Files
• How PHP Catches MySQL Errors
• The MySQL/PHP Syntax
• 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
• Revising the Includes
• Getting ZIP Code Data from MySQL
• Implementing the WHILE Loop
• Cleaning Up a Bad ZIP Code
• Changing the Info Window Text Pt.1
• Changing the Info Window Text Pt.2
• Using Alternate Markers

Building Mashups from External Data

• Overview
• Registering for Amazon Web Services
• Registering for eBay
• Retrieving Data from Amazon
• Adding the Keywords
• Testing the URL & Looking at XML
• Sending the URL & Retrieving the XML
• Parsing the XML
• Generalizing the Parsing in a PHP Function
• Creating an Amazon Link Pt.1
• Creating an Amazon Link Pt.2
• Finish the Formatting of Multiple Authors

Course Summary

• Course Summary

About the Author

• About the Author