Review - phpAdsNew Banner Management System

Now that we've created our phpAdsNew database, we need to import the table structures for it, which can be found in all.sql in phpAdsNew's main directory. Jump onto your MySQL server and import the contents of all.sql, like this:

mysql -uadmin -ppassword phpads < c:\phpadsnew\all.sql

I've installed phpAdsNew on my Windows 2000 server running Apache, so obviously if you're running Linux, then you'll need to change the path to all.sql. MySQL should respond with a blank line. If you get any errors, double check your login credentials as well as the name of your database and where you're telling MySQL to find all.sql.

Now, load phpAdsNew in your browser. I installed it locally on my Web server, so I loaded up http://localhost/phpadsnew. Here's what it looked like:

Enter the values for the user and password that you specified in the config.inc.php file and click on the login button. The phpAdsNew stats screen will load:

Using phpAdsNew

phpAdsNew has zones, clients, and banners. First off, we want to add a client, so click on the administration tab and then the 'add new client' link. Complete the details of the client when the page loads. Before you click on the save changes button, you should think carefully about whether or not you would like to allow this client to login to your phpAdsNew system and modify his or her campaign.

If you'd like to give your clients the flexibility to change their banner whenever they like, then you should enter a username and password for them and select the appropriate checkboxes for them, which are shown below:

When you're done, click on the save changes button. phpAdsNew will now let you create a new campaign for this client. The great thing about phpAdsNew is that you can either set how many impressions this clients ad will have, you can set both activation and expiry dates for the ad, or you can just let the ad run for as long as you like.

The weight field is the frequency at which the ad will be shown. The default is 1, but you can set it to a higher value if you'd like the ad to appear more frequently than others if it's in a rotation.

Set the options for this client's campaign, and click save changes. phpAdsNew will create the new campaign and redirect you back to the zones page. To create a banner for this client, click on the create link under their campaign: