PHP / MySQL : WEB DEVELOPMENT RESUME    Page 1  Page 2  Page 3

   The following pages describe 3 years of commercial experience in programming enterprise level web applications using PHP language and MySQL database interactions to create dynamic web content. All projects were developed from concept to completion by myself as the sole code writer. For contact information, click here.


Page 1
PROJECT: SyncDaddy.com
SyncDaddy.com is a music licensing service providing a searchable library for any music industry professional such as a film, tv or adversting producer to sample and license music tracks to use in their productions. SyncDaddy has a robust search engine for the music library and a unique licensing system that takes payments and automatically delivers the end product. Javascript is used in sections that need form validation or error correction, but the core is PHP and MySQL.

The library database was populated to over 3000 music tracks by staff members entering the track info via a custom input form:



When a visitor to the site searches the music library, they are given a selection of general searches or they can use the advanced search for more detailed criteria:


The Advanced search page allows multiple cross-field searches and can be used to retrieve exacting results.

Once a search has been submitted, a detalied display of the results was needed along with the ability to preview a sample of the audio file.

Each track entry in the database contained a link to the audio sample, and along with the data, a link to a customized photo or artwork file.


Here's an example of a dynamic search results display page of a music track:



Once a selection was chosen, the licensing process needed to be started. The "license this track" link on the display results starts a very unique process that determines the licensing fee based on how the music will be used and in what markets.

    To license the track, a form finds out how it will be used:
... and then asks them to bid on the fee...

Instead of posting any publically published licensing fees for each type of license - ranging from educational use all the way to major motion pictures - SyncDaddy wanted producers to "haggle" a bit for the fee, since most of SyncDaddy's pricing undercuts their competitors' by a wide margin.



Once a bid has been entered the program checks it against the minimun fee which has been calculated from a formula that was running during the choices stage. If the bid was higher than the minimum, then the bid is accepted and the payment process is started.


If it was below the minimum, SyncDaddy encourages you with a "cold to hot" meter and prompts you to re-bid!
When the minumum bid has been met or exceeded, a syncronization license contract is populated with the customer's data and the music track's data. This is emailed to both staff and customer, and the customer is then taken to a standard credit card merchant e-commerce solution. When payment notification approval is received back from the merchant account provider via another custom php script, the link data to the final product file is retrieved from the database and emailed to the customer, as well as creating a new entry into a clients database. Now clients can have a personal page at SyncDaddy.com that contains a favorites section, history, purchased download links and a faster licensing process for their next project.
Logging in to SyncDaddy's home page takes a customer to their own client access page, which is "template" based so that it can grow and evolve as more needs are identified and met. Many industry leaders like Fox Networks are among the companies that have custom pages at SyncDaddy. For some clients, a special "toolbox" is offered as a way for staff members to suggest music tracks from the library based on specific needs of the customer.

The SyncDaddy.com search and licensing system is 100% automated and requires no human involvement to find and license a music track, take payment and deliver the end product. The development is based on the visions of SyncDaddy, Inc. and the responses from a detailed survey sent out to industry professionals concerning what they liked and disliked about how they currently license music tracks.

To see SyncDaddy.com in it's live form, please visit http://SyncDaddy.com.

Source code is available for review by request, and only for the purposes of establishing experience level.


>> Next Page