The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Use PHP to build a search engine optimization app, Part 2: Creating reports and billing clients

Track your SEO efforts with PHP, Derby, and some ingenuity

Tyler Anderson (tyleranderson5@yahoo.com), Freelance Writer, Stexar Corp.

Tyler Anderson formerly worked for DPMG.com, an SEO company, for whom he wrote proprietary SEO software. He graduated with a degree in computer science from Brigham Young University in 2004 and has just graduated with a Master of Science degree in Computer Engineering in December 2005, also from Brigham Young University. He is currently an engineer for Stexar Corp., based in Beaverton, Oregon. You can reach Tyler at tyleranderson5@yahoo.com.

Summary: PHP, a dynamic Web-based programming language, takes a variety of input formats and has a built-in SOAP client to obtain information from the Web. PHP, combined with applications using search engine optimization (SEO), is a powerful tool for obtaining information from major search engines, allowing this information to guide a webmaster's online marketing and SEO strategies. In this final part of a two-part "Use PHP to build a search engine optimization app" series, we add two search venues and the functionality to search all or just one of the search engines. You will also extend the Apache Derby database to provide support for billing clients.

View more content in this series

Date: 21 Mar 2006
Level: Intermediate
PDF: A4 and Letter (755 KB | 33 pages)Get Adobe® Reader®

Activity: 7209 views
Comments:

Before you start

This tutorial is for PHP programmers and webmasters interested in extending the application from Part 1 of this two-part series. The example application will be extended in the following ways:

To allow a user to choose which of the supported search engines to obtain positions on
To allow an SEO provider to bill clients based on positions obtained for clients, while providing a positions summary, as well as a billing summary in CSV format
To add Ask.com and the Open Directory Project as possible search venues

About this series

This series creates a search engine optimization application that connects to search engines to obtain client positions for a given list of URLs and keywords. Matching results will be stored in an Apache Derby database for later processing.

Part 1 sets up and builds the back-end database and application in PHP. This includes code to retrieve positions from the three top search engines.

Part 2 adds functionality to search Ask.com and the Open Directory Project. You'll also extend the database and application to automatically bill clients, and provide two summary files in CSV format.

About this tutorial

This tutorial extends the application written in Part 1 to allow a client or SEO company to choose which of four search engines and one directory to search from. A new search engine and directory, Ask.com and the Open Directory Project, will be added as search venues. Lastly, we implement functionality in PHP that will automatically create two CSV file reports, a positions and billing summary, that can be imported into spreadsheet software.

Prerequisites

The following tools are needed to follow along:

Web server: Any operating system and any Web server can be used. Feel free to use Apache V2.X or the IBM HTTP Server.

PHP: Due to the use of PHP data objects, PHP V5.1 or higher is required for this tutorial. Be sure to configure PHP with the following option to include support for Derby and the SOAP extensions: --with-pdo-odbc=ibm-db2,/home/db2inst1/sqllib --enable-soap. See Resources for information about configuring Apache or the IBM HTTP Server with PHP.

Database: This tutorial uses Apache Derby, which is open source and lightweight, the IBM DB2 JDBC Universal Driver, and the DB2 runtime client from IBM. Make sure that you have set your classpath appropriately by following the given instructions on each page. You can follow either the Linux® or Windows® instructions for installing and downloading the DB2® runtime client.

Cloudscape may also be used for this tutorial. The internals of Cloudscape are the same as Derby, however, the DB2 JDBC Universal Driver and other things are packaged into Cloudscape, and it is supported by IBM. Download Cloudscape V10.1, and the DB2 runtime client from IBM.

Java™ technology: Derby requires Java technology from Sun Microsystems or from IBM.

Developer and application tokens: Each major search engine requires that you pass along some sort of ID with your SOAP or REST request for search results. You need to get one from each of them: Google, Yahoo! and MSN.

This tutorial assumes basic PHP knowledge of PHP syntax, including assignments, for loops and functions, and so forth.

Comments