#!/usr/bin/perl -w
use DBI;
use Date::Calc qw(Today);
use CGI qw(:standard);
print "Content-type: text/plain\n\n";
$theDB = DBI ->connect ('DBI:mysql:ecsmedia', 'ecsmedia', 'S3cq8esL') or die("Cannot connect.\n");
($year,$month,$day) = Today();
$theProduct = param("filename");
$theDate = "$month/$day/".substr($year, -2);
$theReferrer = $ENV{'HTTP_REFERER'};
$Query = "SELECT * FROM productCounters WHERE Product='$theProduct' AND Date='$theDate'";
$result = $theDB->prepare($Query) or die("error preparing SQL\n");
$result->execute() or die("error executing SQL\n");
if (@row = $result->fetchrow_array) {
$newCount = $row[2] + 1;
$newReferrer = $row[3].",".$theReferrer;
$Query = "UPDATE productCounters SET Count=$newCount, Referrers='$newReferrer' WHERE Product='$theProduct' AND Date='$theDate'";
$theDB->do($Query) or die("Invalid update");
}
else{
$Query = "INSERT INTO productCounters (Product, Date, Count, Referrers) VALUES ('$theProduct','$theDate','1','$theReferrer')";
$theDB->do($Query) or die("Invalid insert");
}
$result->finish();
$theDB->disconnect();
| |
 |
HARMONIC PROGRESSIONS
Vincent Oddo
Harmonic Progressions is designed to help the user improve skills in
functional harmony analysis. Studies include Root Position Chords, Inverted
Chords and the V7, Embellishing 6 Chords and the V7, Diatonic 7ths and
Cadence Patterns. Questions are drawn from a pool of over 200 chord
sets. Each area includes practice in analyzing chords, harmonic dictation,
and aural identification. The format of the Harmonic Progression Series
is as follows: a chord is sounded harmonically. The user must then detect
the quality, position and voicing of the chord. The correct answer is
displayed at the end of the example. Requires MIDI. Windows version
requires either a sound card or MIDI
|
| |
Download Windows
Demo
Download Macintosh Demo
|
Hybrid CD-ROM: 1338CD
Single Station Price: $59.95
Lab Pack (5 stations) Price: $160.00
Site/Network License (24 stations) Price: $480.00
System requirements: Win 98, 2000, XP Mac OS 8.5-9.2, 10(in classic mode)
|
