News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Developer Drive:
Building a PHP Ad Tracker Creating the Database Tables
January 16, 2012 @ 12:48:30

On Developer Drive today there's a new post (the first in a series) from Gerald Hanks about building an ad tracker in PHP. In this first part he sets up some of the background - the database that will hold the tracker information.

Banner ads for services related to the web site owner's industry allow customers to view products that tie into the site owner's core business. In exchange, the web site owner can charge the banner ad owner for every impression (banner ad appearance) or click-through (when a user clicks the banner ad). In order to build a banner ad management system, we must first create the database tables that will hold the ad information, the client data and the activity schedule for each ad.

He includes the SQL you'll need to create a few tables - the tracking table for the ads themselves (their metadata), the clients table to handle the groups wanting the ads and the activity table to track views and click-throughs.

0 comments voice your opinion now!
ad tracker database table tutorial clickthrough


blog comments powered by Disqus

Similar Posts

IBM developerWorks: Developing PHP the Ajax way, Part 2 - Back, Forward, Reload

Linode Library: Deploy High Performance Drupal Sites with Mercury on Ubuntu 10.04 (Lucid)

SitePoint PHP Blog: Message Queues: Comparing Beanstalkd, IronMQ and Amazon SQS

Zend Developer Zone: Fetching multiple random rows from a database

Mohammed Berdai's Blog: How To Install PostgreSQL And phpPgAdmin Support In XAMPP


Community Events





Don't see your event here?
Let us know!


community framework api podcast package tips zendserver series deployment list laravel symfony update release introduction install interview opinion library language

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework