
Mashups (Web 2.0 Web Apps)
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.
Course content
Introduction4 lessons
Business Models & Legal Issues for Mashups5 lessons
Mashup Architecture & Technology6 lessons
The Campaign Contribution Mashup Data7 lessons
- Introducing the Data & the Mashup6:121 credit or ad
- Campaign Data3:091 credit or ad
- Looking at the Candidate Data Files4:111 credit or ad
- Converting Candidate Data with Excel Pt.13:581 credit or ad
- Converting Candidate Data with Excel Pt.26:471 credit or ad
- Converting Candidate Data with Excel Pt.35:251 credit or ad
- The Campaign Contribution Data Model4:041 credit or ad
Writing the Mashup with JavaScript16 lessons
- Starting the Mashup4:351 credit or ad
- Getting Access to Google Mapping6:031 credit or ad
- The Most Basic Mapping Mashup4:401 credit or ad
- Testing the Basic Mapping Code1:551 credit or ad
- Structuring at the JavaScript Code3:311 credit or ad
- Modifying the Basic Mapping Code2:591 credit or ad
- Making the Map a Global Variable6:101 credit or ad
- Adding a Marker with a Function4:531 credit or ad
- Adding Information to a Marker6:191 credit or ad
- Customizing Markers3:181 credit or ad
- Adding Map Controls2:431 credit or ad
- Introducing Geocoding3:021 credit or ad
- Restructuring the Code4:321 credit or ad
- The showAddress Function3:551 credit or ad
- Running the Geocoder2:051 credit or ad
- Generalizing showAddress7:001 credit or ad
Adding PHP7 lessons
- Introducing PHP3:081 credit or ad
- Mixing HTML & JavaScript with PHP2:361 credit or ad
- Generating HTML from PHP5:101 credit or ad
- PHP Basics: Comments3:041 credit or ad
- PHP Basics: Strings & Concatenation4:341 credit or ad
- PHP Basics: Variables & Defines2:431 credit or ad
- Using PHP with Forms2:201 credit or ad
Adding MySQL29 lessons
- Running MySQL on Windows2:571 credit or ad
- Running MySQL on Mac OS X4:381 credit or ad
- Configuring MySQL on Windows1:431 credit or ad
- Roadmap for the Rest of the Chapter5:391 credit or ad
- Overview of SELECT2:081 credit or ad
- Describing the Table & Selecting Data4:541 credit or ad
- Using WHERE3:071 credit or ad
- Using Help1:441 credit or ad
- More on WHERE: Joining Tables2:551 credit or ad
- Selecting from the Joined Tables6:501 credit or ad
- Grouping Data4:151 credit or ad
- HAVING, ORDER BY, & FORMAT3:541 credit or ad
- Creating & Altering Tables5:191 credit or ad
- Altering Table Columns3:221 credit or ad
- More on Altering Tables4:361 credit or ad
- Using Indexes6:121 credit or ad
- Unique & Partial Indexes4:551 credit or ad
- Forcing non-Null Values2:091 credit or ad
- Using Primary Keys1:321 credit or ad
- Loading Data: Introduction4:361 credit or ad
- Loading CSV Data (Candidates)6:191 credit or ad
- Loading Tab-delimited Data (Committees)4:101 credit or ad
- Loading Fixed-Width Data (Individuals)6:111 credit or ad
- Checking the Data Load3:451 credit or ad
- Correcting the Fixed-Width Data Load3:261 credit or ad
- Showing the Warnings1:031 credit or ad
- Altering Tables with New Fields & Types4:071 credit or ad
- Updating the Table Data6:541 credit or ad
- Adding Security4:501 credit or ad
Adding MySQL to PHP15 lessons
- Overview3:051 credit or ad
- Structuring the PHP File: Include Files6:361 credit or ad
- How PHP Catches MySQL Errors1:501 credit or ad
- The MySQL/PHP Syntax4:081 credit or ad
- Constructing a MySQL Query in PHP5:101 credit or ad
- Executing the Query/Beginning HTML Table4:001 credit or ad
- Filling the HTML Table with MySQL Results6:011 credit or ad
- Using the Mapping API with MySQL Data1:561 credit or ad
- Revising the Includes5:371 credit or ad
- Getting ZIP Code Data from MySQL4:551 credit or ad
- Implementing the WHILE Loop3:291 credit or ad
- Cleaning Up a Bad ZIP Code3:531 credit or ad
- Changing the Info Window Text Pt.13:231 credit or ad
- Changing the Info Window Text Pt.25:061 credit or ad
- Using Alternate Markers6:121 credit or ad
Building Mashups from External Data12 lessons
- Overview5:031 credit or ad
- Registering for Amazon Web Services5:281 credit or ad
- Registering for eBay2:501 credit or ad
- Retrieving Data from Amazon5:191 credit or ad
- Adding the Keywords3:161 credit or ad
- Testing the URL & Looking at XML5:031 credit or ad
- Sending the URL & Retrieving the XML5:491 credit or ad
- Parsing the XML6:121 credit or ad
- Generalizing the Parsing in a PHP Function3:491 credit or ad
- Creating an Amazon Link Pt.14:541 credit or ad
- Creating an Amazon Link Pt.23:531 credit or ad
- Finish the Formatting of Multiple Authors4:451 credit or ad