Mashups Web Apps 2 Tutorial Try for FREE

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Mashups Web Apps 2 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

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